DSXchange

1. Before-stage trigger. 2. Input link. 3. Stage variables, top down in their grid. 4. For each output link, the constraint expression is evaluated and, if satisfied, the output column derivation expressions are evaluated and the row put onto the output. 5. If there is an otherwise/log output link a...

Please advise what database supports Integer(24) as a data type.
If there is none (as I believe), why do you require it?

The largest integer data type supported by DataStage is BigInt (or int64), the maximum value of which is 9,223,372,036,854,775,807 (only 19 digits, or 20 digits for uint64).

TO_DATE is a purely database function - you can not use that in a WHERE clause in a Filter stage.

Page 29-3 of the Parallel Job Developer's Guide suggests that BETWEEN is supported as an operator in the Filter stage WHERE clause property.

If you search the forum you will probably find techniques for creating/updating "sequence" records in the SDKSequences hashed file.

Another useful diagnostic method has been reported today.

Use the DS_CONNECT command to test connectivity using the DataStage DSN for connection to this database. The DS_CONNECT command must be issued from within an interactive dssh session.

You need two key columns in your metadata. One is mapped to each parameter marker in the WHERE clause. They must (naturally) have different names, but each can have its Derivation as tablename.curr2.

Are you using Internet Explorer with pop-ups blocked? In its infinite wisdom Microsoft has decided that the default behaviour for their browser is to block all active content. You specifically have to enable it.

Is it just one job, or all jobs, for which this occurs?

Can you generate reports from within the Designer GUI?

Is your PWD environment variable set?

The one that you intend to repair, in this case DS_JOBOBJECTS.

Are they really identical, or merely the same size? On a two-node configuration file you would expect there to be two data files for a data set (at least for one over 128KB). On a four-node configuration you would expect there to be four data files for the Data Set, and so on. With a round robin par...

9 is the ASCII (and Unicode) code point for the horizontal tab character. The Char(x) function returns the character whose ASCII code is x. The UniChar(x) function returns the character whose Unicode code is x.

... or use DCount() function, which returns 0 if the string is "".

Yes.

Does not the Search menu option work for you?