JFileAid

File-AID by BMC Compuware is an essential data management utility that drastically reduces mainframe testing cycles by eliminating the need to write custom COBOL extraction programs. Mastering its advanced commands allows you to manipulate VSAM datasets, sequential files (PS), and partitioned data sets (PDS) in seconds.

The top 10 File-AID tips and shortcuts will streamline your mainframe testing and debugging workflows. Data Navigation & Field Inspection 1. Instantly Locate Invalid Data via Copybooks

Finding corrupt or poorly formatted data (e.g., alphanumeric data in a packed-decimal field) manually is a tedious task.

Action: Open your file in Browse (1) or Edit (2) mode and map it with its corresponding COBOL copybook layout.

Command: Type F /field-name INVALID or F /field-number INVALID on the command line.

Result: The cursor automatically jumps to the first record where the data violates the field’s definition. 2. Freeze Key Columns Using Vertical Format (VFMT)

When dealing with massive files containing hundreds of columns, you can create a layout similar to Microsoft Excel’s “Freeze Panes” feature.

Action: Change your viewing format to Vertical Formatted Mode by typing VFMT on the command line. Command: Issue HOLD 1-3,6.

Result: Fields 1, 2, 3, and 6 lock in place on your screen while you scroll horizontally through the remaining data. 3. Reveal Field Pictures and Memory Offsets

Quickly verify exactly how a field is allocated or stored in memory without opening the standalone COBOL source code.

Action: Ensure you are in the Formatted (FMT) or Vertical Formatted (VFMT) view with a copybook loaded. Commands:

S P (Show Picture) displays the underlying COBOL picture clause (e.g., PIC X(10) or PIC S9(7) COMP-3).

S O (Show Offset) displays the exact byte offset and field size within the record. Dataset Analysis & Quick Utilities 4. Count VSAM Records Quickly via Interactive Utility

Instead of running a heavy batch job or a long IDCAMS REPRO to check record volumes, you can pull metrics interactively. Action: Go to File-AID Option 3.8 (Interactive Utility).

Command: Provide your dataset name and enter TALLY at the command prompt.

Result: File-AID instantly counts and presents the total record count. 5. Track Down Missing Datasets via File List History

If you forget the exact name of a test file you worked on earlier in the week, you can retrieve it instantly without navigating catalog panels.

Command: Type FILE LIST (or FLIST) on the command line of an Edit or Browse specification panel.

Result: A pop-up menu displays a history of recently accessed files along with their previously associated copybooks. Advanced Test Data Manipulation (Batch File-AID) 6. Skip and Extract Specific Records using Pointers

When setting up small unit tests, you often need to grab a handful of records from the middle of a massive production file. Rather than copying the whole file, control your data extraction within a batch JCL using pointers. Mainframe Unit Testing with Confidence