DSXchange

Thanks!

All things are possible.

And I'm probably the only one that misunderstood. LOL.

Cool, thanks. Trying to find out what "they" are currently using, other than "Business Objects" which is the answer I've gotten so far.

Just wondering as DB2 will be a new source for everyone here and getting software approved is a long and arduous process. So, I know most clients come with their own tools, like sqlplus for Oracle, and Toad probably has a 'for DB2' version but wondering what else might be out there that people have ...

Not sure that reading reference material would be any kind of 'waste of time' especially if you only somewhat understand XML. Sure, you could manually define the metadata / XPath Expressions for the parser but you'd really need to know what you are doing for that to be successful. What both are refe...

nagarjuna wrote:In a parallel job , sequential file automatically rejects . Put a reject link and collect records which are having bad data .

How is that going to help someone with a Server job?

You're using the right stage, just not properly it seems. Be specific - how exactly do you have it setup?

Right, not sure what advice you are looking for here other than either add more space, run fewer jobs at the same time or make them more efficient in their scratch space utilization, if at all possible.

Gack, edit your post and get rid of the blue font, that's unreadable.

Let us know.

Server has several functions that could help with this, check out Num() (etc) or find Ray's free Server version of the PX IsValid() function.

I've given you several ideas so far. Figure out how to do it outside of DataStage - I have no clue what that would actually be, never having heard of "xmla" and really wouldn't consider that a "script" - and then you'll know how DataStage can do it.

You are missing my point, it seems. Yes, DataStage is perfectly capable of executing any O/S command, script or any other beast doesn't matter. After Job ExecSh in the job's Properties.

How would you do it without DataStage? That is the question - and then you basically do that from DataStage.

surajkumar wrote:use sort stage .set sort stage property --cluster key change Colum is true

This would be the full answer.