DSXchange

Yes, 10 digits max.

Basically, yes. For those combos, the first action is tried and - if it fails - the second action fires.

I just stick with Decimal in DataStage for all my NUMBER fields. Mostly it doesn't matter as they're all treated the same under the covers, guessing it's the 'double' that is causing your problem.

What data type is the target column in the Oracle table? What data type did you use in the job itself?

If you plan on using the routine in a Sequence job via the Routine Activity stage rather than Before or After job - then don't create it as a 'Before/After' routine. That will simplify things and help with your parameter passing confusion. Ray - I just tested your assertion and find that I can, inde...

This is pretty simple in a Server job, is there nothing equivalent on the PX side? You use a 'generic' field name in a database stage and put your parameter name in the Derivation field, allowing the stage to generate the sql. You end up with something like this: SELECT #COLUMN_NAME# FROM TABLE WHER...

What? How do you call it in a Routine Activity stage? I'm flabbergasted by that question - you simply point to the name of the routine using the ellipsis (...) button. That or just drag the routine itself onto the canvas from the repository browser. Just like any other stage. Pass values to it? You...

Help you with what, exactly? This? how will I pass the arguments such as Job Name, Link name, Stage Name in the job. After Job routines take a single argument: InputArg. If you need to pass in multiple values, send them in as a delimited string and parse it apart as one of the first steps in the rou...

... and encountered the following error while compiling: Compiling: Source = 'DSU_BP/DSU.IsValid', Object = 'DSU_BP.O/DSU.IsValid' Compiling what, exactly? From the error message, it seems to be a custom routine but always best to be as explicit as possible. As Arnd notes, posting the routine (wrap...

Welcome! More specifics on the problems you are having dropping and recreating indexes would help - post the actual errors if you can. Does your connection account actually have the grants it would need to do this?

Curious why you would care, as that is perfectly valid XML. What it looks like in notepad should really be a non-issue. However... That is the default behaviour where symbols like that are translated to their 'safe' equivalents in the XML. If you don't want that to happen, change the Data Element on...

Perhaps you should rethink your idea of a generic trigger file. There are various techniques. One it to check the incoming filesize at regular intervals and then process the file once it 'stops growing'. Not ideal, but I've seen it done. Another is to use a utility like fuser which purports to tell ...

That or post the block of code around line 165 for us to see.

I was assuming there is nothing DataStage installed on the remote server where this was being initiated from.

Remote shell. 'rsh' or 'remsh'. Google around or search the forums here, been discussed a number of times.