DSXchange

Why do you say you need to convert them to "decimal and ascii" and state that would mean "three fields" if you did it at the source? What would be in this "ascii" field?

No, all you are doing is concatenating the control files together which gets you nothing usable. As noted, you'll need to read all four and write them to a new dataset that contains all of their contents. Unless there is an option in the admin GUI to do this? Don't recall one.

Don't recall what all is output but there is a "dsjob -stageinfo" option from what I recall. Perhaps that will help.

From the command line, you need to continue to do what you are doing - a conditional check. From 'inside' DataStage you can use DSPrepareJob() to do the 'Reset if required' step, the run part is always a separate step.

I had a doubt because version 7.5 had the limitation of 20 stage variables. Never, ever heard such a thing and stage variables came into the product well before 7.5. And sorry, can't really help with the "circular strain" question as I have no idea what that means. Never mind the fact tha...

There have been times when I've built a reference lookup without keys, but it is rare and it can't be done against a hashed file. And it only really makes sense when you either need to return a static value (and then you'd be way better off pulling that into a hashed file with a hard-coded key) or f...

Sorry, but you've posted this in the wrong forum, this one is for discussing subjects that may become a FAQ. Please repost your question in the appropriate forum, there's one for Server job questions and another specifically for PX jobs. And there you'll be able to specify what operating system your...

That would be the ODBC stage but it's not going to help with the desire to use it in a 'transformer' fashion. Source or target, sure but not to process record data through the sproc.

Yes, Return Value is for "success or failure". And like you, the OP had their's work fine as well when they switched to using Command Output, which is basically whatever the command echos to "the screen".

Bascially, it does refer to the Server engine and that means the DSEngine directory. It would need to be installed on every physical server you want to run any job with the BASIC Transformer in it.

What flavor of UNIX? From what I recall, not all support milliseconds from the system time.

Thanks for posting what worked out for you. :D

The question was actually more for Arnd and/or Ray whenever they come back to the thread, or for whomever wants to chime in on the subject. And now... we wait.

In order to run the BASIC Transformer on multiple servers, don't you need the Server engine installed on all of them?

Hmmm... if your surrogate values are still wrong in the source file (stuck at 2.5M+1) I wouldn't bother to simply restart it.