DSXchange

There follows a job control routine that can be pasted into a new server job in order to read one or more table definitions and produce the table definition in a number of output formats. This is job control code. It has been tested with all versions of DataStage from 4.0 through 7.5.2. There are te...

You don't. The stage expects to read all SQL from one file.

Hashed files are not column driven (unless accessed via a UV stage). But you can be selective about which columns you select. Navigation within hashed files is by ordinal position of that field within the data record. There is a Position column in the Columns grid that shows where each field is; thi...

COMMON storage is not an obstacle for routines used in server jobs.

This misconception seems to have arisen because use of variables declared to be COMMON will prevent a server job that uses them from being encapsulated in a shared container and used in a parallel job. That is all.

You could use encrypted environment variables.

I just completed two games of FreeCell while waiting to return to the parallel forum after making a post. That's slow! One of my colleagues suggested that US sites may come in for special attention from the censor, but Hotmail just flies along (then again, that may be a mirror site). But Dilbert and...

DataStage Administrator client.
Projects tab.
Select your project.
Click Command button, which opens Command window.
Execute command there. Make sure that spelling and casing are accurate.

Yes, there is a patch that is REQUIRED if your client is on Windows XP sp2. Search the forum for details about where to find it, or get your support provider to supply it. There is no cost. It used to be downloadable from the Ascential eService web site, but I have no idea where to get it from now.

When i do df -g on "/dstage/Ascential/DataStage/Datasets" i see that it is 89% used. When i do df -g on "/dstage/Ascential/DataStage/Scratch" i see that it is 4% used. This suggests that DataSets and Scratch are on different file systems. Please confirm that this is the case, and also that you (the ...

All table names are recorded in the project's vocabulary. Therefore

You need either to adapt the code, or to use five pairs of stage variables. The code was only written to remember one value. The change would not be difficult.

Or, at rather more expense than EtlStats, you can use the vendor's preferred tool, MetaStage. The benefit of the extra cost is that this tool can also tell you where else (apart from DataStage) these tables and files have been used.

Is this ASCII and binary data, or is there another character set (Thai?) involved? Is the DRS stage set to use ODBC or a native API connection protocol? If a native protocol, are the environment variables that it requires correctly set?

Not enough! Before removing the DS_JOBS entry you will need to remove all its children from DS_JOBOBJECTS. DELETE FROM DS_JOBOBJECTS WHERE OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = 'Arquivo'); Warning Any damage you inflict upon Repository tables is not covered by warranty. Make sure...

I believe that my current problem is (compounded by) the fact that all internet traffic goes through a government "net nanny" that blocks any traffic deemed unacceptable to the good citizens of Dubai. I suspect that that server is overloaded.