DSXchange

Parallel job (as marked) or server job (as posted)?

In stage variables convert each list into a dynamic array - convert the ";" characters to @FM.
Create a routine that uses Locate or Find to search for the indicated value and substitute in the other.
Derive the output column by converting the @FM characters back to ";".

Thanks, Phil

You can also minimize all windows or "show desktop". The window that doesn't have focus does not minimize.

Moderator: please move to Enterprise Edition (parallel) forum

Read the error message carefully. It describes precisely what is wrong - what you have forgotten to do.

Please mark this thread as Resolved.

Do you propose to rewrite the whole of DataStage, or just the Lookup stage?

There's nothing contradictory there. Your script would invoke the istool command.

Did you execute the dsenv script first?

Yuk.

I have no idea - it's your business rule. I merely felt compelled to point out how important it was for you to consider it.

Even, long ago, the ability to produce lunch.

(OK, that was a routine, but one that could be called from a stage variable derivation expression.)

Use a mix of Seq() and Char() functions in your stage variables.
Char(Seq(svPrevCharacter)+1) gives the next character, but what do you need to happen if the previous character is "Z"?

Is progress still being reported? Is there a dialog (e.g. "overwrite?") that does not have focus that is waiting for an answer?

Most of the interal functions in server edition are written in C. This includes FMT.

Moderator: please move to Enterprise Edition (Parallel) forum

These are not Server Edition concepts.

Everything in server jobs is a string. The fact that you can use these strings to load into databases is a bonus - but that's precisely what you are doing with manually-entered SQL after all. Thus the easiest way to get a date from a timestamp is to extract the first 10 characters. Left(InLink.TheTi...