DSXchange

dsjob is a sample program to show how the DataStage API is used.

If you don't like it, you can write your own.

Source code is supplied in the manuals.

DataStage on Windows actually runs on MKS Toolkit, a UNIX emulator, so it can cope with UNIX pathnames provided that the corresponding Windows folders exist. For example, if your DataStage job refers to /tmp and your logged drive (where DataStage is installed) is D:, then /tmp will automatically ref...

The internal representation of null in DataStage is Char(80) by default and this is the value assigned to the @NULL system variable. However, Char(80) has other uses (primarily the Euro character) so the internal representation can be remapped to a different character (such as Char(164)) under certa...

If the product was installed without NLS there will be no NLS entries in uvconfig at all. This is a definite giveaway!

Even so, the answer is no in a Join stage. In a Lookup stage you have the possibility of a range lookup but that's a highly specific case of "OR". As noted, please be more specific.

Is the Standardization stage still using USADDR/USAREA rule set but trying to apply to Mexican data?

Are the Mexican rule sets properly provisioned?

What, precisely, do you mean by "not working"?

Search (here, Google, wherever) for "connection refused" and its likely causes. Look at any other warnings that may have been logged with this one.

And what are your DataStage NLS settings?

dfloat is potentially bigger than 15 digits so DataStage alerts you to the fact that the implicit conversion to sfloat may result in limitation of the range of representable values. You need to know this.

SecondsSinceMidnight() [ which may not be the correct name ]

If you apply this function to both times you can subtract to get the interval.

Import via ODBC table defnition. Make sure that you require system tables to be included, because the ODBC driver for Excel reports worksheets as system tables.

There is a fixed-width option on the Format tab. Once this is selected you must provide a space- or comma-delimited list of field widths in the field provided for that purpose. Subsequently you can adjust the field widths if necessary, using the Display Width property in the table or column definiti...

Rows/sec are misleading you entirely here. 13000 is the rate at which the virtual data set is loaded. Once that completes an in-memory hash table index has to be built. During all of this time the clock is running on the stream input but no rows are processed.

There may be an "end of data" token available in a future release (8.5?).

Don't know. Haven't needed to try it. Have YOU tried it?