RAMESH KRISHNA REDDY
mainframe discussion forum - cobol, db2,cics, interview questions, quizs

HOME  |  JCL TUTORIALS  |  DRONA TUTORIALS

 

FILE-AID

 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 type 2 Following screen will be displayed
 FILE-AID --------------  BROWSE - DATASET SPECIFICATION  ----------------------
 COMMAND ===>                                                                  
                                                                                
 BROWSE MODE                ===> F          (F=FMT; C=CHAR; V=VFMT; U=UNFMT)    
                                                                                
 SPECIFY BROWSE INFORMATION:                                                    
   DATASET NAME OR HFS PATH ===> 'AYS.VXXXXSW47.XXX.XXX.XXXXREAD'                    <-- (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.DDDD6.XXXX.XXX.XXXX.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.VXXXXSW47.XXX.XXX.XXXXREAD' 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.DDDD6.XXXX.XXX.XXXX.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
 File-AID - Browse - AYS.VXXXXSW47.XXX.XXX.XXXXREAD -------------------- COL 1  70
 COMMAND ===>                                                  SCROLL ===> PAGE
                                    LCR4040L-DATA                LENGTH:   32000
 ---- FIELD LEVEL/NAME ------- -FORMAT- ----+----1----+----2----+----3----+----4
 3 GTR4040L-DATA               639/GRP                                          
   5 SDRYR-FILLER1              8/AN   00000001                                
   5 SDRYR-XXXX-NAME            8/AN   LXXE95                                  
   5 SDRYR-FUNCTION-CODE        5/AN   CXXPL                                   
   5 SDRYR-SUB-FUNCTION-CODE    5/AN                                           
   5 SDRYR-XXXXX-XXXX-CODE       3/GRP                                          
     10 SDRYR-XXXX-CDE          2/AN   00                                      
     10 SDRYR-XXXX-CODE         1/AN   0                                       
   5 SDRYR-OFF-NUM              6/GRP                                          
     10 SDRYR-STATE-CODE        2/AN   42                                      
     10 SDRYR-BRANCH-NUM        4/AN   4104                                    
   5 SDRYR-EMPE-INITS           3/AN                                           
   5 SDRYR-EMPE-XXXX-LOCATION   6/AN                                              
   5 SDRYR-XXXX-XX-NUM-1       10/AN                                           
   5 SDRYR-XXX-XXX-NUM          1/AN                                           
   5 SDRYR-APP-XXX-NUM          2/AN                                           
   5 SDRYR-XXX-TYPE             4/AN   SC                                      
   5 SDRYR-XXX-XXXXXX-CODE      1/AN   0   
                                    
 ENTER CHAR (CHARACTER MODE), VFMT (VERTICAL FORMAT), UNFMT (UNFORMATTED)       
 
type VFMT on command line Following screen will be displayed, (records displayed verically)
  File-AID - Browse - AYS.VXXXXSW47.XXX.XXX.XXXXREAD -------------------- COL 1  26
 COMMAND ===>                                                  SCROLL ===> PAGE
SDRYR-FILLER1 SDRYR-XXXX-NAME SDRYR-XXXXXXON-CODE SDRYR-XXX-XXXXXXX-CODE   
8/AN           8/AN             5/AN                 5/AN                       
(1-8)          (9-16)           (17-21)              (22-26)                    
2------------- 3--------------- 4------------------- 5-----------------------   
00000001       LDSE95           CFDPL                     
00000002       LDSE95           DAST                     
00000003       LDSE95           ASDSD                     
00000004       LDSE95           WWEBD                     
00000005       LDSE95           AWFBD                     
00000006       LDSE95           SERWR                     
00000007       LDSE95           AQFTS                     
00000008       LDSE97           SERWR                     
00000009       LDSE97           SERWR                     
00000010       LDSE97           SERWR                     
00000011       LDSE97           SERWR                     
00000012       LDSE97           SERWR                     
00000013       LDSE97           SERWR                     
00000014       LDSE97           SERWR                     
00000015       LDSE95           SDFDE                     
00000016       LDSE95           APEER                    
00000017       LDSE95           EFGGE                     
 ENTER FMT (FORMATTED MODE), CHAR (CHARACTER MODE),  UNFMT (UNFORMATTED MODE)   
 
type CHAR on command line Following screen will be displayed without showing the field name and lengths
 File-AID - Browse - AYS.VXXXXSW47.XXX.XXX.XXXXREAD -------------------- COL 1  79
 COMMAND ===>                                                  SCROLL ===> PAGE
00000001 LDSE95  APUPL     000424108                            SC  0  1N    343
00000002 LDSE95  APRST     00094                   B2539016CF999SC  0  IN    268
00000003 LDSE95  APRBD     000                                  SC  0  1N    273
00000004 LDSE95  APRBD     000                                  SC  0  2N    574
00000005 LDSE95  APRBD     000                                  SC  0  JN    475
00000006 LDSE95  SERWR     000                                  SC  0  JN    456
00000007 LDSE95  SERWR     000                                  SC  0  JN    343
00000008 LSPA97  SERWR     000                                  SC  0  I     645
00000009 LSPA97  SERWR     000                                  SC  0  I     645
00000010 LSPA97  SERWR     000                                  SC  0  I     645
00000011 LSPA97  SERWR     000                                  SC  0  I     645
00000012 LSPA97  SERWR     000                                  SC  0  2N    321
00000013 LSPA97  SERWR     000                                  SC  0  2N    321
00000014 LSPA97  SERWR     000                                  SC  0  IN    101
00000015 LDSE95  SERWR     000                                  SC  0  IN    503
00000016 LDSE95  UOHMN     000                                  SC  0  IN    190
00000017 LDSE95  VBNFG     000                                  SC  0  IN    333
00000018 LDSE95  YYHRG     000                                  SC  0  IN    420
00000019 LDSE95  GHJGH     000211901                            SC  0  JN    777
00000020 LDSE95  ASDFD     000211901                            SC  0  IN    224
00000021 LDSE95  DSFGR    000                                  SC  0  I     117
 ENTER FMT (FORMATTED MODE), VFMT (VERTICAL FORMAT), UNFMT (UNFORMATTED MODE)   
 
Even If you go to in BROWSE mode , you will get same screens as above (option 1 from FILE-AID main menu) ----------------------- Other Useful Commands ----------------------- HEX ON - The data will be displayed in hexa decimal format. Usaually, it will be used to see COMP-3 values in the data set. Syntax - HEX ON HIDE - This command is used to hide some/all columns Syntax - HIDE <FIELD NUMBER>[-<FIELD NUMBER>] Example - HIDE 1-3 Field1, Field2, Field3 will simply disappear from view DISPLAY - To include or exclude specific items from display or alter the display format of data items Syntax - DISPLAY <FIELD NUMBER>[-<FIELD NUMBER>] [ON/OFF] -------------------- VSAM FILE CREATION -------------------- Type 3, on Mainmenu of FILE-AID The following screen will be displayed
 FILE-AID ------------------  EXTENDED UTILITIES  ------------------------------
 OPTION ===>                                                                   
                                                                                
  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.XXXX.XXX.XXXXREAD'
    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 If you have any questions on FILE AID. You can post them on FILE AID forum. Please send improvement suggestions on this document to srcsinc@yahoo.com




- RAMESH KRISHNA REDDY
 If you feel this material is useful to you and want to improve this site further.... 

 Sharing your knowledge by sending materials/questions which you developed 
 to srcsinc@yahoo.com 
  


Home FILEAID Home | Entertainment | Contactme | Privacy