how to create alternate index using file-aid

In this Mainframe Forum - You can post your queries on FILE-AID tool

Moderators: Anuj Dhawan, Moderator Group

Post Reply
RaviTejaG
Member
Posts: 15
Joined: Tue Apr 14, 2009 3:49 pm
Location: MYSORE

how to create alternate index using file-aid

Post by RaviTejaG » Mon May 04, 2009 2:40 pm

i want to create alternate index for a vsam file using file-aid .can any one help .Advance thank you

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

Post by Natarajan » Mon May 04, 2009 2:59 pm

Open File-AID.
Select Option 3 UTILITIES
In next screen.
Select Option 5 VSAM
In Next screen.
Type X... Provide AIX file name.
Natarajan
Chennai

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Mon May 04, 2009 4:23 pm

Please notice, the "selection number" for the option might differ across shop, however, Natarajan has given the "short description" of the "selection number" as well - that should help, I believe.
Regards,
Anuj

RaviTejaG
Member
Posts: 15
Joined: Tue Apr 14, 2009 3:49 pm
Location: MYSORE

Post by RaviTejaG » Tue May 05, 2009 1:28 pm

IN THAT QUESTION I WANT TO CREATE ALTERNATE INDEX ON TWO FIELDS,I.E. FLOOR, CLASS ROOM NO , SO I HAVE CRETE ALTERNATE INDEX AT A TIME ON BOTH,OR I HAVE TO CREATE SEPERATELY FOR EACH AND THEN COMBINE.

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

ALTERNATIVE INDEXES - VSAM

Post by Natarajan » Tue May 05, 2009 5:49 pm

You are not providing full info... please provide structure of your vsam file.. you are refering the fields, but we dont dont know the structure of that vsam file.
Let us know, vsam file structured.

so that we can suggest you whether you can go ahead with defining one AIX or multiple ALTERNATIVE INDEXES.

Please dont use ALL CAPITAL letters while posting.
Natarajan
Chennai

RaviTejaG
Member
Posts: 15
Joined: Tue Apr 14, 2009 3:49 pm
Location: MYSORE

alternate index

Post by RaviTejaG » Wed May 20, 2009 3:38 pm

My vsam file structure is

01 FS-CLASS-REC.
05 FS-CLASSNO PIC 9(5).
05 FILLER PIC X(1).
05 FS-FLOOR PIC A(6).
05 FILLER PIC X(1).
05 FS-CLASSID PIC X(3).
05 FILLER PIC X(1).
05 FS-BATCH PIC X(20).
05 FILLER PIC X(1).
05 FS-FROM PIC X(10).
05 FILLER PIC X(1).
05 FS-TO PIC X(10).
05 FILLER PIC X(21).

in the above vsam structure ,can u tell me how to create alternate index on fields FS-FLOOR and FS-CLASSID.so, that i can uniquely get the record.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others