DSXchange

Did you define the key values used in the WHERE clause on the reference stage?

You mean like a filename or a query value? Instead, use job control to feed the parameter.

It's the internal program that creates hashed files, similar to mkdbfile, which the CREATE.FILE command uses. Any chance the physical filename is locked? Have to tried using some junk filename and does it work?

Go to your Start button, Ascential, Online Documentation, and open the BASIC manual. Go to the functions section, everything is alphabetically listed. If you look at the two functions I listed, you'll find them in the documentation in detail. This is your API documentation. I suggest you use this in...

That would be because it doesn't exist. DSGetStageInfo and DSGetLinkInfo exist though.

From a before-job routine? Can't set a jobs parameter values from its before-job routine. Consider using a staging variable in your transformer, and for the initialization of the value do the ExecSH call to your script to get the startup value.

You specify the format for input conversion and also output conversion.

When a DS job runs the CWD is the project, go see if your files are appearing in the project directory. I think you need to qualify the output directory for the tar files.

Search the forum for ICONV and OCONV.

Before/after job/stage routines put messages into the job log when they are called. Look about 3 or four lines down from the first message in the job log from when you last ran the job. You'll see some Event message with (ExecSH) at the beginning. Look at that message to see what the tar command is ...

Because it's not used on Windoze.

You could use a Sequencer job with a Wait For File Activity stage watching for your file and then run the appropriate job. Write a Sequencer per file to run the appropriate jobs therein, then put all the Sequencers in the scheduler.

You need to go to the ODBC icon in Control Panel-->Administration on the Server and configure ODBC there.

What is the log message from the ExecSH command?

prstat (Solaris 2.8+), iostat, vmstat, netstat are commonly used tools for performance monitoring. Consider downloading top (prstat is a version of it) or glance from HP.