DSXchange

Is it legal to have a passive stage (including a Data Set stage) with an input and an output link? Try splitting your job into two jobs - one to write the Data Set, the other to read from it.

These are not junk. The rules of DataStage specify that a five or seven digit number will be interpreted as a two- or four-digit year followed by a three-digit ordinal number of the day in the year. Therefore, 00222 is the 222nd day of the year 00 which, if your CENTURYPIVOT configuration parameter ...

Arnd's point was that the export command should be followed only by the environment variable name.

Completely build LIBPATH before exporting LIBPATH. Only LIBPATH.

Please give more details. What are the patches, with what eCase number(s) is each associated and, most importantly, did they fix the problem?

Find who's doing it and force them to agree to a design freeze.

Get your other problem ("can not connect to Oracle - can not load ora... module") fixed first. Then this one might go away.

Any time you see "unable to load" anything, suspect your shared library search list (an environment variable called LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH, depending on which operating system you're using). You may also need to check your command search list (the PATH environment variable), since th...

That's not quite correct. It is operators (stages) that can be restricted to run in pools, not jobs. Pools are more useful in an MPP environment, where - for example - database client or other software might not be installed on all nodes. You can - in this example - create a pool containing only tho...

You will still get the text, but it should now have a green icon when you run the job. Also in the log will be two more entries, one (near the beginning of the job run) showing that message handlers have been attached to the job, the other (near the end) showing that message handlers were used.

It's not a file, it's the Filter command.

When and why did the job abort?

Without knowing that there's no way a cogent answer to your question can be provided.

Please post all relevant error and warning messages.

That's another way of writing the Field() function mentioned in my reply to your other post. ONE of your other posts.

Yes and it's exactly the same function as in your other post.

You may or may not require a surrogate key. A Type 4 SCD, for example, maintains a separate history table, and that can be keyed by the business key and an expiry date. As a general rule, where there's a need to preserve history a surrogate key approach is to be preferred, because it is comparativel...

Why did you not mention that fact in your original specification?!!

Would it have been so hard for you to try it, rather than ask?

In this case you are lucky, the function will return the entire input string if it contains no delimiter character.