DSXchange

That basically does seem to be what is going on. There actually seem to be two warnings logged for every error, not three as I originally thought. That "third" one seems to be a "wrapping up here's the warning I'm going to report back" kind of thing so a warning limit of 2 kills ...

Ah... sorry, I thought we might have a parallel solution rather than one that requires a BASIC Transformer to implement. Oh well, no worries.

Having an odd issue I've never seen before and wondering if perhaps anyone else has. Hopefully I can lay this out in such a manner as to make it fairly easy to digest... we shall see. Sorry, but it's going to be kinda long. :wink: At a very high level I'm finding that uncommitted rows can still be c...

Sure, provided you ensure the order / case matches that will work fine for an equality check. That's not the case for other checks, however, unless the fields are in YYYY-MM-DD order.

Could you please post the syntax that ended up working for you? Thanks!

Neither have I.

I've seen that issue in earlier versions as well. 'People' formatting with extra returns and/or blank lines cause issues, removing all that (in essence making the SQL 'one line') made DataStage much more happier.

You might want to check and see if there is a patch available for that.

Couldn't you tell it you have no quotes and then trim only the leading and trailing quotes from the data?

There's always been two sections, the "more" I was asking about was above and beyond that. Perhaps Andy just needs to double-check what he did.

First you need to see what is setup, Oracle-wise, on your DataStage server. Is $ORACLE_HOME defined properly? Is your tnsnames.ora file under $ORACLE_HOME/network/admin or if not, have you defined $TNS_ADMIN to point to it? Most importantly, can you connect to that instance / schema from SQL*Plus on...

Suggest you search the forums for discussions of the DS_AUDIT "table", which is where information of that nature is stored. You won't find the what but will find the who and the when.

Sure, however people just naturally tend to prefer even numbers in my experience.

Was wondering about that, but if one was null neither 'direction' would work.