DSXchange

Are the parameters set via the Designer run identical to those passed via the dsjob command line run?

Sounds like overkill. If this is a Server job using a sequential stage, check the Stage uses Filter Command and add this filter
grep -v TRA

Provided the string TRA only shows up in the trailer record, the grep will return everything not a trailer.

What's the name of the Environmental variable/parameter? Could it be
$DSCAPIOP__DB2_DBNAME? If so, perhaps it's a typo. Where's the "$". For example;
#DSCAPIOP__DB2_DBNAME# might need to be #$DSCAPIOP__DB2_DBNAME#.

The problem with manually copy and pasting is maintenance when a new field is added. It is MUCH easier to generate the schema file once and maintain that for all 19. I'll assume Ascential's intent was to use table definitions to generate schema files. It can be done this way but the generated schema...

Yes. MQ MUST be on the same machine that is running DSEngine.

1. I'm pretty sure you can turn off the routine check in 5.2+. From Manager => Options => Usage Analysis => General => Uncheck Warn if compiling Referenced Routine will speed up the compile considerably. 2. I am also pretty sure that routines imported into a project MUST be compiled for the changes ...

It is not protected.

No one can access jobs in a single project from among many.
DS.TOOLS options hang when selected as does Clean-up Resources from Director.

What diagnostic tools are available to dsadm that would allow us to troubleshoot this problem?

You cannot pass a value to a stored procedure AND get a value back (output parm) at the same time. DataStage doesn't work that way. I've never done it but you could have a stored procedure that takes no input and simply returns a stream of data to your job. It would be the driving input stream to th...

We use it as a "do something" OCI stage on an output link. The next link constraint interrogates the OCISPlink.REJECTEDCODE to see if the stored procedure did the "do something" without an error. If not, follow the error link. We encapsulate units of database work in this way tha...

I don't really understand what you are asking. If you are asking if you can browse a message queue for messages, process all or part of the messages or a part of a message and then decide to delete the message then yes this can be done. Simply uncheck the destructive read checkbox and the message wi...

Good point. Also it appears you want transaction control at the job level not the row level. You'll have to set the commit rows value to 0. You'll need the REJECTEDCODE constraint for all links to the database. If any of these constraints evaluates to true you'll have to abort the the job. This will...

I hear that. One must triple check everything when replying to a reply from the Big Ray-huna.

I'm sure I am misunderstanding but I'm curious, having never worked with AS400, as to why you even need the column derivations. If the file layouts are identical for ALL files, then it would seem to me all you need is a way to point to the correct library as you have already done. The derivations in...

Guessing, I would say your routine contains a processing path that leads to a variable that is undefined when the input is NULL. If you initialize ALL your variables or ensure that all variables have a value in the routine this problem will go away. I use commonly accepted programming practices and ...