FILE-AID TUTORIAL REFERENCE STUDY MATERIAL HELP. DB2 DB2 3 UTILITIES F FILEAID 4 FOREGROUND FI FILEAID/IMS 5 BATCH I IMS FACILITY 6. Generate the JCL required to submit a File-AID/Batch job or any other non File- AID batch utility with File-AID’s Batch Submit utility (option ). Can anyone tell me the use of REFORMAT command??? does this reformat the input file based on the given copybook?? Below is the.

Author: Kaziran Vugrel
Country: Seychelles
Language: English (Spanish)
Genre: Personal Growth
Published (Last): 7 March 2007
Pages: 248
PDF File Size: 10.79 Mb
ePub File Size: 1.75 Mb
ISBN: 727-4-69760-788-4
Downloads: 80730
Price: Free* [*Free Regsitration Required]
Uploader: Kinos

Replaces the first occurrence of a character or hexadecimal data in fixed or variable length records with data of a different length. If the warehouse status location 69 is equal to fileajd, total the quantity on hand packed field at location Separate multiple member names with a comma and surround the names with parentheses.

Places record count limits on the datasets being processed. File-AID is a cross platform file and data management solution. Update statistics, if they exist, or add statistics if they do not exist.

Mainframe Tips, Tricks And Tutorials: Using File-AID/Batch

DROP Eliminates unwanted records from a dataset while copying it. Syntax ni replaces based on a condition at a location.

This is the full compare report.

Allows selection parameters to be combined with ACCUM parameters to provide audit-type totals for urility. Process datasets selectively to view or update information. Accumulate totals to verify reports. The control card used are Code: Indicates movement or change of data.


Only a member of this blog may post utillity comment. Another 39 File Status on VB file. Statement DD01 defines the input dataset. Verifying the logic of a batch job before it is submitted. Selects a group of members from a PDS based on a range of member names.

Check control statement syntax online and execute actions in the foreground with File-AID’s Interactive utility option 3.

In this job i have steps haveing DD statements.


Separate multiple volume serial numbers with a comma. Specifies which field numbers in the record to print in vertical formatted mode. Try these options to select last records: Parameters are described below, grouped according to type. IFNOT works on a ucl equal condition. Terminate all processing and produce a dump if the number of data checks specified in the ERRS parameter is surpassed.

Must be the last control card.

LIST Prints alphanumeric data. Create a complete subset of related files for testing. File-AID reads the records of the input dataset, tests each record for the condition specified in the control statement, and displays the results as foleaid in Figure Selects every nth occurrence of a record for processing. Replaces the first occurrence of data. This example illustrates how you can make a single pass through a master file in this case 34 reels of tape to create two extract output files that contain different subsets of data.

A number from 0 to that does not exceed the record size.

  EV CP2200 PDF

When a blank is encountered, the remainder of the line is treated as a comment. Use a hyphen – to specify the characters to retain from the original member name. To include special characters, such as commas and quotes, as data, use double quotes. The member name can be up to eight characters. Random Key Record Control: Reformats data as it is being copied. Specifies additional options for the condensed Compare reports. Comments may be entered on any control statement after one space following a parameter.

Prints alphanumeric data and labels each record with its record number and RBA. Sends a record to an output file during a USER function. Do not include the RDW during record processing, but display it on output. File-AID executes the statement and immediately displays any results on the screen. Browsing a Data File File-Aid: The next function then begins processing at that record.

Chapter 15. Using File-AID/Batch

Character, alphanumeric data length. Valid only with the Compare function. Up to 48 characters can be specified. Thanks and Regards, KK.

Provides a hardcopy report of records being processed. Maintains PDS member statistics when updating partitioned datasets. Specifies how to process invalid data fields.

Prints n records of alphanumeric data without displaying record number or record length.