file-aid is used to browse,edit, compare the data sets of different modes like, character, vertical, format,unformatted. of vsam files, and non-vsam files.
Editor tool that simplifies the task of browse, edit and compare datasets
File-AID's powerful editor, It is used to browse, edit, allocate, compare, copie,
delete, and print files of any standard MVS access method.For a partitioned database
(PDS), you can browse, edit, and copy an individual member or the entire dataset. We
can do all activities on VSAM files also.
A formatted mode that allows you to browse and edit one record at a time,
field-by-field, using your COBOL or PL/I record layout field names to
describe each field.
A vertical formatted mode that allows you to browse and edit records on a
field-by-field basis using the record layout field names as column headers.
Record layouts can be either COBOL (FD; 01 Level) or PL/I (Declare).
ISPF/PDF starting menu
----------------------- ISPF/PDF PRIMARY OPTION MENU ------------------------
OPTION ===> F
0 ISPF PARMS CA11 CA11/ARTS
1 BROWSE CI CHANGES/ISPF
2 EDIT DB2 DB2
3 UTILITIES F FILEAID
4 FOREGROUND FI FILEAID/IMS
5 BATCH I IMS FACILITY
6 COMMAND ISMF ISMF
7 DIALOG TEST J JCLCHECK
8 SDSF MQ MQSERIES
11 WORKPLACE
A FDR/ABR
BM BOOKMANAGER
C CHANGE MAN
CA7 CA7
type F
Following screen will be dislayed (This is the FILEAID mainmenu)
FILE-AID 8.8.2 ------------- PRIMARY OPTION MENU ----------------------------
OPTION ===>
0 PARAMETERS - SPECIFY ISPF AND FILE-AID PARAMETERS
1 BROWSE - DISPLAY FILE CONTENTS
2 EDIT - CREATE OR CHANGE FILE CONTENTS
3 UTILITIES - FILE-AID/SPF EXTENDED UTILITIES
5 PRINT - PRINT FILE CONTENTS
6 SELECTION - CREATE OR CHANGE SELECTION CRITERIA
7 XREF - CREATE OR CHANGE RECORD LAYOUT CROSS REFERENCE
8 VIEW - VIEW INTERPRETED RECORD LAYOUT
9 REFORMAT - CONVERT FILE FROM ONE FORMAT TO ANOTHER
10 COMPARE - COMPARE FILE CONTENTS
C CHANGES - DISPLAY SUMMARY OF FILE-AID CHANGES
T TUTORIAL - DISPLAY INFORMATION ABOUT FILE-AID
X EXIT - TERMINATE FILE-AID AND RETURN TO ISPF
For browsing datasets use Option 1
For editing datasets use option 2
for both options same screens will be displayed. But In option 2
you can be able to update dataset. Let us go with option 2
BROWSE MODE ===> F (F=FMT; C=CHAR; V=VFMT; U=UNFMT)
SPECIFY BROWSE INFORMATION:
DATASET NAME OR HFS PATH ===> 'AYS.VSW47.GLOB.FFB.TPPREAD' <-- (1)
MEMBER NAME ===> (BLANK OR PATTERN FOR MEMBER LIST)
VOLUME SERIAL ===> (IF DATASET IS NOT CATALOGED)
SPECIFY RECORD LAYOUT AND XREF INFORMATION:
RECORD LAYOUT USAGE ===> S (S = SINGLE; X = XREF; N = NONE) <-- (2)
RECORD LAYOUT DATASET ===> 'AYS2.VSQ66.GLOB.FFB.CNTL.TPP' <-- (3)
MEMBER NAME ===> SPPCAA3 (BLANK OR PATTERN FOR MEMBER LIST) <-- (4)
XREF DATASET NAME ===>
MEMBER NAME ===> (BLANK OR PATTERN FOR MEMBER LIST)
SPECIFY SELECTION CRITERIA INFORMATION: (E = EXISTING; T = TEMPORARY;
SELECTION CRITERIA USAGE ===> N M = MODIFY; Q = QUICK; N = NONE) <-- (5)
SELECTION DATASET NAME ===>
MEMBER NAME ===> (BLANK OR PATTERN FOR MEMBER LIST)
(1) 'AYS.VSW47.GLOB.FFB.TPPREAD' is the data set which conatains data
(2) RECORD LAYOUT USAGE ===> S , if you type S here you should provide copy book
corresponding to above dataset (structure of dataset), type N , if you does not have
copy book for that data set
(3) RECORD LAYOUT DATASET ===> 'AYS2.VSQ66.GLOB.FFB.CNTL.TPP'
This pds contains the copy book
(4) MEMBER NAME ===> SPPCAA3
This is the copy book name in the above dataset (step 3).
(5) SELECTION CRITERIA USAGE ===> N
This option is used to apply different types of criterias on data
if you want to see whole data type 'N'
ENTER
Following screen will be displayed which contains data
This screen shows data record by record, If you want to go to next
record press F11 , for previous record F10
1 LIBRARY - DISPLAY AND MODIFY DIRECTORY ENTRIES; DISPLAY LOAD
MODULE CSECT MAPS; BROWSE, DELETE, RENAME PDS MEMBERS
2 DATASET - DISPLAY DATASET INFORMATION; ALLOCATE NON-VSAM DATASETS
AND GDGS; CATALOG, UNCATALOG, DELETE, OR RENAME DATASETS
3 COPY - COPY ENTIRE DATASETS; COPY SELECTED RECORDS; COPY PDS
MEMBERS BASED ON NAME, STATISTICS AND/OR CONTENT
4 CATALOG - DISPLAY GENERIC CATALOG ENTRIES OR VSAM DATASETS ON A
VOLUME IN LIST FORM AND DO DATASET LIST PROCESSING
5 VSAM - ALLOCATE, DISPLAY, DELETE, MODIFY, OR RENAME VSAM CLUSTERS,
ALTERNATE INDEXES, OR PATHS; MANAGE IAM FILES
6 SEARCH/UPDATE - FIND AND CHANGE ACROSS PDS MEMBERS. SEARCH FOR AND/OR
UPDATE DATA GLOBALLY IN ANY TYPE OF DATASET.
7 VTOC - DISPLAY AND PROCESS DATASETS ON A VOLUME(S)
8 INTERACTIVE - EXECUTE FILE-AID/BATCH
Use option 5 to ALLOCATE, DISPLAY, DELETE, MODIFY OR RENAME VSAM CLUSTERS
type 5
Followig screen will be displayed,
FILE-AID --------------------- VSAM UTILITY ---------------------------------
OPTION ===> A
A - ALLOCATE CLUSTER D - DELETE
S - ALLOCATE DATASPACE DR - DELETE/DEFINE
X - ALLOCATE ALTERNATE INDEX T - DELETE DATASPACE
B - BUILD ALTERNATE INDEX P - ALLOCATE PATH
BLANK - DISPLAY DATASET INFORMATION R - RENAME COMPONENT
M - MODIFY COMPONENT
SPECIFY DATASET INFORMATION:
DATASET NAME ===> 'SSEE.SETW47.GLOB.FFB.TPPREAD'
VOLUME SERIAL ===> (REQUIRED FOR OPTIONS S & T)
PROCESS ONLINE OR BATCH ===> O (O = ONLINE; B = BATCH)
SPECIFY MODEL DATASET INFORMATION:
DATASET NAME ===>
SPECIFY CATALOG TO USE IF OTHER THAN DEFAULT SYSTEM CATALOG:
CATALOG NAME ===>
CATALOG PASSWORD ===> (IF CATALOG IS PASSWORD PROTECTED)
----------------------------------------------------------------------------
Using above screen, We can ALLOCATE, DELETE, MODIFY VSAM DATA SETS