DSXchange

Had an interesting issue this morning and looking for some advice. Client supplied flat file has quote-unquote "junk" in several fields that really should be empty. And since they're not empty, they pass the "null or empty" sniff test that would normally get them excluded from th...

Not to beat this to death, but that's not exactly damning evidence. There's no resolution to that post and everything in it points to improper usage of the function. [shrug] Not saying that wasn't your issue, just that there is no smoking gun here and I've never seen any such misbehaviour using it f...

Your post is for a Status Report issue, not something specific to the DSGetLinkInfo function from what I can see.

Parallel execution in Sequence jobs is... problematical. This discussion might help shed some light on the issue for you.

Short answer is 'no', there's no support for 'encrypted data transmission' of the type you seek.

Somebody lied to you.

As long as it is called correctly, of course. Full error management should include a check for negative return codes which indicate errors - invalid job name, stage name, link name, etc etc.

And there are many, I'm just not one. Be patient, they will show up. Eventually.

Answered here: viewtopic.php?p=347035

No, I'm not confused. This is the exact same issue - a routine that does not return a zero has been considered to have failed when you enable the "Automatically handle" compiler option. Doesn't matter if it returns a "1" like in the first example or "200911121250" as in...

Not sure how you could find 'less than definitive' answers when the answer is a resounding heck no.

You need to compare the looked up values to the incoming values and only pass along a 'change' record when something has actually changed. Don't really see how this will be any more performant than the CDC stage, however.

Yes, post the requested lines.

That could very well be. Perhaps, like Oracle, you need a DB2 'client' installed on the DataStage server? No clue, personally, as I've never DB2'd but that would be my guess.