DSXchange

Hi, we have source as sequential file with ^| as delimiter and Target is teradata loaded using Mload stage. I am trying to load the data with data format "VARTEXT" and Delimiter as ^|. while loading received error message as "UTY4016 Data item too large for field END_DT in vartext rec...

Specify a dummy file name in the xml output stage: say(temp_xml) and in the After job subroutine call mv command with the parameters values so as to rename dummy file with the parameterized value.

Thanks Everyone,

I got a workaround for this issue. We are converting input file present in "ISO-8859-1" format to "UTF-8" format using unix command and then passing the file to datastage to create XML file.

Thanks Ray ...

I checked it out after disabling operator combination. This error is coming from XML Output Stage.

I am fetching files possessing "ISO-8859-1" characterset and writing it into a different unix box with "UTF-8" characterset.

Regards,
Manish