DSXchange

The ODBC drivers that ship with DataStage can be used for 30 days then "they" want you to pay for the privilege; "they" in this case being the vendors of the drivers, Data-Direct Technologies. It would be better - in my opinion - were they up-front about this, rather than to suck users in with the u...

If you have Japanese characters in the input you will need the correct Japanese map to translate them when reading the file. There are many different encodings of Japanese characters; sometimes we even find that different columns are encoded differently, or that the map changes during a data stream ...

Is the COSORT_HOME environment variable set in the dsenv file? This is the only place where DataStage processes can be reliably expected to have initialized environment variables.

Welcome aboard! :D You have two choices; you can convert to internal date and time formats and perform the arithmetic then convert back to timestamp format, or you can deal with the substrings in the timestamp and perform the arithmetic on these. The latter works because there are effectively no dat...

Transforms do not have the capability to deal with job parameters. (I am sure this is documeted somewhere; it is obvious when you use the Expression Editor and no "job parameter" appears on the list of available operands.) If you need to use a parameter you will have to use in-line expression within...

The software is on the CD, but you need a separate licence. In version 7, parallel extender is called DataStage Enterprise Edition (or DataStage EE) - this is one of the authorization codes you can enter when installing. You can NOT license the Enterprise Edition from the Administrator client's lice...

Looks like you are writing code using BCI functions. Any time a BCI function returns anything other than SQL.SUCCESS (0), you need to remove any information from the handle in question using SQLError(). So, after your SQLExecDirect() call, what values are returned by the SQLError() function? It may ...

Would that be ten Char(1) columns, or ten Char(10000) columns? How fast can your disks/network deliver data? Are you partitioning the data in any way to take advantage of parallel processing? How fast and how many are your CPUs? How much memory is available? Is the weather fine or raining? (Only jok...

What warning messages are in the job log of (a) the sequence, and (b) the controlled jobs? Reset them all, then check also for any "from previous run..." message, which might contain additional diagnostic information. Did all three jobs abort? What, if any, were your trigger settings in the job sequ...

Based on some key you need to sort the data which can be done through a sorter stage. Then the sorted data is fed to a duplicates remover stage which gives you the required output. Since I am new to DataStage, any experts please correct me if I am wrong The Remove Duplicates stage type is not avail...

EXECUTE starts a new shell, and therefore a new pid is allocated. The pid of its caller is not available (alas). So the pid in the Capturexxxxxaa file may not have a record in &PH&. Another possibility is that you are on a system where pids can be larger than five digits. Only the rightmost five dig...

Add BY.EXP.DSND Reading into your Selection tab. Allow DataStage to generate the counter values, using stage variable or other techniques to detect changes in the value of Asset. Use the "Normalize On" drop down to normalize on Reading. Does UniData support dynamic normalization in the same fashion ...

Indexes on constrained and joining columns will help the SELECT but hinder the update of these tables. You may need an index on the virtual column UPPER(name) to assist the inner query, though you say this is quick.

Nice thought. Have you tried it? Given the limited range of collection algorithms currently supported, I have some reservations over whether it could be done this way. The mechanism that a Transformer stage uses to detect end of data is not available to us within the Transformer, because that test i...

A couple of quick thoughts.

Could this not be done with a UNION?

To get the first in an ordered by, you can use MIN function in the SQL.