DSXchange

Hi All,

I have two jobs as below running in sequencer.

1. teradataenterperise->transformer->odbc-teradata

2. teradataenterperise->MQ->column export->MQ

When the messages are entering into MQ it is getting truncated.

we first add the APT_PADCHAR='0X20' in the second job.

now only some records which undergone transaction in first job got truncated.

next we add the APT_PAD_CHAR='0x20' parameter to first job also.

Now the length of data getting truncated is reduced, nuy the whole data didn't entered MQ now also.

I try to write the same data in to sequential file, there it is writting fine.

the truncation happen only when writting into MQ

Most likely your the width of the MQ Queue you are writing to is too small.

But the truncation happen only in some data which got transformed in first job. remaining data is entering the queue as whole

That means that your "some data" is different from the rest. Does it contain 0x00 characters?