DSXchange

No. Once you've committed, you've committed. Your data will need to carry some kind of run identification that you can use in "cleanup" jobs to delete those rows. Life gets trickier if you have updates, but you have not mentioned those.

The default partitioning of a reference input is Entire (so that you never need to worry about missing a lookup because of partitioning). In an SMP environment this is managed by creating one reference data set in shared memory and is fairly cheap to do. But in a multi-machine environment you wear t...

Range lookups compile as transform operators. Therefore you really are looking at a "Transformer" stage. Now see if you can figure out the "field not found".

That's the first time you've mentioned that 01841 is an Oracle error code. What does the oerr command tell you about this code?

You didn't miss much. I've cleared the premium block.

The problem is in your routine rtErrorHandling and its interaction with the job sequence that invoked it, presumably through a Routine activity. With no knowledge of what this routine does it is almost impossible to assist. I suspect, however, that it has returned a non-zero result that has not been...

1. Is the same macro defined in both your header files? If so you'll need to figure out a way around that. 2. Set PWD to a single dot (current working directory). 3. The "number of datasets" error is sometimes spuriously thrown when the compiler license has expired. This is something else ...

Use the interactive Debugger (in the Designer client) to see what is happening with the data on each link.

What's the default Oracle date picture? Could bad data actually have been stored in the table by any means?

Have you tried using an NLS map that handles Chinese characters (one of the GB2312 maps or BIG5 as appropriate)?

What happens if lookup succeeds in two or more lookups?

Just implement the appropriate logic in the Transformer stage downstream of the lookups.

What happens if lookup succeeds in two or more lookups?

Just implement the appropriate logic in the Transformer stage downstream of the lookups.

You might like to adapt the following example. SUBROUTINE ArchiveJobLog(InputValue, ErrorCode) $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF $INCLUDE UNIVERSE.INCLUDE FILEINFO.H DEFFUN OpenSequentialFile(FilePath,OpenMode,WriteMode,LogMode) CALLING "DSU.OpenSequentialFile" Er...

Do you have C++ compiler correctly installed? Can you compile parallel jobs?

What version is your WebSphere Application Server. If it's 6.0.2.27 you're running 64-bit. If it's a lower version you're running 32-bit.