DSXchange

You need to use parameter markers in your update DML just like is shown for the insert. The problem is going to be they are positional in ODBC so if you place a single ? there it will substitute the value from the first column from the link. You'll need to rearrange the columns so that the value for...

Not all validators are created equal. We had to do our validation outside of DS using Java to match the level of 'checkness' that our consumer (Google) was expecting.

:!: In that order? If you are going to suggest a stage variable solution that relies on them being in the correct order to function properly, please make sure you post them in the correct order. Three doesn't hurt but you only really need two variables and I would number things differently to make i...

Please be specific as to what your issue is. What exactly does "datastage is not identifying the procedure" mean? Post any errors you are getting.

To restart any aborted restartable sequence from the beginning, you must Reset it first.

Does this happen just for you or for everyone? Is this a new installation where things never quite worked or was it working fine for a time and then suddenly stopped? Details, please. For the former, I would wonder about permissions. For the latter, disk space. Do you know where your projects are ph...

Hmmm... I don't recall ever having to worry about overwrite v. append when outputting to /dev/null, always left it at the default of overwrite I do believe.

You can either send it as a string in that NLS format or a Best Practice is to use a proper TO_DATE() function in your SQL. The stage will generate it for you for a Date or Timestamp field, assuming you will match the format it uses - as you should.

Try adding the quotes to the query itself.

WHERE category = DECODE ('#CATEGORY#', '',category, '#CATEGORY#')

You need to determine exactly what this character is. Get yourself a hex editor (many free ones out there) and use that to find the hex value, then we'll see just how special it really is.

A quick google for that Oracle error will let you know what the issue is as it is well documented out there. Simplest solution would be to run the job on one node only.

(sotto voce) wasn't talking to you

This has been asked and answered a ton here. Do an exact search for "current date" and you'll find several such posts in the results.

What help do you need? You cannot write back to the same file you are reading from, doesn't matter what tool we're talking about. Think about what you are asking it to do when overwriting the target.