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
messages getting truncated when writing into MQ
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Sun Mar 25, 2007 11:05 pm
- Location: chennai
messages getting truncated when writing into MQ
thanks & Regards
A.S.Porkalai Lakshmi
A.S.Porkalai Lakshmi
Most likely your the width of the MQ Queue you are writing to is too small.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 38
- Joined: Sun Mar 25, 2007 11:05 pm
- Location: chennai
That means that your "some data" is different from the rest. Does it contain 0x00 characters?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>