DSXchange

Tks

Please,

Somebody can inform which to me is the function of datastage that it is equal to the LPAD of the Oracle.

Tks

Please, I Need to construct to one routine that reset one job. Somebody can help me.

Tks

This error does not give in only in one job, gives to all that one has select and one insert. These jobs functioned before, only that I migrei they stops another environment, and started to give these errors. See mys query: This is in select : SELECT TB_VENDASDSHEADER_LDR.VENDASH_CDSALESORGANIZATION...

I Not use procedure or function. I am making select in a table and loading in another table. If I make in oracle executes normal but in datastage it gives this error.

I am with a problem: I created one job that it has two objects oracle(OCI) in first I make one select and in second I make one insert with data of firt select When I execute I give the following error: teste2..VendasDSHeader.IDENT1:..trf_Item_LDR: ORA-24338: statement handle not executed. VendasDSHe...

I have a Job that one is seting in variable and in one of the two jobs that it is calling for the Job Control. Necessary that before executing same they they are resetados. Please Help me and sorry for my english. It follows the code below: * Setup JobExecucao_Bat_Vendas, run it, wait for it to fini...