Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
cobol jcl (ALTERNATE INDEX)

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
annanagarlt

New User


Joined: 31 Oct 2003
Posts: 5

PostPosted: Fri Oct 31, 2003 8:01 pm    Post subject: cobol jcl (ALTERNATE INDEX)
Reply with quote

DEAR ALL

I WOULD LIKE TO KNOW HOW ALTERNATE INDEX WORKS. I WOULD BE HAPPY IF SOMEONE CAN GIVE ME A OPEN SOURCE FOR THE SAME.

HURRY
Back to top
View user's profile Send private message

franclin

New User


Joined: 23 May 2003
Posts: 11
Location: Chennai, India

PostPosted: Thu Nov 06, 2003 9:39 am    Post subject: ALTERNATE INDEX
Reply with quote

Hi ANNANAGARLT,

Apart from access through primary key,VSAM provides use of upto 255 alternate keys per dataset.

With in the KSDS (or) ESDS retriving a data other than the unique key,with in alternate index key duplicate data are allowed.

creation of alternate index using the IDCAMS utility there will be three steps

1.DEFINE AIX --> is used to create an alternate index for the field.
2.DEFINE PATH --> it is used to create a path between your main index and AIX.
3.BUILD INDEX -->Once an AIX has defined, records can be loaded into it using the BLDINDEX command.


EXAMPLE.
/* IDCAMS COMMAND */
DEFINE ALTERNATEINDEX (NAME(SUMAN.KANNAN.AIXVSAM) -
RELATE(SUMAN.KANNAN.VSAM) -
TRACKS(2 2) -
VOLUMES(LMR001 -
) -
CONTROLINTERVALSIZE(4096) -
FREESPACE(10 20) -
RECORDSIZE(20 80) -
KEYS(20 5) -
NONUNIQUEKEY -
UPGRADE -
) -
DATA (NAME(SUMAN.KANNAN.AIXVSAM.DATA) -
) -
INDEX (NAME(SUMAN.KANNAN.AIXVSAM.INDEX) -
)


/* IDCAMS COMMAND */
DEFINE PATH (NAME(SUMAN.KANNAN.PATH) -
PATHENTRY(SUMAN.KANNAN.AIXVSAM) -
UPDATE -
OWNER(LTR040) -
)

/*IDCAMS COMMAND*/
//SYSIN DD *
BLDINDEX INFILE(SUMAN.KANNAN.VSAM)-
OUTFILE(SUMAN.KANNAN.AIXVSAM)

/*
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts KSDS and Index file in cobol deepak14450 COBOL Programming 9 Fri Dec 22, 2017 9:36 am
This topic is locked: you cannot edit posts or make replies. Cobol to fetch the content by using s... arunc55 COBOL Programming 4 Fri Nov 17, 2017 1:25 pm
No new posts VBS and VB, COBOL syntax is the same ... natt.sut COBOL Programming 3 Sun Nov 12, 2017 6:36 am
No new posts COBOL - EXIT statement weird behavior anthony.pangestu COBOL Programming 0 Fri Oct 27, 2017 9:57 am
No new posts Need help on SFTP alternate for LOCSI... ashok_uddaraju JCL & VSAM 2 Thu Oct 26, 2017 12:43 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us