DSXchange

Read the section on COMMON, particularly named COMMON, in the DataStage BASIC manual. What you got was an artifact of your test processes being in the same session - and would not happen in a real situation.

You need a StartLoop activity AND an EndLoop activity. -----------> StartLoop <-------------------------- EndLoop ----------> | ^ | | V | Activity -------> Activity -------> Activity

FWIW the maximum documented value of PRECISION is 9 but the documentation is incorrect (and has been since 1984). The actual maximum is 14.

What ever happened to sridarg, the original poster?

Please start a new thread, topic ".uvconfig not found". This is NOT the same problem, even though the symptom appears the same.

It could be that someone is doing a major update (and holding a table level lock) while you're trying to obtain/promote a record level lock. Get support involved. "Try again later."

EVERYTHING is possible in Job Control code. It can even make lunch. Begin with a complete and accurate specification of what must happen. Then code it.

Make sure you don't check the "only execute on success" check box!

Right, but I want to know if the server functions can be used in parallel....like ICONV, OCONV and any other numeric, string function that is provided with SERVER EDITION In the parallel Transformer stage, no. In the BASIC Transformer stage, yes, but this has several restrictions particularly in an...

Welcome aboard. :D If you search this forum for interview you will find that, as a community, we are opposed to providing interview questions and answers, and the reasons for that. In any case, different employers have differing requirements. It might well be seen as a sign of initiative were you to...

The first part of the solution is to write in English. A similar manual solution exists for any N, where there are N jobs using the routine. You can determine which these are by performing a Usage Analysis on the Routine. For a sufficiently small N the amount of work is less than trying to script an...

Learned something today. Not a wasted day. Thanks, Craig.

It's definitely not a supported combination. But then neither is Windows XP for the server, and there's a few of those running around.

What sort of price range would you be contemplating?

NONE of which will work unless you have a UNIX-based ODBC driver for Excel.