DSXchange

Split file1 using a Copy stage into two streams. The first stream, all rows from file 1, go to output. The second stream is compared with data from file 2 using the stage of your choice (Change Capture? Compare? Lookup?) to determine whether to output the row from file 2. If required, the two stream...

Execute Command activity in job sequence to dir the file and get the size from that, on the basis of which you can decide to execute the job or not.

Clearly, if DataStage processes 0 rows, there's nothing there to count.

There are two, and two only, as at the date of posting.
Version 7.5x2
Version 8.0

Please mark the thread as resolved, and refrain from using RCP in these circumstances.

Do you mean "Do not checkpoint run"?

Of course you have that option. But can you guarantee uniqueness if you're only using part of the primary key? If not, the proposed course of action makes no sense.

Have you checked the DB2 environment variables, such as DB2INSTANCE, to make sure these are correctly set for the user executing the DataStage job? They need to be set in the $DSHOME/dsenv script.

Learn from the experience.

Do the documentation first. Otherwise it will never get done.

Export both jobs and perform a diff on the two export files.

Or wait for version 8.0, which has a comparison tool, fully hyperlinked to the stages, links, etc (or lines of code in the case of routines).

When the uv command is executed, it runs as superuser. It needs to do this to remove old printer shared memory segments if necessary and to raise ulimit (file size only) based on uvconfig setting, before switching identity to run dssh (the DataStage shell). The ULIMIT setting in uvconfig is really a...

Do a lookup using ODBC or UV stage, and you can generate multiple row returns and compare to your heart's content.

That message most usually means that your PATH does not include $APT_ORCHHOME/bin which is where the osh executable is. It may also mean that your APT_CONFIG_FILE environment variable is not set for the process being used to run the QualityStage job. There is no restriction to running a QualityStage...

Check that the C++ compiler is correctly installed and that the environment variables APT_COMPILER, APT_COMPILE_OPTIONS, APT_LINKER and APT_LINKER_OPTIONS are correctly set in your project.

Nulls as keys is not a good idea in ANY database!!!

How did you import the table definitions? Try using the Orchestrate orchdbutil facility.