DSXchange

Just for grins... The Left() adds nothing, the assignment is unneeded and the values are 'backwards' IMHO. I personally would name the stage variable something like svIsEmpty and the expression would automatically evalute to "true" or "false" where true would indicate it is, in f...

You are (IMHO) way better off gathering this information in a separate step rather than plugging up your 'after job' area in every job. Build something that sweeps the information from each job after all jobs have run and which loads that information to a flat file. After it completes, a simple load...

While there may be 'no limit' to the parameter string size, there is definitely one for SQL in the Oracle stage. Check with your official support provider.

I honestly have no idea where that would be documented nowadays. I've leave any answer to people with access to the product and documentation.

Did you look up what a "ORA-01741" means?

You can edit your post and correct that.

Argh... why in the heck was this set up as a poll? Please don't do that as that's not something I can undo.

Not unless you explain what you are doing pre/post sql and post the "following DB2 message".

An 'always on' WISD/RTI/SOA job would do that.

First order of business is to identify it, you can't properly deal with something if you don't know what it is. Check via a hex editor or the UNIX 'od' command or via the appropriate sql command, depending on where this is happening.

It will execute once per node unless you run the stage in Sequential Mode.

Did you check to see if the anti-virus "quarantined" or removed anything it thought was a threat? They've been known to eat things they shouldn't on a DataStage server and are not recommended there... unless you exlcude those directories from it. And the log shouldn't exist "anywhere&...

So, it was working and then stopped? Any idea what changed? And is it literally any job with an Oracle stage or only if that Oracle stage is calling sqlldr?

Also, "(...)" means there is more to the message. Double-click on it and post the full message.

eostic wrote:...years ago people used the Perl Stage, but that no longer exists.....

Sniff... now that I've used. Too bad it be dead.

If your scripting or command line skills leave something to be desired, another option is the Folder stage. It can return filenames based on a wildcard pattern if all you define is a single column in it.