Tags

, ,

Locate the INVALID data in a field using FILE AID

The Easiest and Coolest way to locate bad data is thru File-Aid’sF IND command.

1.OPEN the file in FILE-AID (in either browse or edit mode)

2.XREF with COPYBOOK.

3.Use FMT mode

4.Then issue , F /field-name INVALID

                         or

                      F /field-number INVALID

The control will take you to the first invalid data record for the given field.

e.g., The FILE has 3 fields namely NAME,AGE,COUNTRY.

If you want to find the invalid data in the age field, then issue F /2 INVALID  ( AGE is the second field in the copybook)

Important SQL CODES and ABEND CODES
SORT JOIN – TO JOIN TWO FILES BASED ON A KEY
KNOW YOUR MAINFRAME
REXX – INITIAL SETUP
SAS – SAMPLE PROGRAM
CA DISPATCH – Useful Commands
Locate the INVALID data in a field using FILE AID
File-Aid Relational Operators, Data Types
Xpediter – Batch Setup
FILE AID – VIEW TIP
FILEAID TIPS
EDIT PDS USING FILE-AID – FAST MODE
VSAM – KEYS
Comparison of ESDS, KSDS, RRDS, VRRDS, and linear data sets
VSAM OPEN CLOSE I/O RETURN CODES
VSAM INTERVIEW QUESTIONS
VSAM TIPS
Advertisements