DSXchange

hi,

you could get better result if you switch the order of col 2 and col 3 from input link before going to collector stage... for ex: by a transformer

Definitely you need to have order of columns

Hi,

You should have same order of columns but not the order of links unless you want to maintain any kind of sort in the output

I would suggest that try to remove those junk characters from table emp2 of that lookup column before feeding into look up and give it a try

Hello,

You can also have a oracle look up of that sequence to the transformer and attach it to the output

Hi All,

Can anybody let me know a way to load directly a created sequential file to a oracle table which has one of the field with datatype as CLOB??

Any approach with in datastage would be appreciable...

Thanks

Ravi Metla

The reset normally doesn't need the sequential file to exist, it sounds more like you are doing a validate. What is your UNIX dsjob call to do this? This thread does not belong in the FAQ, but in either the server or PX forum. the unix dsjob is as below..i am trying to RESET only...not validating.....

Hi All, I have one server job which is having seq file stage and oracle stage...loading file from some input directory in unix and loading into a oracle table...and moving the file to archive directory... when the job runs next time with a new file, my job handling unix code is trying to reset the j...