Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What is the uses of fileaid

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
sravanthi

New User


Joined: 29 Sep 2004
Posts: 4

PostPosted: Wed Sep 29, 2004 10:37 am    Post subject: What is the uses of fileaid
Reply with quote

uses of fileaid?
Back to top
View user's profile Send private message

priya

Moderator


Joined: 24 Jul 2003
Posts: 568
Location: Bangalore

PostPosted: Wed Sep 29, 2004 10:06 pm    Post subject:
Reply with quote

To create, edit, alter, view, delete VSAM data sets
Back to top
View user's profile Send private message
sudheerkumar_k

New User


Joined: 08 Sep 2004
Posts: 10
Location: Bangalore

PostPosted: Tue Nov 02, 2004 12:17 pm    Post subject: sravanti some more uses
Reply with quote

Sravanti,

Priya exact uses of the fileaid and the apart from those

1.Create GDG
2.Browse of datasets with several selection creteria's.
3.Reformat is one useful factor of fileaid.
Back to top
View user's profile Send private message
kannag

New User


Joined: 02 Aug 2006
Posts: 23
Location: chennai

PostPosted: Wed Aug 02, 2006 9:27 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
xpower

New User


Joined: 07 May 2006
Posts: 35

PostPosted: Thu Aug 10, 2006 7:17 pm    Post subject: selection creteria & reformat in file-aid
Reply with quote

Dear all,
who can kindly give me some description of the selection creteria & reformat in file-aid? could u pls give me simple example.

Thanks in advance..
Back to top
View user's profile Send private message
kannag

New User


Joined: 02 Aug 2006
Posts: 23
Location: chennai

PostPosted: Fri Aug 11, 2006 10:25 am    Post subject: here is the uses of file-aid with attachment.
Reply with quote

hi all, here is the file-aid with explanations


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.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



File-AID - Browse - AYS2.VSQ66.GLOB.FFB.CNTL.TPP -------------------- 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-TRAN-NAME 8/AN LDSE95
5 SDRYR-FUNCTION-CODE 5/AN CSEPL
5 SDRYR-SUB-FUNCTION-CODE 5/AN
5 SDRYR-COMP-CTRY-CODE 3/GRP
10 SDRYR-COMP-CDE 2/AN 00
10 SDRYR-CTRY-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-CURR-LOCATION 6/AN
5 SDRYR-CUST-ID-NUM-1 10/AN
5 SDRYR-DEM-SEQ-NUM 1/AN
5 SDRYR-APP-SEQ-NUM 2/AN
5 SDRYR-APP-TYPE 4/AN SC
5 SDRYR-APP-STATUS-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 - AYS2.VSQ66.GLOB.FFB.CNTL.TPP -------------------- COL 1 26
COMMAND ===> SCROLL ===> PAGE
SDRYR-FILLER1 SDRYR-TRAN-NAME SDRYR-FUNCTION-CODE SDRYR-SUB-FUNCTION-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 - AYS2.VSQ66.GLOB.FFB.CNTL.TPP -------------------- 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.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
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 -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Using Field names in FILEAID Batch CO... Atul Banke Compuware & Other Tools 2 Wed Jun 29, 2016 9:54 pm
No new posts FileAid to compare(logical operations... anand1204 Compuware & Other Tools 3 Wed Apr 06, 2016 2:55 am
No new posts fileaid CHANGED parameter boyti ko Compuware & Other Tools 3 Fri Dec 19, 2014 1:46 pm
No new posts Required equivelent fileaid syntax sreenivasarao sagili Compuware & Other Tools 2 Wed Aug 27, 2014 12:13 pm
No new posts Fileaid batch to fetch the PDS members wiprov Compuware & Other Tools 2 Thu Apr 17, 2014 5:21 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us