DSXchange

Just off the top of my head, isn't MULTI.VALUE for RetrieVe and MULTIVALUED for SQL?

(They may be synonyms - I'm not in a position to check just now.)

Hire an articulate consultant.

The job status you see in the Director status view is the most recent entry the job process (DSD.RUN) was able to make in its RT_STATUSnnn file. Presumably it was aborted in such an abrupt fashion that it never got the chance to update the RT_STATUSnnn file with a "stopped" or "aborted" or "crashed"...

This is one of those warnings generated by DataStage to let you know that a problem *could* occur. Your input column is defined as int32 (possible values to 2147483647) while your output is defined as decimal(2,0) (possible values to 99). Obviously, if anything larger than 99 came in, it could not b...

The warning is one of those generated by DataStage to indicate that you *could* have a problem; your input column is defined as nullable (and therefore might have nulls) while your output column is defined as non nullable (and therefore can not handle nulls). Either define the input column as not nu...

Iconv(94070, "DYJ") or Iconv(94070, "D2YJ")

There is no sorting in the hashed file stage, unless you specify it as a "selection" phrase. Can you advise what you had in mind here?

Investigate the CoSort plug-in. It absolutely flies, even compared to the UNIX sort. DataStage sort stage comes a bad last.

There's nothing out there, but it wouldn't be too difficult. Date/time modified is in DS_AUDIT. SELECT INSTANCE, DTM FROM DS_AUDIT WHERE CLASS = '4'; will get you started SELECT INSTANCE, DTM FROM DS_AUDIT WHERE EVERY DTM < '2004-08-14'; will get you even closer. You will need also to look at DTC fo...

The source field is a character coming from an Oracle table. It has the date looking format (20041001) and the target database is DB2 and has a Date data type. The most efficient way to get that date into internal format is to rely on the innate cleverness of the Iconv function. All you need to spe...

It's not giving you blank, it's giving you zero-length string, because that's what you've asked it to do. Square brackets indicate substringing. Square brackets with a single number indicate rightmost characters. That you gave a string rather than a number will generate a "non-numeric where numeric ...

These should easily map. In general (ignoring COMP for the moment), a "9" means a numeric character, an "X" means a string character. "9(4)" is a shorthand way of designating "9999" - that is, four numeric characters. The "V" means an implied decimal point. So PIC 99V999 (which could also be PIC 9(2...

You do need row buffering on for the UPC stage to do anything. Yes, you place an IPC stage between two active stages; it introduces a process boundary, in much the same way as a passive stage would, but without the restriction of having to wait until input is closed before opening output. Looks like...

It almost certainly cannot be done for design-time activity, for one very simple reason. Most of the control in DataStage (locks, open dynamic hashed files, etc) is managed in a shared memory segment. As far as I am aware, there is no way to fail-over memory-based structures. Failing-over client con...

It's true in the ODBC stage, provided you load the column definitions with "generated SQL" selected then later switch to "user defined SQL"; maybe that's what he was using?

If you have the file opened for sequential access in DataStage BASIC, one of the items of information returned by the STATUS statement is the file size in bytes (field number 6 of its dynamic array). Is this what you're after? You can determine the number of lines in DataStage BASIC - for a file ope...