DSXchange

It's a cunning plan to force you to buy DB2.


Or it's a bug. Involve your official support provider.

You are totally on the wrong track. By deleting entries in DS_JOBS table you are creating literally zillions of orphan records in other tables (and, indeed, OF other tables). How did you propose to determine your criteria within a script?

Write one file then process it with the UNIX command split -
Search DSXchange or consult your man pages for more information about this command.
Or even use split as a filter command in the Sequential File stage.

Leave the @FM characters - they will be converted to newlines when you write to the text file. Make sure that you specify 000 for delimiter and quote characters in the format and None as the record delimiter style.

It is telling you that it is having a problem creating a named pipe (fifo file) in /projects81/Scratch.

Does this directory exist? Does the user under whose identity DataStage jobs are run have read, write and execute permission to it?

Possibly nothing, possibly correct setup of the Oracle-related environment variables (including command and shared library search lists).

You/they may also need to configure other parts of Oracle client software (within Oracle, not within DataStage) correctly, for example tnsnames.ora file.

Think about what that means.

Disable operator combination to learn which stage (operator) is actually throwing the error.

It is a fool's errand to try to diagnose errors from APT_CombinedOperatorController.

Slowly Changing Dimension stage can do this for you.

WHAT format ?!!! In a job sequence you might use a Nested Condition activity with a Matches operator. #FileName# Matches "4A'.'1A3N'.'3N'.'12N'" If you need to check that the date and time components are also valid date and time, then create a server routine and invoke from a Routine activ...

Use a Merge stage, which consumes each row used from the reference (update) input.

There is one way, and that is to use an ODBC driver for text files.

Just don't expect speed as well as functionality.

One thing I forgot to tell u. Any suggestions would be appreciated. Do you think U would be interested? The second person personal pronoun in English is spelled "you", not "u". U is one of our posters. The word "because" is not spelled "becoz". We strive for ...

Assuming that you are using a Join stage, have you sorted the inputs correctly?

*Topic relocated - Content Editor*