DSXchange

Hi All,


My job design Dataset---> Transformer stage----> ODBC stage or OCI (Oracle).

Source has 3000 records, my job is aborted after loading in 1500 records. How to load the remaining records in my target Oracle table?

Another question: I want to load records if the job successfully completes. Is there any option for that in DataStage?

Thanks in Advance.

You can set the transaction size. Setting it to 0 means ALL / None approach

Regards
Sreeni

Sreenivasulu wrote:You can set the transaction size. Setting it to 0 means ALL / None approach

any other way?

Any other way to answer your second question? No.

We are just guessing as to the likely cause without getting the detailed error message from you. The specific SQL or database error message. It could be your transaction log filling up or any one of a number of possible errors.