DSXchange

Simply changing the update action shouldn't cause your reject row to suddenly stop working. I'm not familiar with the DB2 stage, though, so can't say if that's a bug or something else is going on. If that stage has either Transaction Size and/or Array Size options, try setting both to 1 and see if t...

Sorry, don't know the answer - just wanted a better explanation of the problem so those that can help you have more to work with.

Ah... then all is 'Resolved' now, yes?

No. I've contemplated some sort of job to remove everything but the 'most recent' version of everything as my VC Projects are full of crap but never had the time nor intimate knowledge of the APM hashes to do that. I resorted to creating a new Project and migrating things there going forward, forcin...

Not that I'm aware of, but that's more of a DBA question than a DataStage question.

Check the various Output Link Variables available in the expression editor.

How is your 'reject link' configured?

cosec wrote:Also if records are rejected it does not say if n rows were rejected..

That only happens if you have the 'Reject row' option checked in the constraint for that link.

You need to use 'else if' rather than nested ifs directly. And you spell it 'elif'.

DIRECT=FALSE gives you a conventional load, which means normal INSERT statements using a bind array buffer which doesn't disable or rebuild your index. Also note you can only use the PARALLEL option with direct path loads.

If you know for certain the job is not actually running, use the Clear Status File option from the Director to tell DataStage it is no longer running and to enable you to restart the job.

Ok, that makes more sense. You need two if-then-else expressions, not just "two else conditions". Psuedo-code for the TARGETCOL derivation: If ColumnA = 'dsx' Then TARCOL1 Else If IsNull(TARCOL2) Then TARCOL3 Else TARCOL2 You'll need to add link names and make it all PX-like (not sure about ...

Nothing about your requirement is clear or you'd have an answer by now. Let's stay back in your first post.

Let's try again. This makes no sense as you've said it is a source column: "if this column values is also null then populate TARCOL3." Stop saying the same thing over and over and rephrase it so it makes more sense. Which column is 'this column'? All I can gather right now is if ColumnA = 'dsx' then...

I know - I see now you already have a post on this very subject. Starting a second does nothing but cause unnecessart double-work.

Please use your original post to continue this conversation.