DSXchange

NONE of the key columns in a hashed file can be null.

If the reference key expression is null, the lookup is not attempted. You can prove this using the Debugger.

Check for UNIX newline characetrs in data, as advised in your other post.

Search the forum. When you specify a partition table in the Oracle Enterprise stage, DataStage must interrogate the Oracle system tables to determine the extents and other bases of partitioning. Chances are that your executing process lacks the requisite SELECT privilege to the eight system tables i...

Search the forum. This is known behaviour. The workaround is to check the number of rows before invoking the job.

If the connection is broken the only thing you can do is establish a new connection. Having done that you may find that the process associated with the lost connection still owns a lock on the job, in which case you may need to remediate that situation. DS.REINDEX only rebuilds indexes. The sequence...

OK, what you can do is find the Vality files, which have the rule set name as the base name, and various suffixes such as ".cls", ".tbl", ".pat" and so on. Find the same (say for rule set USNAME) in QualityStage. By default the rule sets are in C:\Ascential\QualityStageDesigner751\RULES in folders n...

It's the icon second from the right in the Designer toolbar, the icon that looks suspiciously like the Internet Explorer icon. Click it and enjoy the results. Tip: Specify somewhere with a short pathname for the temporary location, for example C:\Temp, whether or not you choose to preserve the inter...

Are these "out of the box" rule sets, or rules that you created in-house? Indeed, can you be specific about which rules/rule sets are missing?

It's all totally different. First you have to install IBM Information Server. Then you have to install IBM Websphere Application Server and configure secuity. Only then do you install DataStage server and license it (and QualityStage, if you have that also). You might also install the Analysis Serve...

You can download marketing material from IBM's web site. You can probably get the manuals for the asking from your vendor. If you have the PACK, you already have the manuals, in PDF form, on the CD.

I have something in my left hand and something in my right hand. Are they the same? You can not compare NULLs - each is unknown. You can determine whether each is null using IsNull(). Technically it's not correct to say that a comparison involving NULL will return FALSE. What's correct is that it ca...

APT_ORCHHOME is necessary for admin utilities such as orchadmin or orchdbutil. Some people also set PXHOME. Both (where used) point to the PXEngine directory - which is a sibling of the DataStage engine directory. Therefore

WAS = WebSphere Application Server

This means that the same user ID can be used for all tools that employ the WAS. DataStage is just one of these tools.

There's an environment variable that allows you to permit "all zeroes" for decimal data types. I'm not "doing" DataStage this week so you will need to research its name for yourself.