DSXchange

DataStage routines are written in BASIC. From what I recall, all of the routines that ship with the product include their source code which you can examine as a great learning tool. Can you clarify for us exactly what 'fatal error message' you are after, is it in fact any from the job's log that you...

I for one have no idea but will be following this with bated breath.

Try doing an exact search here for "code 256" and see if any of the previous posts with that error help, if you haven't already.

This last question?

vibwipro wrote:Just wanted to check .. do we need to install some patches on Datastage sever or on Unix box to execute Java Code ??

eostic wrote:No...the Java Stages (Java Transformer, Java Client and Java Integration Stage [9.1 if you want to use the latter]) are built into the tool.

Only? No.

So... what happens when you actually compare them? Actual dates or strings in that format should compare just fine without any kind of secret sauce added.

Suggest you describe your complete transformation requirements in words.

Not sure why you decided to put this at the end of someone else's post, split out to your own.

One typical solution would be to concatenate the 'address' values together via stage variable per group, writing each resulting record out and then using a Remove Duplicates stage to keep only the 'last' duplicate per group.

samopr wrote:I have a developer that is stating that it makes a difference as to how the nodes are placed in the apt file.

What kind of a difference, specifically?

Hence the name.

Awesome... thanks for posting that.

You were advised... poorly.

edward_m wrote:however when i try to use <snip>

What happens?

Perhaps a simple if-then-else?

If num(column) then X else Y

First I'd be curious if you know how to get the XML out of the database? If it's anything like Oracle, you'll need to use specific functions in your SQL - if it's not something you've done before I'd suggest a chat with your DBA. Or see if someone here can drop some knowledge on us.