DSXchange

Adding them as Project level variables does not get them in dsenv. You would have to do that manually if you wanted the changes made across all projects, then bounce DataStage.

How exactly did you use it? That is what you want after all, the absolute value.

I'm sorry but how many times are you going to post this?

Go back and continue the conversation in your most recent version of the issue: viewtopic.php?p=364022

No, it seems they want all entries from a single job's log, whatever is available. This rather than just constrain it to "the most recent run". I'm not anywhere I could check this, just wanted to make the clarification.

Add a second link from the Transformer to a flat file and either mark it as a Reject Link or use the constraint there that you posted. ... i am using SERVER job. I think the above said will work only for parallel job. Correct me if i am wrong. Well, OK... you're wrong. Oddly enough, I generally ten...

ps. For now I've removed the PC marking for my post that seemed to piss you off so much.

Don't know about anyone else but still wanting to see the actual score from the job run. Also, has your two node file been blessed by the 'Configuration File Validation' utility or whatever the heck it is called?

Add a second link from the Transformer to a flat file and either mark it as a Reject Link or use the constraint there that you posted.

Yes - the dsjob command. And it is well documented in a chapter that details the Command Line Interface, oddly enough.

You're getting those errors when your fake update sql fires on the duplicate attempts. How exactly do you have the Surrogate stage setup? Does this happen if you run on a single node?

So, more than just "a simple job just an oci stage", eh? Sorry, but I have no idea what you mean by "On the ref DB i have query from DB in which from the where clause i use the runtime argument from the source which will be to_char(:1,'MMDDYY')". :? If it means you are using that...

Hmmm... ok. Of all the link variables available, different databases populate different combinations, however no clue which ones Sybase will. In your shoes I'd build a small test job and include them all, then force certain errors to occur. Include all of them on the reject link and see what does (o...

Can you post your complete error message(s)? "No data found" <> "duplicate key". It would also help to detail your job design, # nodes, etc etc.

Need to query it and load it to DW table.. To make the situation simple and understandable , i didnot metion it!! :roll: Roll your eyes all you want but you are doing yourself a disservice making your situation "simpler" by leaving out critical bits of information needed to supply a prope...

Do you work with someone who can help you with the XML specific bits? What have you been given that defines what the output XML needs to look like? Anything? :? ps. The transformer wasn't meant to fix anything, it is just a Best Practice to use an active stage between two passive ones, not to mentio...