Alternate index vs Base Cluster

vsvsankar · New User Joined: 10 Mar 2004 Posts: 7

Hi,

My question is why an alternate index cannot be defined on a base cluster coded with REUSE option.I tried the search engines but couldnt figure out the reason.Can anyone plz provide me with the apt reason.

Thanks in advance.

Vijai

bluebird · Specialist Joined: 03 Feb 2004 Posts: 144

REUSE parm of DEFINE command erases all data on ANY open command.
ALTERNATE INDEXES allow data to be accessed thru an alternate key.
I don't see any point in making a temporary cluster accessible thru an
alternate key (on which any or next open command will erase all data).

BUT , did u have any error message trying to achieve this ?
plz post them, we will be able to investigate further.

vsvsankar · New User Joined: 10 Mar 2004 Posts: 7

Hi,
Thanks bluebird for your prompt response.I dont remember what error i got.But i'll certainly let you know abt it when i code it again.

Thanks,
Vijai

vsvsankar · New User Joined: 10 Mar 2004 Posts: 7

Hi Bluebird,

When i tried to define an alternate index on base cluster coded with reuse option i got the error as "invalid relate object".plz quote me a solution.

Thanks in advance.
Vijai