DSXchange

The orchadmin command is in $APT_ORCHHOME/bin - I'm prepared to bet this is not in your PATH.

To use orchadmin you need APT_CONFIG_FILE set also. This is usually not set in the dsenv script.

There's a lot to do in there. Why are you converting "5,439-cc" to "5438 cc"?

As noted elsewhere, the BASIC function MatchField() is ideal for this kind of task.

Not really. There is a class that the vendor used to offer, called Programming with DataStage BASIC, and one with a similar title that I offer (see website), but not much in the way of documentation per se.

You *should* be able to use the standard hostname:nnnn style for specigfying a non-default port number.

There used to be an entirely scripted product called Orchestrate, from Torrent Systems. Ascential Software (vendor of DataStage at the time) acquired Torrent Systems and created a DataStage GUI that write osh scripts to invoke various of the Orchestrate operators. Yes, it is possible to create osh s...

Remove Duplicates stage upstream. Or a sort (Sort stage or input link sort) with the "unique" option selected.

What is the WHERE clause? Can you execute the query with a WHERE clause successfully in another client, such as sqlplus or TOAD?

Set APT_STRING_PADCHAR to space (\x20) rather than to NUL (\x00).

This could be that the indexing on DS_ROUTINES table in the repository is invalid or out of date. Try reindexing (which rebuilds the indexes).

You may need to pre-sort the rows, and to use a Copy stage to re-order the columns.

Because the question was how to eliminate warning from job log, and I treated it literally.

rsh UNIXhostname options -l remoteusername command

Options include
-D enable socket debugging
-N send all output to stdout, nothing to stderr
-n redirect stdin from /dev/null (.\NUL)

Examples
rsh username@hostname -DNn command
rsh -DNn -l username hostname command

Did you recompile the job after changing the user-defined SQL?

If there's a small number of counter items in the loop, you could decode them in the expression that is used to set the parameter value. Otherwise you could pass the counter value to a routine which decodes and returns the relevant password_exp value, using the routine's return value to populate the...

... or, if you have one output defined in the Transformer stage, simply drag the columns from there to the other output within the Transformer stage editor.