DSXchange

You need to put your DB2-specific environment variables into either the dsenv script or into the Administrator client.

Check your output link execution order. The Otherwise/Log output should be the final one executed. A Reject output link from a parallel Transformer stage handles any input link that causes an exception.

All enhancement requests posted here are forwarded to IBM.

You must have exclusive access to the project to re-index. I agree with Arnd's diagnosis.

Wouldn't the job be easier to maintain if you calculated the actual ages (in stage variables, perhaps) and compared those?

You can easily mask with the Fmt() function.

You can easily mask with the Fmt() function.

A UniVerse table IS a hashed file. Whether you use a UV stage or a Hashed File stage to access it is immaterial unless your access is via the primary key, in which case a Hashed File stage is definitely to be preferred. UniVerse IS a database. So your sub heading "Performance of Universe Compared to...

Please verify that the connection via telnet was successful, that DS.REINDEX ALL succeeded. If so, please do the same but this time execute the command DS.CHECKER. DSR_PROJECT is a "helper subroutine" which should be cataloged in the project. Therefore, while you're there, can you also execute the c...

That one, since it refers to the global catalog space, suggests that the DataStage server has not been successfully installed.

Load them into a UV table. Take two links out of the UV table each grouped by the first two columns; one constrained on HAVING COUNT(*) = 1 and the other constrained on HAVING COUNT(*) > 1. Constraints here are in the SELECT statements that extract rows from the UV table, not in DataStage.

Connect to the server using telnet, cd to the problem project and try to invoke dssh once there (having executed $DSHOME/dsenv). If you can get to the TCL prompt, make sure that you are the only user in the project, then execute the DS.REINDEX ALL command. Let us know whether that solves the problem.

I have uploaded the HFC.exe to this free site. Feel free to download it http://www.upload2.com/?cmd=_viewer&file=97a893a284c6cd892204ab324aee21d1.zip&s=file-upload Note: Copy and paste this url into your browser (Disable pop-up temporarily if wanted) Download at own risk as it is uploaded t...

1. Why not? A project is simultaneously a schema, a directory and an account. 2. Yes you can. The DataStage command for listing column definitions is LIST.DICT, for example LIST.DICT RT_LOG But not all of the column definitions for this database are published. This is a deliberate decision by the ve...

No joy from me. I'm also convinced that there's no mechanism in DataStage - apart, perhaps, from a Build stage - that can do what you seek.