DSXchange

Hint: What value does your routine return?

Hint: What value does your routine return?

lib32 does not belong in ORACLE_HOME environment variable; it belongs in LD_LIBRARY_PATH (or SHLIB_PATH or LIBPATH).

Welcome aboard. How is null represented in the file? Have you filled in the Null Field Value or Null Field Length property to indicate to DataStage that this is how null is represented?

Please be more specific about what those changes were and, in particular, which of them wrought the fix!

Try it and let us know. You can not use DSJ.STAGELIST (which is only active stages) but DSJ.STAGELIST2 (passive stages) or DSJ.FULLSTAGELIST (all stages) might include container names.

You simply can not attach a job that is in a "not compiled" state.

Is it just one job? It sounds like this job may have some internal corruption that makes DataStage believe that there is a duplicate stage name or, perhaps, duplicate link name connected to the same stage. Do you happen to have a backup (export) of this job?

You could use an upstream Execute Command activity to read the file, and convert the line terminators in the command output to yield - for example - a comma-separated list that could be used in the StartLoop activity. Now that I have this extra information, I could suggest the alternative of a serve...

Welcome aboard.

If you are only processing one file, processing mode is sequential. If you nominate more than one node in a node map or node pool but only name one file, a warning message will be logged indicating that the stage can not operate in parallel execution mode.

JobName should not be quoted in DSAttachJob - this means that you are trying to attach a job that is actually called "JobName".

Change the data type to VarChar and apply appropriate formatting/trimming to get rid of the leading zeroes and decimal placeholder, or change the data type to Integer.

Welcome aboard. It's all about data types. Aggregator results are always dfloat, whereas Decimal(16,0) specifies no decimal places.

vi may not work so well on a Windows platform!

I believe that "Available memory exceeded." is a very clear message. Think supply and demand.