DSXchange

The ? is used to indicate a character that can not be successfully mapped using the current map (= code page) setting. In theory MetaStage is automatically NLS-enabled if your client computer's default character set is multi-byte. However, ISO 8859-1 is not a multi-byte character set. This might exp...

If what you say is true, and I'm not doubting you, then you may have uncovered a bug? What are the data type declarations in the generated C++ code?

I think your next step must be to report this suspected bug through your support provider. They will need a clearly documented reproducible case.

DataStage Version Control does keep track of different versions of jobs. It can auto-increment version numbers when jobs are promoted from development to test, for example. However, it does not have check-out, check-in capability. That is, it is version control, not source code control.

Yes. Do you want to use different configuration files also? Just make $APT_CONFIG_FILE a job parameter for the multi-instance parallel job.

All columns must exist in one or the other (or both). If runtime column propagation is disabled, all columns must exist in the link properties irrespective of what is in the schema file.

I doubt very much that it gives "xxx" as the fractional digits. Please advise one or two specific cases of incorrect subtraction, and whether it's all subtractions that give a wrong result, or only the occasional one. I presume you are using a parallel Transformer stage here? Have you inspected the ...

I propose to continue "answering" with "etiquette notes" in dark red. No useful answers until the post appears in the correct forum.

It might be courteous to check with the current owner first. Otherwise the risk is that that user will simply change it back again!

In server jobs you can perform the join in the database wherever possible. If they are disparate databases, perform the join (lookup) using a Transformer stage. This returns null in all columns if the lookup does not succeed, effectively a left outer join. To get an inner join, constrain the output ...

Import is different depending on whether the source file is delimited or fixed width. If it is delimited, then you CAN have "" as the representation of null.

You also require the QualityStage runtime manager (qsrtmngr), which must be started (startup script?) and, possibly, have its port number (configurable) opened in any firewall software.

Or a BuildOp (one kind of custom stage).

Or just rely on the fact that C strings are null-terminated; that is, Char(0) is already "".

The major downside is that you lose all the control information, such as auto-purge settings and "last started event number" history. You can invoke CLEAR.FILE through DSExecute, or there is a ClearFile statement in DataStage BASIC (you need to have opened the hashed file). From a BAT file the synta...

Where are you deriving the microseconds. DataStage's Time() function only delivers milliseconds - you need the System() function to deliver microseconds (and, even then, the operating system must support microseconds, and you may need a routine so that you can set $OPTIONS appropriately).

DataStage is a 32-bit application (Oracle client) on most platforms. Therefore, for DataStage processes, lib32 must precede lib in the shared library search path.