DSXchange

Does your datastage job read or write any dataset? If yes, delete those datasets manually before running the datastage job. How do you come to that conclusion? There's no mention of data sets in the error message. There is, however, a mention of pxbridge.C, which suggests that there may be a proble...

Not CAST. CAST changes data type. Use one of the functions that convert NULL to a non-null value.

Thanks for your reply. But I have to write the original osh scripts in our develop environment. Resist stupid requirements. This task is far more easily done without osh. After all, it's not really a parallel operation. What you're really seeking to determine are link row counts. There are calls wi...

Probably partitioning. Try running the Transformer stage in sequential mode, so that no partitioning is required.

And please confirm that svGroupNum is an int of some kind and was initialized to 0.

Tell us a bit more about the Sequential File stage - in particular whether you have NLS enabled and, if so, which character map is being specified. The "?"character typically indicates a character that cannot be mapped using the currently selected character map. The solution would be to ch...

Actually you would use an Execute Command activity to read the file, and a User Variables activity to tidy it up (remove an empty final line, convert the line terminators to a delimiter character such as comma or tab for the StartLoop activity to use).

Contemplate using a Column Export stage to construct the "all columns" field.

Enabling dsdlockd should have been the first suggestion you had from support. This is a process that automatically cleans up locks held by defunct processes (among other things).

You've pretty much described the steps you need. One job activity to retrieve the email ID from Netezza (not from New Zealand!) and park it somewhere from which the sequence can retrieve it. If you use a server job you can park it in the user status area of the job; otherwise use a temporary text fi...

You should not be using these expressions in the Condition for a lookup; they do not generate a true/false value. Instead, generate the value in an upstream Transformer stage, and use the transformed value as your lookup key.

Indeed, I would probably initialize vReference to 0 and not give it a derivation at all. This would give me a tiny performance gain.

This is exactly the same question (apart from names) as this one that you asked recently and which has been answered.

Yes? Use the value of the svProject stage variable, which contains the project from the most recently-encountered Type 1 record.

It's doing exactly what you've programmed it to do. The output of the Sequencer cannot fire until it receives a signal from the upstream links. Your controlling sequence appear to be set to not pass a signal if SQ2 aborts. What is the nature of the trigger from SQ2?