DSXchange

From the operating system issue the command $DSHOME/bin/list_readu and pipe the result through grep filtering for the project name. Every connected client takes a shared lock project&!DS.ADMIN!& so that the Administrator client (or you) can rapidly determine whether there are any clients con...

Welcome aboard.

Do you mean something like "treat warnings as fatal"?

I don't think this exists in the DB2 API stage. Is there some reason you're not using the DB2 Enterprise stage?

Can you post one of your expressions?

Please also verify that the default value for the job parameter (in the job properties) is $PROJDEF, not PROJDEF.

Does this occur if the default value is something else?

And, while you're testing, can you also try the default value $ENV ?

Without even opening the stage, right click and choose Propagate. Within the Transformer stage you can multi-select the input columns (click on the first, shift-click on the last) and do a single drag-and-drop. The column definitions from the spreadsheet you have, of course, previously imported into...

Why not just use the parameter value as the invocation ID? Otherwise, call KeyMgtGetNextValue() to establish a sequence of unique invocation IDs.

The code looks OK, albeit rather inefficient. For example, why not write a line at a time to the output file within the loop? You don't need to "clear" the output file - WriteSEQ is a destructive overwrite. If you want to be certain, use WeofSEQ immediately after opening. The line terminators are ap...

affect

Are the link to the sequencer from the 10 jobs being triggered on failure condition. i.e constraint as finished trigger next job and otherwise for sequencer. If so you can change the conditions to trigger sequencer if job aborts and trigger next job in all other conditions. This is a less satisfact...

TRACE
TRACE ON
TRACE OFF
TRACE CLEAR
TRACE CLEAR Type1FileName

You should be passing just a value, not an assignment statement. Get rid of the "PN = ".

Wore out two copies of the vinyl LP, I think the CD is wearing out too!

They should be co-resident with all the other rules in your Rules folder. Each rule set comprises a number of files. Each has the rule set name as (part of) its base name, and there are suffixes including ".CLS", ".DIC", ".TBL" and so on. Full details are in the User Guide. They should not have been...

Do all nodes have the same fastname?

If not, you need to set up your shared libary search path for DataStage processes on each machine mentioned in the (fastnames in the) configuration file so that all needed libraries are accessible.

Are you using the expression editor to build the expression in the Transformer stage? Environment variable job parameters should (do) work perfectly well in parallel Transformer stages. Can you post one of your expressions? If you're not using the expression editor, can you please do so and note whe...