DSXchange

Welcome aboard. Is this an interview question that you're facing?

Not using Count Rows. But you can Sum a column that has 1 in every row, which may have been generated in an upstream Column Generator stage, for example.

With a dot. Please strive for a professional standard of written English on DSXchange. DSXchange is not a mobile phone - there is no need to resort to SMS-style shortcuts. The correct spelling of the word is "please".

kadale.nilesh wrote:U can directly check the value in a particular range.

Indeed, anyone can, not just U (one of our posters).

The descriptions in the manual are quite clear. Show us what you have attempted.

Hanging on locks (a lock?) in the database?

Mark the output as XML. No conversion will occur. Search DSXchange for details of the technique.

Are these precisely the functions you use in MySQL ?

Why not use CurrentDate() and CurrentTime() functions within DataStage instead?

Search DSXchange?

A search for OMD.XML.DIR turned up 11 matches. Is any of them useful?

The "from previous run" message (if any) has Informational severity. Please check again.

The execution strategy is identical on Windows and UNIX. Conductor process reads generated osh and configuration file, then constructs the score. After that it starts a section leader process on each node (using fork() or rsh) and passes the score to each of these. Then the section leaders start pla...

Good. Now please answer the question about whether any "from previous run" information appears in the job log after you reset (not re-compile) an aborted job.

Not counting routines, there is ONE kind of variable - stage variables, which have scope within the body of a Transformer stage. Arguably job parameters act something like variables, though their values cannot be changed (legally) once the job has started.

No new warnings.

You will continue to get any warnings you get from a two-node configuration.

StartLoop and EndLoop activities in sequence seems to me to be the best approach.

Have you loaded format and column metadata onto both input links?