DSXchange

The nice thing about ADN is that Ascential employees are officially permitted to post there.

Try the -jobstatus option on dsjob -run to get a more reliable reporting of status on exit.

How is hash1 loaded? When is hash1 loaded? Is it possible that rows have been deleted from basetable since hash1 was loaded?

You can escape the ampersands cd \&PH\&

Or you can hard quote the directory name (single quotes) cd '&PH&'

Either is OK.

Look carefully on the SQL tab to see whether there is any difference at all between the SQL in DataStage and that you're using in TOAD.

Is it UniData temp space or DataStage temp space? The latter is set by the UVTEMP configuration parameter in uvconfig. Search the forum for how to change this. It sounds like the UniData temp space is properly configured. Details on how to do this are in the Administering UniData on UNIX manual.

One other possibility is that the hashed file suffered some form of internal corruption. You need to check for this before clearing or re-creating the hashed file. Write failure for record 'keyvalue' often indicates one bad page (group) within the hashed file structure; all the key values for which ...

No. For a non-partitioned database DataStage simply opens multiple cursors. If the database is capable of parallel execution, this can be used to some advantage.

Yes. But you will require to purchase a valid licence for Linux.

You can start qsrtmngr if logged in as qsadm. You need INTBIN to contain the pathname of the QS installation directory and the PATH and library environment variable (e.g. LIBPATH) to contain the $INTBIN/bin directory. The manual (UNIX_NT_Server_Guide.pdf) contains all of this in Chapter 3. You will ...

User name and password are not stored by DataStage on UNIX; it relies wholly upon operating system authentication. If you uninstall DataStage then re-install you will be safer than simply re-installing. Make sure you've exported any projects, so that you can re-import them afterwards. A small amount...

Yes.

Do nothing. You do not even need NLS.

If the input data are genuinely ASCII, then they will occupy the same code points under UTF-8.

Yes, it's possible. Whether it reaches the 2GB limit obviously depends on the length of the rows. If it's likely to exceed 2GB, create a hashed file that uses 64-bit internal addressing; the 2GB limit then goes away (at the cost of a small amount of additional storage overhead). Theoretical maximum ...

Need to see your whole routine. Post it here, surrounded by Code tags (select the whole code, then click on the Code button above). The JobHandle variable must have been assigned by an earlier DSAttachJob() call. The result from DSGetLogSummary is a "dynamic array". Fields in dynamic arrays are refe...

The best way is to enable auto-purge for the base job, with "jobs over 4 days old" as the setting.

You can do it with SQL, but then you may have to adjust some of the control record settings.