DSXchange

I have a feeling that substring start position is zero-based. Therefore you may need

It's not encrypted, it's compiled code. You don't get the source code, which is IBM's intellectual property. The VLIST command suggested by pandeesh explains what the compiled code is doing. But, if an internal routine can generate a "variable not assigned" error, you should be reporting t...

You're wrong. Surrogate keys are delivered in unique blocks if the block size is set > 1.

The status file you indicate suggests that the blocks are 101-200 and 201-300. One block would be delivered to each node.

Anything generated to stdout is logged and written to the job's file in &PH&. It's simply how the product works.

To avoid, you need to figure out how to prevent the message about OpenSocket() being generated in the first place; find out what error code 39 means and address that issue.

Anything generated to stdout is logged and written to the job's file in &PH&. It's simply how the product works.

To avoid, you need to figure out how to prevent the message about OpenSocket() being generated in the first place; find out what error code 39 means and address that issue.

You didn't say why you needed the information while the job is running. Actually this is easier - the row count on the input link is given by the @INROWNUM system variable, while the row count on the output link is given by the @OUTROWNUM system variable. Note that, if running a parallel job on more...

Use the dsjob command. Restartability will take care of itself.

There should be nothing to prevent you from docking the toolbars.

The Remove statement is perfectly OK. When there are $INCLUDE directives line counts are often slightly out. We need to track down which line contains a variable that is used on the right hand side of an assignment statement and which has not been previously defined. It should be within ten lines of...

The obvious answer is to use the function within a user-defined SELECT statement.

HOW does the StartLoop activity "take the names one by one"? I suspect the logic at that point may be faulty. Also, what is the output of the script, particularly delimiters?

Wrong forum. This forum is for posting suggestions for FAQ topics.

DataStage questions should be posted in the appropriate forum, so that we can gain some insight into which edition you're using and which version and platform.

or if appropriate.

Make sure, when configuring the ODBC DSN, that you include a tight filter - without a filter you will waste time trying to process every "table" on the iSeries (AS/400's new name) machine.

Use a Data Set. The operator is copy (whereas it's export for a File Set), which is bound to be more efficient.

The problem was with Oracle, not with your chosen staging technique,