DSXchange

I would like to leave the management of the discards to oracle, so that to produce 1 only file of errors I believe is impossible that cannot be done, but from the few information that I have found on the use of the reject in the stage oracle it seems that it always involves this way I can't check th...

It is an invalid string that fails conversion to date (example 34-01-1978). if the error is a violation of a constraint the job run and create the reject file, if the error si an invaild string, the job fail without any string file. The statemant that I have insert into stage: INSERT INTO TEST_OUTPU...

It is an invalid string that fails conversion to date (example 34-01-1978). if the error is a violation of a constraint the job run and create the reject file, if the error si an invaild string, the job fail without any string file. The statemant that I have insert into stage: INSERT INTO TEST_OUTPU...

I have found exacty the same problem. The reject link works only if the error is a violation of oracle costraint. If the error concerns other reasons (example: wrong date) the job fails without producing discards. does somoneone use the reject link, from a target stage oracle, in correct way also fo...

I have found exacty the same problem. The reject link works only if the error is a violation of oracle costraint. If the error concerns other reasons (example: wrong date) the job fails without producing discards. does somoneone use the reject link, from a target stage oracle, in correct way also fo...

thanks for your replay. In the statement DS write: INSERT INTO TEST_OUTPUT (C_1, D_2) VALUES (ORCHESTRATE.C_1, to_date(ORCHESTRATE.D_2, 'DD/MM/YYYY')) INSERT INTO TEST_LORENZO_OUTPUT (C_1, D_2) VALUES ( :C_1, to_date( :D_2, 'DD/MM/YYYY')) is write in the log. can I change the name of parameters? I d...

Sorry,
I have been a wrong at my first post....
I was sure to have posted in the parallel forum!
can I move this message?
thanks

Hi, I'm a newbie of this forum and DS. I have a problem with the reject link of Oracle Enteprise Stage. In my test, i want read an oracle table (2 column-varchar2 255) and insert record in other table (1 column-varchar2 and 1 column-date). I would like to make control directly in the oracle stage, e...