DSXchange

Create PrevPayrollNbr as an additional column on the stream input, generating its value with stage variables in a Transformer stage. Pass it through the Lookup/Join stage. Downstream of that check for success of lookup (IsNotNull(any_column_from_reference_input) for example) and substitute for payro...

The first piece of advice is that you should choose more meaningful subject lines. The second is not to ask vague questions. The best answer to your question as stated is "appropriate data". Create your own functions that invoke the DataStage functions. For example, to learn about the Convert() func...

Investigate the link variable LASTERR. That is the error text generated by the database server (or by the ODBC driver, perhaps).

What setting do you use for "Automatically handle activities that fail"?

Have you considered including an Exception Handler?

What precisely do you wish to happen if one of the jobs under control aborts? The Exception Handler may need to lead to a Terminator.

Did you even try what I suggested? If so, please post from the first two events in the job log for the current run:
(a) the values supplied to the job parameters from the first log event ("job starting")
(b) the value of the APT_CONFIG_FILE environment variable from the second

You have to supply 100 characters. That is an absolute requirement - you are using a fixed width field that is 100 characters wide. You must provide precisely 100 characters. There is no "lazy way". Please don't confuse bytes and characters. It is not always the case that one byte = one character.

Yes, at a conceptual level. In practice the server job may be able to use host array processing if row buffering is enabled. Parallel jobs will need to buffer the stream input to the Lookup stage (that is, to insert a buffer operator) to manage the difference in flow rates into the Lookup stage. Dum...

Look in the lib directory under PXEngine. You will probably find a couple of orchoracle libraries there, one for 9i and one for 10g. Check that you have permissions on those and on the symbolic links that point to them. -rwxrwxr-x 1 dsadm dsdev 1348828 Mar 22 2005 lib/liborchoracle10gi686.so -rwxrwx...

Why that subject? Why indeed? There may be some clue here or perhaps here

No such configuration parameter of which I'm aware.

Ernie hits 144 posts.

SO useful to have someone with his XML and WISD experience aboard. I've learned lots!

What is the value of APT_STRING_PADCHAR environment variable?

There is very little experience with parameter sets here, since they are new in version 8.0.

Please bounce this back to your support provider - ideally with a reproducible case that they can send to IBM when asked to - and keep us informed about what they say.

Welcome aboard. The message means that not all the inputs to Sequencer_28 fired. That is, one (at least) of them did ("Sequencer_28 entered") and the overall sequence ended because everything finished - however one of the activities upstream of the Sequencer did not trigger the output that leads to ...