DSXchange

Its working fine.

Thank you so much for all your help.

Shilpa.

Basically the problem is the first record has 16columns , the second record has 12 columns the last four colums of the second record need to be loaded as empty.However there are no pipes delimiting these empty fields.And there is also no row delimeted. My question is how do you import the data with ...

I donot see any truncation warnings...........

16 columns

Yes, I did

Shilpa.

Yes, I got this message when I view the seq file.

for eg:
The input record:
470E|hyd 3721|hyd! Consolidated||Intl||sar||North Asia||||Total ind||470E|ap! 3721

And total we have 16fields and in the file we are not getting all the colums for all the records.

Shilpa.

While loading the DB2 tables i am facing lot of issues like: 1)The system size is full 2)If I want to view the data the Job just hangs up for a while without any errors and warnings. And Again If I run the Job for second time it runs successfully. Why we are getting each and everytime diff issues in...

Untitled1..Sequential_File_5.DSLink6: read_delimited() - row 5, column Field015, required column missing

I am getting this error while loading from sequential file to Oracle table.
Could you please let me know which is the best way to solve this issue.

Shilpa.

Can you plz let me how to pass messages from DB2 to XML and then to MQ.

Hi, I have some store level information in which i am tracing the store number,units e.t.c,and we have 7 stores information currently so I am trying to group by store level.when we r passing all the messages to XML output and from there to a queue the limit is 2mb and for each sore level we r giving...

k