DSXchange

If the date column in the Sybase table is indexed, lookup performance might not be as bad as you think.

Welcome aboard.

The short answer (which a Search would have revealed) is that there is no legal way to change the value of a job parameter once that job is running.

The usual "solution" is to carry dummy columns containing the information; this approach is essentially cost-free.

Are you using DB2 for your common metadata repository for Information Server? If so, this uses DB2 version 9 (you don't get a choice). What it may also mean is that environment variables such as DB2INSTANCE may be set for that database, and would need to be overridden in a job. Further, version 9 cl...

The technique you need is a variation on one that is called "vertical pivot". Search the forums for techniques. In parallel jobs the most usual technique is to assemble each unique key's record in stage variables in a Transformer stage. Presumably your non-key repeated data will all be in ...

There is a checksum() function available in version 8.1.

Please advise what the workaround is. I assume it's not as simplistic as forcing you to use an English operating system.

However, the job type and forum are "parallel". Would you (sagar) care to re-phrase your question?

Allow a reject link to capture the headers.

Is it possible for you to post lines 1, 2 and 3 from this file?

Look in the DataStage BASIC manual. DataStage BASIC can treat a directory as if it were a "table", with the file names in the directory being the "record keys" and the actual files being the "records". In this sense, after you use OPEN or OPENPATH to open the parent dir...

There is only ever one conductor node. Assuming that APT_CONDUCTOR_NODE environment variable is not set, then the conductor node is the first-named node that is in the default node pool - in this particular case "n1". There will be one section leader process on each of the nodes mentioned ...

Oracle bulk load stage is for server jobs, and creates data and control files for sqlldr. What do you mean by "ordinary"?

This is called a "blocking operation". It is entirely forbidden in parallel jobs, as it disrupts pipeline parallelism.

Read the error message again, carefully.

Which pathname is mentioned?

No. That's why the column in DS_AUDIT is called "last deleted date".