DSXchange

Hi Ray,

Tried all the options to isolate the problem, I did the preprocessing outside Datastage in UNIX and no luck. Also tried loading the file without trimming off the ^M characters, and still this particular column the spaces were trimmed off inbetween the data. Any more suggestions?

Hi Ray,

Tried all the options to isolate the problem, I did the preprocessing outside Datastage in UNIX and no luck. Also tried loading the file without trimming off the ^M characters, and still this particular column the spaces were trimmed off inbetween the data. Any more suggestions?

This is the pipe delimited input file we get with four fields and the FIELD3 has spaces inbetween the data and End of the line we have the ^M Character (<CTRL>+V+M) FIELD1|FIELD2|FIELD3|FIELD4 ABC|DEF|EFG<SPACE><SPACE><SPACE>IJK|123^M XYZ|WYC|ABC<SPACE><SPACE>12|345^M Its a simple pass through job w...

Hi All, I am loading the DB2 table with one of the extract files we get using the parallel jobs. The file has a character data with values like "ABC XYZ", when the data is loaded into the table the value becomes "ABC XYZ". The spaces inbetween are getting trimmed off. When we loa...

Try giving DSLink4.No <= "105" for the clean and
DSLink4.REJECTED in the reject link.