Hello,
I have a job design like below -
MQ Connector -> Transformer -> DTS
Here in DS, I have given the column datatype as LongVarchar with no length provided.
I am reading a XML file coming from MQ and loading into a Oracle table with column datatype as CLOB.
The job completes successfully and I see the XML message getting added into the table.
But when I retrieve the data from the CLOB column, I see only partial XML message.
Here for retrieving, in the DS job, the column datatype is LongVarchar without any length and the Array size is 1.
Can someone suggest how this data is getting truncated?
XML data getting truncated while loading into CLOB column
Moderators: chulett, rschirm, roy
Have you verified where this data is being 'truncated'? Meaning, if you check the COLB outside of DataStage, say with Toad or something similar, is it whole in the database. Also a bit curious why it's not being stored as an XMLTYPE...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Do some searches in the forum here.....you might be running into defailt size limits for what can go out on a link......there are several APT vars to consider.....they are something like APT_DEFAULT_TRANSPORT_BLOCKSIZE and used to be too small for large MQ msgs. make it bigger.....
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>