DSXchange

Commits are 'delivered' at the row count indicated in the 'Rows per transaction' setting, everything after that is up to Oracle to handle. There's no commit because my UNDO tablespace get full. I didn't take a look at my target table, I'll start a test again and I'll tell if rows are changed after t...

Interesting, never noticed that in the pdf. Page number? It would seem a small test is in order.

Odd... doesn't seem right. What's your O/S and exact version of DS? I'd report this to your support provider and see if it is a known issue or bug.

Sorry, yes - incorrect. Read the help for the stage: "it is ignored for release 3.0 and later of the Plug-in". In other words, once they introduced the Transaction Size tab.

Make sure you enable the 'Only run after successful completion' option.

Um... no. PX only. "All figures (except the row count) are zero"? Are you saying that you are looking in the 'Finishing (...)' messages for the active stages in the job log and only see zeroes for the CPU usage and elapsed seconds? Or have you turned on Tracing during the job run and those entries o...

Ok... keep in mind the fact that you really are asking Oracle questions, not DataStage questions and that these questions should really be asked of your DBA. DataStage isn't magical or any different from any other process doing DML in the database. By the way, you've never said what the exact error ...

np... did you manage to fix your issue?

From searching the forums here, the first thing to try would be to REINDEX the project and see if that helps.

Posted: Tue Aug 24, 2004 7:42 pm

Your custom DateIconv routine doesn't seem to be in the new project.

Double-click on it - what does it say then?

Any particular error or can we guess?

No, @FALSE is not what you need in this case as that will prevent any rows going down the link. Sounds like you want @OUTROWNUM=1 in this case.

Now, In the OCI stage, I selected "User defined Query" and my custom SQL statement was: UPDATE TABLE1 SET Col3 = 'DSX' WHERE Col3 = 'DSX%' Note: The OCI stage has all the columns of the table in the metadata, not the just 'Col3' which is supposed to be updated. Can't do that! All columns defined in...