DSXchange

That's right. Jobs and job activities work differently. A job can pick up any value, including an empty value, from the job parameters grid directly. A job activity in a job sequence, however, expects to find an expression (rather than a value) there. Ultimately it becomes an rvalue in an assignemen...

That post sums it up fairly well - create the code in a separate subdirectory in the project which you can protect with O/S permissions.

Surely the TECHNIQUE doesn't violate any security?!! The sqlldr program is invoked with various command line options, but can prompt for user id and password if required. In that case a "here script" can be used to supply responses to the prompts, and environment variables can be used to supply the ...

You do not mention whether the column is Char(4) or VarChar(4) in the DB2 table.

It is correct (as documented) behaviour. The External Source program is invoked once, and generates as many lines as it will onto stdout. These are delivered into the job design via the output link from the External Source stage. In your shell script $1 can only ever mean the first token from the sc...

Write it yourself in C or shell script. It can't be done with DataStage.

Delete the code after compiling. Use a white font! What is it you want to achieve? Does "anybody" include yourself?!! If it's a money issue, adding a copyright notice should suffice, or making it read-only. You can create routines as external UniVerse routines, globally catalog them and create inter...

Does your "solution" involve the -s switch? Please let future searchers know how you solved it.

Excellent! Thank you. :D

Does the production system have a system or file DSN that points to the correct SQL Server instance?

DataStage can not find (or can not read) a uvodbc.config file in your project directory or in the DataStage Engine directory. Or you have not configured any data sources in the .odbc.ini file in the DataStage Engine directory.

You need to create an extra output column for the sum. You can then associate the sum rows property with this output column.

That doesn't show locks held by defunct processes. You need to get to the Administrator client window or to the server and issue a LIST.READU command. If you can get to a UNIX prompt, even better is to issue the command from UNIX, so that you can pipe the output through grep and just search for that...

The far right columns are sometimes incomplete and there are no trailing spaces. This would be fine if the final column was ragged right, but the record may end a few columns previously. Hence, my import to SQL Server "wraps" the records and misaligns them. Pre-process with DataStage to true fixed ...

You can't take a vacation in this line of work; your skills would become out of date.