DSXchange

How about the server IsValid() function?

Had you downloaded my date routines you might have saved yourself some design effort.

Reuse, recycle.

In short, you're wrong. UniVerse and DataStage ARE SQL-compliant, but aren't ruled by that. There is nothing whatsoever in the SQL standards (either SQL CAE Access Group standards or ODBC standards) that requires that a key have an index. A primary key requires only a UNIQUE property. If there is a ...

Modulus should be a direct outcome of your choice of separation (and the volume of data to be stored). You already have the formula.

The information that IBM released "some time back" was for version 7.0 and earlier and has been overtaken by events. Now they're advising (in their training classes) that Transformer should be perferred to Filter, on the grounds that it's compiled and Filter is "interpreted". I believe the justifica...

Reset the job in Director. Post whatever is in the "from previous run..." log event.

Poll Hereford ?

There is a downloadable DSX file here

In parallel jobs you need to partition on that column for the results to be accurate.

Define "performance" in an ETL context.

Rows/sec is, as I have frequently asseverated, meaningless.

You must allow two extra character positions (string[max=40]), one for the sign and one for the decimal place designator.

FIFO (first-in, first-out) is another way of referring to a pipe. So either the FTP stage's operator failed to read data from a pipe, or there is something wrong with one of the commands in your FTP stage. The error message yields no more information than this. Your FTP server log may contain more h...

Try experimenting with Length and Scale. Try extracting the timestamp from the Data Set, and loading into Teradata, with no Precision or Scale. Try using a test table with Timestamp(19).

Try putting 19 "*" characters in as the Null Field Value property.

Then the Help is wrong.

DataStage Designer Help wrote:DSJ.JOBCONTROLLER String - name of the job controlling the job referenced by the job handle. Note that this may be several job names separated by periods if the job is controlled by a job which is itself controlled, etc.