DSXchange

Search the forum for "vertical pivot". The stage variables technique works well both in server and parallel jobs.

You do not need Administrator privilege to run this command.

I could understand "access to the field number ". Could you please explain with an example.. If you have a Hashed File stage with an output link and you open the Columns grid on the output link properties page, you will find three columns in the grid called Position, Type and Assoc. These can speci...

The job log is not removed by compilation. Job log events are purged only if you have automatic purge enabled, and then only on successful completion of a normal run. So you ought to be able to get entries from the log unless the above conditions obtain, in which case they are lost forever. However,...

It's probably OK, and you are likely to recover if you DS.REINDEX ALL when no-one else is using the project.

Hashed file navigation is by ordinal number of the field within the record, so that order is vitally important. In a Hashed File stage you have access to the field number in the Columns grid (if completed they are used in preference to the column names); in a UV stage you do not, so must use the exa...

This error indicates that CASE_TYPE is not defined in the metadata (file dictionary) for the UV table (hashed file). Verify either by importing the UV table definition (click on Detail - you don't need to complete the Import process). Beware that column and table names are case sensitive. If it cont...

Ray how do i create the unix script. do you mean we can pass metadata for a job using shell script please elaborate. You create the script with a text editor. How you get and handle the metadata is up to you. "Dynamic metadata" can not be done in DataStage. This is not a forum for solving non-DataS...

Multiple streams into Oracle for separate partitions (and maybe for separate sub-partitions, though this may not be worth the effort).

You can use user-defined SQL; you job must provide values for the key columns that identify the rows to be deleted, and you include a parameter marker for each in the WHERE clause of your SQL. Make sure that the SELECT operation is complete before you perform any DELETE, otherwise you might introduc...

Yes. The Command button opens a window, connected to the currently selected project, through which you can issue commands such as DS.REINDEX ALL.

Security is not meant to be worked around! That's why I suggested not using the "trusted identity" and explicitly providing user ID and password (as job parameter values).

There are readme files in the branded_odbc directory that specify driver versions. The test utility also displays the driver version number.

QualityStage does not impose any limit on the size of its input files. The only limit that might be imposed would be imposed by the operating system. Check the values of your ulimit settings ( ulimit -a command) to see whether that's a problem. Check with your UNIX administrator as to whether large ...

There are LOTS of different kinds of licence. You should be able to re-license in the Administrator client.