DSXchange

Double check the location of the file that you have specified in the DSN. Check that you have permission to open the file. Size should not be a problem just to open the file.

For the field named you have specified a data type of Char or VarChar but have not specified a Precision (length). DataStage does not like Char(0) or VarChar(0).

Does it fail for any other stage types? In server jobs DSGetStageInfo() only works for active stages. Try using DSJ.STAGELIST rather than DSJ.FULLSTAGELIST.

Check the third paragraph of my original response.

Add Field Width property to each column.

Data must be partitioned on the comparison field as noted, and must also be sorted on this field so that comparison values are adjacent.

You can use the score to determine whether your ODBC Enterprise stage is operating in sequential mode. As a general rule, though, it will, for a SELECT statement. So does the Oracle Enterprise stage. This error is coming from the ODBC driver (and not from DB2). Contact Data Direct to see if they can...

A File Set is a parallel structure. As well as the control file (name.fs) it has its data stored in files on the "resource disk" directories specified for all the processing nodes that the File Set stage uses. A Sequential File stage gives the ability to work with one or more simple sequential files...

For completeness, 1 indicates a mainframe job.

Not in PX, but you can do it in a job sequence that runs the parallel jobs. You only need to read PARAM_LIST once, and can park the values into user variables if desired.

Read all records as one column (VarChar).
Use Transformer stage to identify record type (even by counting the number of delimiters) and direct rows to the appropriate output, parsing into the correct number of columns using the Field() function.

Unless there's a call available in the ODBC API for creating an MDX file there's no mechanism apparent in DataStage for doing so. Ultimately it appears that you want to effect CREATE INDEX commands from DataStage. Would that be the case? Does dBaseIV support the notion of stored procedures? There is...

You would call CREATE.FILE, CREATE TABLE or mkdbfile through the DSExecute() subroutine.

IPC, Link Partitioner and Link Collector have had some bad press here. If you're worried about that, use a Transformer stage to implement round robin partitioning (Mod(@INROWNUM,3) for 3 outputs). Enable inter process row buffering if you have two active stages, otherwise enable in process row buffe...