DSXchange

This is not possible in the GUI unless you code for it.

DB2, no. ODBC, yes. In the ODBC and UV stages only there is a multi-row return property (actually set in the Transfomer stage on the link properties). Look for "multi" in on-line help, or search the forum.

Lost the Sort stage, rely upon the ORDER BY clause in the SQL to sort the data properly. Ensure that your data types match absolutely.

Of course you can have forever-running jobs. We just don't think they are a great idea. The Wait For File activty in a job sequence can wait forever, but how would you shut that down gracefully? You could build a loop in a job sequence that checks for the file (Wait For File with a short interval), ...

Is the source a text file? If so, how is NULL represented in that particular column? You may need to visit the extended properties (Edit Row in the Columns grid) to find out.

No, it's separately purchased, for about the same price as a psychology degree from a good university.

The description of "reset" is "do everything except process rows".

The original question stipulated "in DataStage Administrator" To execute a UNIX command from Administrator use the SH command. For example SH -c "dsjob -ljobs <Project Name> | wc -l" To execute a DOS command from Administrator use the DOS command. For example: DOS /C "dsjob -ljobs <Pr...

There are no pointers - as understood in C - in the VOC file. There are pathnames to files and to routines/commands. There are lots of other things as well - every word/token that you can use in a TCL command (other than field/column names, etc.) exist as entries in the VOC file which, as others hav...

Historical Notes Ur was a city in ancient Babylon. It has no place in DataStage documentation, which includes posts on this forum. U was the first name of a UN Secretary General (U Thant, since deceased, so unlikely to be doing anything at all with DataStage). Grammatical Note "wont" is a noun. "wo...

Let me ask this question; even when there is a problem reported with close() do the data all get written to the file?

Why?

You have not seen a score, so can not assert that sorts have been inserted, and do not know what partitioning has been used. In this job design, (Auto) should use the same partitioning right through, so forcing it to be Same achieves nothing.

Why?

IBM consultants use a metholology called ITERATIONS. The first couple of steps establish whether or not the client is even ready to undertake an ETL project - this can be an important predictor of failure. They used to sell the methodology - I'm not sure whether they still do - but you could ask you...

The invalid value ought to be in the event that logs the warning. You could also use the Debugger or stage tracing to track it. Set a breakpoint to break on warning.