DSXchange

I have seen several questions about extracting the log information. This is not a task I would recommend. It can be one log record per record inbound. To extract that is not wise because when you have issues then these processes actually slow you down. I would look for specific things within the lo...

Wich tools/API do you refer?

tks

I'd like to query DB to retrieve information like:
job details, error log after job run..etc.

Hi, I need to know how to manage repository Datastage v8.0.1 If I have usr/pwd to access to repository DB, I can simply do query to retrieve any information? What kind of information I can retrieve? Is there any other way to access to repository? (eg through command on shell Unix...dsadmin,dssh...et...

ArndW wrote:Why not do your truncate as part of the before-sql? ...

Because there isn't before-sql part in stage OCI of parallel job

ArndW wrote:Why not do your truncate as part of the before-sql? ...

Because there isn't before-sql part in stage OCI of parallel job

The Load method is executed outside of DataStage and that is why the single rejected rows and messages aren't visible the way they are with 'upsert'. I think that the error log files should be visible after the job run is finished and has errors, and that file can be read and interpreted. thanks a ...

The Load method is executed outside of DataStage and that is why the single rejected rows and messages aren't visible the way they are with 'upsert'. I think that the error log files should be visible after the job run is finished and has errors, and that file can be read and interpreted. thanks a ...

Hi, I have to retrieve Oracle error messages relating to the rejected records in parallel job. I know only this way: in OCI Stage I can set Upsert as "Write mode" and selecting "Output rejected records" I can retrieve sqlcode associate to rejected rows. If I use Load as write mod...