DSXchange

And the answer is to create a parallel routine which invokes one of the public domain CRC32 functions already out there.

Dunno. Perhaps look for a terminator character (perhaps ctrl-D) in the actual Oracle log message.

It's total bytes, not total lines, that fills the buffer.

Redirect file unit #2. This has been discussed before, as a Search would have revealed.

Routine names are in VOC, macros and constants are in DSINCLUDE/JOBCONTROL.H - they are not in DSParams - don't worry unduly about them. System variables (and other things) are in DSParams.

Before you look at mechanisms, look at solutions. What do you want to get, if there are multiple plan numbers and/or multiple materials for a given plan number? Multiple rows? Some kind of yes/no answer? Once you have come up with a specification only then is it time to investigate mechanisms.

OK. Yes, there are limits in -logdetail. Source for dsjob can be found in the manuals.

mdbatra wrote:I can't use a Server job & basic transformer as well.

Why not? Everyone else can.

Only unique column names can appear on the output. Change column names on at least one of the inputs. Also (in input link execution order) verify that Before and After are indeed the links you believe them to be.

I doubt that it's easily possible in one job, because the DB2INSTANCE environment variable can only have one value at a time, and can not readily be set at the stage level. Of course, were you to use a Build stage or a Wrapped stage, then you can do whatever you please.

Alas for you John, OLEDB is only for Windows.

Oracle internal format or DataStage internal format? Give us an example (including the original date value).

Use 000 for the quote character on the Format, and use SQuote() function for each field that needs to be quoted. This allows individual fields to be quoted without all string fields to be quoted.

An Oracle vendor at that. This problem has occurred while executing the sqlldr command which, curious as it may seem, is not a part of DataStage. You might include an echo command in the script to discover the command line argument values that it received, and another to reflect the actual sqlldr co...

It's not corrupted. It's just that this particular system variable is not in DSParams file. If you put it into that file (keeping alphabetical order), then all will be well.

When is the interview?