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

The RECORDSIZE in the Base cluster, and in Alternate Index


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

Active User


Joined: 02 Jul 2005
Posts: 124
Location: Gurgaon

PostPosted: Mon Aug 21, 2006 11:00 am
Reply with quote

Hi All, The RECORDSIZE in the Base cluster, and in the Alternate Indexes are same or different? Can any one of you please explain the differences about it?

Thanks!
Rathna.
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2358
Location: Israel

PostPosted: Tue Aug 22, 2006 10:21 am
Reply with quote

They are different. The RECORDSIZE for the base cluster should reflect the the actual data's length held in the file. The RECORDSIZE for alternate index is at leath the number of alternate keys for each primary key.

O.
Back to top
View user's profile Send private message
crrindia

Active User


Joined: 02 Jul 2005
Posts: 124
Location: Gurgaon

PostPosted: Tue Aug 22, 2006 12:23 pm
Reply with quote

Hi Thank you very much for your reply. But I couldn't understand the second point which shown below.

The RECORDSIZE for alternate index is at leath the number of alternate keys for each primary key.

Can you please elaborate this? its an urget pelase.

Thanks!
Rathna.
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2358
Location: Israel

PostPosted: Tue Aug 22, 2006 12:27 pm
Reply with quote

I meant "At least".

For more information, please read the fine manual, which explains the concept of alternate index.

O.
Back to top
View user's profile Send private message
crrindia

Active User


Joined: 02 Jul 2005
Posts: 124
Location: Gurgaon

PostPosted: Tue Aug 22, 2006 5:36 pm
Reply with quote

Hi I already read this document, but I couldn't understand that concept.
Can you please elaborate this. If you give some more information with an examples, it would be helpful for me to understand easily. Thank you very much for your continuous co-operation.


Thanks!
Rathna.
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