DSXchange

Probably 4000 rows finished quickly enough that there was no timeout before the COMMIT could be sent.

Welcome aboard. :D

Where do you want to do the looking? A suitable query is
JOBTYPE decodes as:
0 - server job
1 - mainframe job
2 - job sequence
3 - parallel job

Then mimic precisely what DSSendMailTester does and/or copy existing (working) code from somewhere else in Target. This is a big company that has been using DataStage very professionally for some years. Don't try to re-invent their wheels.

Job properties. General tab. Add checkpoints.

How many CPUs do you have? How much memory? You are trying to run 120 jobs simultaneously here. Good luck.

Yes. You can hack the DS_JOBOBJECTS table. Of course you would need to know the structure of this table, which is not documented. Further, since the parameters collection location within the record is not in the file dictionary for DS_JOBOBJECTS an SQL-based approach is not available; it would have ...

Check the Automatically Handle Activities that Fail check box prior to compiling the job sequence. If you have any explicit failure handling in the job sequence, make sure that it triggers something that a final check in the job sequence can detect and cause itself to fail (perhaps via the routine U...

Slow it may be, but suggests that the issue is with these settings. To what values were they set previously? Try increasing judiciously (from 1), making sure at all time that rows per transaction is a multiple of array size.

Try The Data Warehouse Institute (www.tdwi.org). A Google search for "Ralph Kimball" will find some more. And IBM (www.ibm.com) has some Red Books and white papers.

It ought not to be a difficult routine to write. Just initialize the answer to "" and iterate through the string one character at a time, appending the character to the answer only if the character is between '0' and '9'.

Search the forum for SIGSEGV (segmentation violation). Reduce demand for, or increase supply of, memory.

Have you tried without the semi-colon?

Have you tried with the table name qualified with its owner name?

The best approach would be to write out a detailed specification of what needs to happen under various scenarios, and to design accordingly. It would be really useful if the target included some way to recognize when it was most recently updated - either a timestamp or a unique run ID. Even though y...

Do you have SOA edition licensed?

Please post the data type, initialization expression and derivation expression for the stage variable in question.

Yeah? How, precisely?