DSXchange

Stage variables store information from header row. Each is updated only if it's a header row. For example svHCol2 might be drived as If InLink.Col1 = "H" Then InLink.Col2 Else svCol2 When processing a detail row, use the stage variables to supply the header row values. Output link is const...

Sorted - and key partitioned - on grouping columns (not necessarily on columns to which you are applying aggregate functions).

Your original question raised your "doubt" - it did not mention that you could not get the command to work. Hence my reply.

And it is documented as behaving thus for SELECT. If you set the Partition Table property then its execution mode may be able to be set to parallel but otherwise you're limited to sequential. This is because of how Oracle delivers its results; they are stored in a temporary table (whether in memory ...

For best performance of the Aggregator stage use sorted input.

Please generate (and post) a target-from-source mapping document, that describes in English the rules for generating the output based on the input.

Try it. If it works you have the correct syntax.

A Search of the Forum would have revealed that, unless you dictate otherwise, they will be found in the directories identified in your current configuration file as scratch disk.

*VMADMSUB is a legacy from when DataStage was built on UniVerse; it is the support subroutine for the UniAdmin client. It would appear that some of the code in DataStage still calls it. Open a telnet session and get into DataStage. Then execute the following commands precisely. LOGTO UV SELECT * FRO...

CRC32 is like a hashing algorithm that generates a 32-bit unsigned integer based on the byte values in the supplied character string. It therefore carries with it the probability that the same value might be generated from two different input values, at a probability level of 1 in 2^32 (approximatel...

Sort data by record type descending then by field2 ascending. In a Transformer stage use stage variables to assemble the desired output records and to store the header record. Constraint the output such that record type = "D".

No.

There are also External Source, External Target, External Filter and Wrapped stages.

Precisely what do you want to do with this shell script?

Yes. But beware that upgrading DataStage will overwrite ds.rc. You may be better to place your script in /etc/rc.d separately.

You only get SQL Server Enterprise stage if DataStage server is installed on a Windows platform. You are on AIX.