IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Alternate index vs Base Cluster


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vsvsankar

New User


Joined: 10 Mar 2004
Posts: 7

PostPosted: Sun Mar 14, 2004 11:03 am
Reply with quote

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 icon_smile.gif
Back to top
View user's profile Send private message
bluebird

Active User


Joined: 03 Feb 2004
Posts: 127

PostPosted: Tue Mar 16, 2004 12:19 am
Reply with quote

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.
Back to top
View user's profile Send private message
vsvsankar

New User


Joined: 10 Mar 2004
Posts: 7

PostPosted: Wed Mar 17, 2004 6:05 pm
Reply with quote

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
Back to top
View user's profile Send private message
vsvsankar

New User


Joined: 10 Mar 2004
Posts: 7

PostPosted: Sat Mar 20, 2004 9:18 am
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Cobol file using index COBOL Programming 2
No new posts DL/I status code AK for GU call using... IMS DB/DC 1
No new posts Recreating VSAM cluster catalog info ... All Other Mainframe Topics 6
No new posts Add column to existing records using ... JCL & VSAM 2
No new posts choice of clustering index DB2 3
Search our Forums:

Back to Top