DSXchange

Ooops I am sorry.. It was a typo .. I meant Datastage 6.0

I am using Datastage 6.2 version. Do this version has MQTOPIC plugins and JMS plugins.

We faced a similar problem once. It was because one of the lookup link was fetching a large amount of data and the operations defined in the transformer was failing. You try to see the performance statistics in the designer while the job runs and see any of your look up links really stucks while pro...

I feel you need to find out why data is not there in the parent table. The Constraints are defined in the table to ensure data integrity. If you miss records as the result of an integrity constraint violation, I feel we need to find out why the required data is not found in the parent table. If the ...

Thanks for the Info. I will have some investigations on this line.

But still, all the time, when this happened, on the second attempt the job went fine. Now I am suspecting whether we miss some data.

If you are not doing a lookup inside your job, create a sequential file first. And later when the hash file is required create the hash file. I think you need to specify all the six keys when you create the hash file. Hash file is just like a table and the keys acts as if it is the primary mentioned...

A few of our jobs that runs in production daily, sometimes get aborted with the following error. "JobNAme..IPInvoiceLkp.IDENT3: ORA-01410: invalid ROWID". If we reset and rerun, the job will complete successfully. Can anybody help us to sort it out. What I don't understand is, why it runs ...

If you just want to see data of RT_LOG table of a particular job, you can use DataStage Administrator. From Administrator choose the project and click on the execute command. In the resulting window give the following command. SELECT @ID,TYPE,WAVE.NO,TIMESTAMP,MSG.ARGS,MSG.TEXT,FULL.TEXT,SEVERITY FR...

The following OConv conversion will replace all control characters by a "."

OConv(The Field,"MCP")

Smitha