Using a hash file with several indexes

[admin]

Hi all.

I need to use a hash file, but I need this file to have several indexes,
each one with its own key (all different keys).

How can I handle this in DataStage 5.2, over a Windows2000 platform ?

Thanks in advance.


Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo

OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
(5411)4510-4330
http://www.osde.com.ar

[admin]

Once the hashed file has been created, you need to create the indexes.

The command is CREATE.INDEX hashedfile columnname

You can create an index in which zero-length strings are not indexed by adding the keyword NO.NULLS to this command.

If there are data in the hashed file, you must explicitly populate the indexes using:
BUILD.INDEX hashedfile ALL
(or you can do them one at a time)

There is no means to create a multi-column index on a hashed file. However, if you use CREATE TABLE to create your hashed file (in a UV stage), then you can use the regular SQL statement CREATE INDEX to create your indexes.

The indexes that exist on a hashed file (or UV table) can be determined with the LIST.INDEX command. For example LIST.INDEX hashedfile ALL (to show all indexes summary) or LIST.INDEX hashedfile columnname DETAIL for complete information.


----- Original Message -----
From: gbarsky@osde.com.ar
Date: Thu, 18 Dec 2003 14:32:39 -0300
To: datastage-users@oliver.com
Subject: Using a hash file with several indexes

>
>
>
>
> Hi all.
>
> I need to use a hash file, but I need this file to have several indexes,
> each one with its own key (all different keys).
>
> How can I handle this in DataStage 5.2, over a Windows2000 platform ?
>
> Thanks in advance.
>
>
> Guillermo P. Barsky - gbarsky@osde.com.ar
> Gerencia de Sistemas - Desarrollo
>
> OSDE Binario - Filial Metropolitana
> Alem 1067, Piso 16
> (5411)4510-4330
> http://www.osde.com.ar
>