DSXchange

You can add $HOME as an environment variable to your project and give it an appropriate default for each project. You can then also add that environment variable to a job design and use it where required to override the project default.

DBMSTYPE must only be one of ODBC or UNIVERSE in the uvodbc.config file. Having changed it to ODBC, you must then set up an ODBC data source name (DSN) that points to the correct Oracle TNS name. DSNs are configured in the $ODBCINI file. It is also necessary that the TNS name be correctly configured...

Did you edit the table definitions within your job designs? Doing so destroys the linkages between jobs and table definitions in the Repository, which MetaStage uses. When using MetaStage, any table definition edit must either be done in the repository and loaded into job designs, or saved from the ...

... which is a DB2 limit, not a DataStage limit. However, with the ability to use DB2 as the common repository, it's another thing of which to be aware.

Please mark the thread as Resolved.

Output column derivations are only performed if the link's constraint expression is satisfied.

Not on any 7.5 system with which I've worked.
Nor do these categories exist.

They've come from in-house or from some consultant you've used. Can you look at the documentation (General or Version tab) to see whether they've admitted to authorship?

Welcome aboard.

Assuming you are talking about postal certification here, the contract with IBM will include regular updates for whichever address databases you buy (for example DPID for Australia, SERP for Canada).

I think it's entirely reasonably that this error is being generated, because 00-000-00 simply is NOT a date.

You need it. It's the address of Ken N.

Get "them" to do do an inhouse demo of the Resource Estimator in version 8 and drool. It may advance your decision date for version 8.

Until then it's going to be monitoring and analyzing dumped scores.

Level 88 (working storage) is not supported by DataStage.
Level 01 will never appear - the level 01 item is taken to be the table name.

Is your Director connected to the correct project? Did you run the jobs in this project?

Welcome aboard. Make sure that Oracle's lib32 appears before lib in the shared library search path (LD_LIBRARY_PATH environment variable). Files in bin ought not to be involved, but you can do the same thing with the command search path (PATH). Set these in the dsenv script.

By default the score does not touch down to disk at all - it is composed by the Conductor process and distributed to the Section Leader processes. Without being dumped by APT_DUMP_SCORE or APT_PX_DEBUG it is ephemeral.

As you note, some of them are chargeable. Therefore there IS no "free version". Redistribution is expressly forbidden by end-user licensing agreements.