DELIMITER IN MLOAD STAGE

[virupakshagm]

Hi,

Source is sequential file with TAB as delimiter and Target am using Mload stage.

I am trying to load the data with data format "VARTEXT" and Tab Delimiter as TAB or \t . But getting an error msg "UTY4016 Data item too large for field BP_RELTYP in vartext record number 1"

No doubt i could Load with Data format "FASTLOAD"

Please suggest me, am i giving the delimiter correctly or not

Regards,
Viru

[ray.wurlod]

The message suggests that the data in BP_RELTYP field is larger than what the metadata specify for it.

[virupakshagm]

Hi Ray,


But my job is successful with the fastload optins and i want to know are the delimiter i am giving correct or not.

please suggest.


Regards,
Viru

[kdkboy]

Hi,

Source is sequential file with TAB as delimiter and Target am using Mload stage.

I am trying to load the data with data format "VARTEXT" and Tab Delimiter as TAB or \t . But getting an error msg "UTY4016 Data item too large for field BP_RELTYP in vartext record number 1"

No doubt i could Load with Data format "FASTLOAD"

Please suggest me, am i giving the delimiter correctly or not

Regards,
Viru

This is a teradata issue, better check the teradata fastload manual

in teradata fastload, there is a place to set file format
that could be three format:
fastload
varchar
text

I am curious how fastload could success while log have error

[chulett]

Any chance that the value that's too large in 'record number 1' is the column header?

[virupakshagm]

chulett, No chance

[bollinenik]

Hi,
You can check your self , Is delimiter correct or not by checking view data.
Once you are able to view Data properly then come to Target Mload stage and inside NLS tab check UTY option, try to change that or try to view data in TEXTPAD, so that you can find the Difference in Data.
I am trying to give you debugging options, so that you can solve the probelm your self.