DSXchange

I believe this a bug in datastage. I don't know about version 5, but we had the same problem in version 6. In a user-defined SQL ,if column name contains oracle reserved words (delete,insert,update etc) the job used get aborted. Later Ascentail came up with a patch that fixed this bug.

Teej,

Thanks for your input. I guess the log, par, ctl files will be generated only if I choose the WriteMethod="Load" and not if WriteMethod="Upsert"

Thanks
Sridhar

Kim, Thanks a lot for taking the time and posting your routine and trying to help me. In response to your fist message about outsourcing, unfortunately I my self am a consultant and looking for answers through the fourm. So you know what I am talking about. As for the routine and reading datastage l...

I am designing a parallel job (Parallel Extender) and using ORACLE stage. If there is a reject becuase of ORACLE constraints violation I need to capture the ORACLE error code and message and log into a table. I was able to do this earlier in a server job (ORA OCI9 stage) by using LinkVariable -> DBM...

Hi, I am designing a parallel job (Parallel Extender), the functionality of which needs to be: A is the source table, B is the target table. Compare data in table A and B, capture changes (insert/update, delete) and apply changes to B. After the job execution is complete data in B needs to resemble ...

I thought about starting a new link but this thread seemed to be relevant for my problem: I am designing a parallel job (Parallel Extender) and using ORACLE stage. If there is a reject becuase of constraints violation I need to capture the ORACLE error code and message and log into a table. I was ab...