DSXchange

I've tried to use ORA OCI Load but I've the same probelm. Usually I use Oracle OCI 9 stage with an oracle user who's not the owner of the table where I'm loading and the job finishes OK ! instead if I use the ORa BULK stage with the same oracle user the job finishes NO !. I need to use an oracle use...

Hi,
I'd need help to use correctly the ORABULK stage.
My problem is how to manage the access with ORACLEBULK to the DB. I need put in the Properties the schema owner as oracleuser or I could use another oracle user who has the grant wo insert to the table I want loasd ?

Many regards

LP

Hi, I'm working with DataStage on Teradata for designing job mainframe and job server. Now I have a problem: I can't launch a stored procedure, created in Teradata, with the teradata plug-in. In DS Teradata plug-in I can't launch a delete, select, update and insert but not this expression: CALL DXDB...

Hello ! my problem is:
I have a job mainframe who uses transformer and ect. Now I should create another job very similar to the first, the only different thing is the input file, so it is possible to pass a job parameter with the DDNAME input file ????


Thank you

Hello !

I'm working with DataStage on OS390 but I have a problem: all my jobs, that contains lookup or aggregator stage, end with error ABEND 0C4 during running step. This happens when COBOL program calls $MALLOC module. Why ?

Thanks a lot !

Hello,

I should extract audit informations as JobName, StageName ect. from a Mainframe Job compiled and launched by Host. How could I do this ?

Thank you[:)]

Thank you Mat, DSMakeJobReport works well !!!

Have a nice day

Hello ! I'm working with DataStage on Os390 and I'd like to know if I can read files who contain data and files who describe data structures (copy) in DS, so I could use jobServer to migrate data from host to rdbms. Another question: If I decide to use JobMainframe then how could I take compiled cob...

Thank you MAT, but I have never seen DS function DSMake Report, could you tell me more about it ?

Thanks

I don't know MetaStage very well, could you tell me more about it.
I need these information:
- job name
- job stage name
- start date
- end date
- during time
- rowcount
- row rejected
ect

How can take them from Metastage while job is running ?

Thank you !!!

My problem is:

I should intercept messages or information between stages (eg. number of rows processed, transformation applied, ect) and write a sequential files to insert in my audit db.
How could i do ?

Thank you !!!!