DSXchange

Data types are not enforced in sequential files. Therefore, although you might have a field defined as Decimal[5,0], there's nothing to prevent it containing eight digits. You still need to check your data - create a job to read the file and to report the length of the field that is generating the e...

On Windows you need to create a System DSN (not a User DSN) using the ODBC Administrator (Start > Run > odbcad32). The entry in uvodbc.config in the project refers to this DSN which, in turn, makes the DSN visible in the project.

Not quite, I'm talking about when the running job queries the database server to verify the data types of each column, so that it can report data type mismatches. It's my understanding that, whenever a function or expression appears in the SQL, that the database server reports the column as nullable...

Using your time dimension/calendar table also means that you can take into account holidays should you need to.

A UNIX equivalent would be find path -exec UVfile {}\;

The UVfile command is in the DataStage engine bin directory.

Do any of these tools find hashed files whose name is a job parameter? Another utility (on Windows only) is uvwalk with the -uvfile option; it can recursively traverse a directory structure reporting which files are hashed files and which are not. usage: uvwalk [path] {-name filename} {-recurse} {-a...

I assume that your partitioning setting is (Auto) on all stages? That should mean you are getting Round Robin partitioning on sequential-to-parallel links and Same on parallel-to-parallel links, which ought not to affect sorting, but may locate any one key value on multiple nodes. Have you tried exp...

It is not possible. The structure of the DS_METADATA table is inadequately documented to allow for it to be updated. Further, the method of storage changes in version 8.x.

No. Premium membership is one of the ways DSXchange's hosting and bandwidth costs are funded. I do not wish to put the continued existence of DSXchange at risk by establishing such a precedent.

Your customer lacks knowledge. It does not matter what stage type is in the design, the lookup is ALWAYS done against a virtual data set (except in the case of sparse lookup direct to database, which is not supported by using a Lookup File Set).

Resist stupid requirements!

It depends on several other factors too, for example whether operator combination can occur. Look at the job score - the final line will report to you how many processes and how many nodes will be used.

What is your upsert setting?

Create a reject link from the Oracle Enterprise stage.

No.

SCD stage does not perform a true reference lookup in the sense understood and supported by a Lookup File Set.

Can't you write into a PIC 9(9)V99 field or similar?

The quickest way is to open your Administrator client and delete the project. DataStage will not work without metadata so, if you want to delete metadata, you also want to delete DataStage.

Try to find some other way to clean up disk space, or obtain more disk space.