DSXchange

Enter the 19 spaces then select them. Press Ctrl-C. Then, for all the others, press Ctrl-V. It's a technique called copy-and-paste.

${DSHOME}/.odbc.ini

A poll is a waste of time unless it's going to be used for some sensible purpose. It's probably worth asking how to get DSXchange to break even; right now premium memberships don't even cover the bandwidth costs - we exist through Dennis's financial generosity, and I think it's unreasonable to expec...

You CANNOT change them in Lookup stage. Lookup stage does lookups.

You must change upstream of Lookup stage, probably using Modify stage or Copy stage.

Precision of thought, execution and language are vital in this game.

Routine I could have accepted. Routine can be transform function or before/after subroutine.

The only subroutine is before/after, and it's written in DataStage BASIC.

Lookup stage only performs exact matches. You need to effect appropriate transformations upstream or downstream of the Lookup stage.

Post the ten rows of keys. Also post the partitioning you are using.

Right now the answer to your question is a definite "maybe".

The Orchestrate Framework does allow for unbounded strings. This is reasonable for VarChar; I am surprised to learn it accepts it for Char.

Nearly everything is in the RT_SCnnn subdirectory in the project, where nnn is the job number.

Dump and read the score to see what's really to be executed - it may be materially different from your job design.

... except that DataStage will insert tsort operators unless you explicitly specify no sorting in a Sort stage or use the environment variable that instructs DataStage only to check that the data are sorted.

You can find out from DSGetJobInfo() whether a job is multi-instance or not.

Less than 30 cents per day, and you want a reduction?!!

It's worth way more than that to a DataStage developer.

Your support provider can provide the patch. There is no charge.

Please mark the thread as Resolved

Subroutines are EXACTLY THE SAME and are written in DataStage BASIC whether for parallel or server jobs.

Are you asking about functions?