DSXchange

Hi yourself.

Add an extra column to the output link of the Transformer stage. The derivation for this column is the value of the stage variable. This remains available in downstream stages as far as you want to propagate it.

You've misread the error message. It's complaining about the eighteenth column, not about an eighteen character limit. The message is actually telling you that the data (not the column name) was truncated. That is, your metadata specifies a maximum length of N, but a value was found in the data that...

Because you have not specified null handling.

DSLogInfo, DSLogWarn, DSLogFatal and DSLogEntry all exist in the C language API for DataStage.

NLS stands for National Language Support. It does two things. It maps characters from whatever representation they are in in external stores into and out of the DataStage internal represntation of Unicode. It manages locales (local representation) of times and dates, numeric, currency and character ...

Is the QualityStage run time manager (qsrtmngr) process running? This is the mechanism through which DataStage communicates with QualityStage.

OK, you can compress everything into one job, making use of the fact that a passive stage can not open its outputs until all its inputs are closed. For example: Part1 ----> SeqFile ----> Part2 ----> SeqFile ----> Part3 But I'd still advocate separate componentry (if pieces are identical put them in ...

One big difference is that the Oracle bulk loader does not do updates. Only inserts.

Essentially the answer is NO. NULL is a meaningless concept in a text file. If you want the internal database representation of null, you will find that this varies between databases, and would mean that your text file is probably a binary file (there's no guarantee that the internal representation ...

Yes, you can. There is a command line interface to QualityStage. Read about the scripting language in the QualityStage manuals. It's not as straightforward as other tools, but it's definitely possible. In its earlier incarnation (INTEGRITY from Vality) this was a stand-alone tool.

Have you investigated job sequences?

That would give you your "way to control the execution order on a Server job and/or insert wait conditions" with the greatest of ease. It could be as simple as three dependent Job Activities.

For both the delimiter character and quote character you can enter a three digit decimal number being the ASCII code of the character desired (for example 009 for Tab). If NLS is enabled you can also enter a four digit hexadecimal number being the Unicode code point of the character desired (for exa...

Can you post those parts of dsenv in which the environment variables are set?

Can you also post the result of the command echo $PATH so we can see what's different?

Search the forum for how to use stage variables to remember values from the previous row. Once you can do this (which is very easy), the rest should follow.