File aid batch

Can we see similar funtionality thru online Fileaid too. Posted: Wed Dec 07, am Post subject:. Thanks a ton.. It helps really. Posted: Thu Feb 08, am Post subject:. Posted: Sun Mar 27, am Quote:. Hope this helps Cheers Kolusu. Ravi, what is the total length of the fields 2,4,,11,12,13,14? Also remember that vprint adds 1 space between fields for a better display.

The REPL parameter processes a character-for-character overlay so it was used when the data length was the same. All of the changed records were printed with the LIST parameter. This same change logic could be used with a COPY function to modify records as they are copied to a new file. Also converts Release 7 saved selection criteria to Release 8 selection criteria format. Allows selection parameters to be combined with ACCUM parameters to provide audit-type totals for files.

Performs a copy function that provides greater control over the writing of output records and datasets. Displays VTOC summary information and dataset names in alphabetical sequence based on the specified parameters. To code continuation cards, place a blank in location 1 and make sure the next parameter entry starts before location 26 of the card. Do not split an individual parameter entry element between cards. The order that you code the parameters determines the logic of the statement. Separate multiple parameter identifiers by commas.

You may code multiple parameter identifiers on a continuation line. You can use abbreviations instead of full function, function modifier, or parameter names. Control cards let you identify the functions to perform on the input data, the method to use for record selection, and the specific changes to make to the data. The first two elements are required; the last two are optional.

Figure shows the format of a control card. Note: In this chapter, statements in figures may be spaced differently than the actual control card format to help you delineate the components of control cards. This identifier connects an input dataset to a function that you want to perform. As an option, use this identifier to choose the access method that File-AID uses to process the input dataset. You can attach a dataset organization identifier DSORG ID to any function identifier; it defines the access method used to process the input dataset.

Any logical errors created in this way produce unpredictable results in the output dataset. Parameter identifiers define parameters and consist of a parameter name and one or more elements. Elements define input data, output data, and data handling components of a parameter. The four most common elements used in parameter identifiers are: Location Length Operator Data.

Format rules for these four elements are listed below. Figure shows the format of a typical control card using parameters. Parameter Identifiers Location Element The location element defines where the desired data can be found in the record.

You can specify an actual location or a relative location. Actual Location The actual location can be any number from 1 to 32, 32 KB , but it cannot exceed the record size. You can use the Record Descriptor Word RDW in locations 1 through 4 as the actual location in variable-length records.

If you use the R D W as an actual location, the first valid data position is location 5. If you set the R D W parameter to 2 or 3, the data begins in position 1. To reference three bytes before the current location, use -3 for the location element.

File-AID has two types of relative locations: one references the input record; the other references the output record.

When File-AID retrieves an input record, the input relative location value is set to the beginning of the input record. Product Conventions When an input relative location exceeds the current record boundary, File-AID skips the record and reports it on the statistics line. When data is moved to an output location, the output relative location advances to the next available output location. This allows File-AID to calculate the record length of variable-length output records that you construct.

The output relative location is reset to zero after the next input record is read. Operator Element The operator element sets conditional tests on data in the location identified by the location element. File-AID has two sets of operator elements. One set is for character, packed decimal, or hexadecimal data; the other set is for binary data.

Operator elements for character, packed decimal, and hexadecimal data represent conditions that can occur after a compare instruction is applied to the input data using the data element specified. These operator elements are listed in Table The binary operator elements are listed in Table The length element is used instead of the operator element when the specific location of the compare data is not known.

The value of the length element may be any number from 0 zero through excluding one , but the length added to the current location cannot exceed the record size. If you use a 0 zero for the length element, File-AID calculates the length of the search field that begins at the specified location and ends at the end of the record. Note: The length element is not allowed with packed or binary data elements. Table identifies the data types that you can specify with the data element.

When you code a data element, make sure the actual data follows one of the data identifiers and is enclosed by single quotes apostrophes or double quotes. Table provides examples of each data type.

Character data is case-sensitive. Enclose all character data in either single quotes apostrophes or double quotes. Use single quotes to delimit multiple values separated by commas. Unless commas are enclosed in double quotes, commas indicate an O R condition for selecting records based on matching a list of two or more data values.

Product Conventions This example shows a character data element that tests for the number 10 or C'10,11' Use double quotes to include special characters such as commas and quotes.

This example shows a character data string that contains 10,'11', C"10,'11',12" Text Data Text data can be any length in the control card, but cannot extend past location Text data is non-case-sensitive. Enclose all text data in either single quotes apostrophes or double quotes. This example shows a text data element that tests for any combination of upper and lowercase characters ABCD: T'abcd' Use double quotes to include special characters such as commas and quotes.

Hexadecimal Data Hexadecimal data can be any length that is a multiple of two, but cannot extend past location This example shows a hexadecimal value of F: X'F' Packed Data Packed data can be up to 31 digits or a packed length of 16 bytes. Sign packed data by inserting a positive or negative sign directly after the first quote. Leading zeros are not required when testing for packed values.

All hexadecimal digits that begin at the location you specify and ending at the valid sign must be between zero and nine. Notes: 1. When you use a packed data element to test for a condition in a record, each record tested must have a valid packed data field at the specified location.

The length element is not allowed when testing for packed data elements. Only operator elements are valid when using the packed data element. A binary data element always describes one byte of data. You can represent it one of two ways: Hexadecimal characters. For example: B'C8' Eight-bit true binary value of all zeros or ones. For example: B'' Binary data elements are used to check the condition of bit settings by using one of the valid binary data operator elements as described in Table on page Binary data elements are applied with a test-under-mask instruction to the byte you reference.

Truth of the condition is based on the binary data operator element specified. Note: An operator element is required for testing binary data elements. Only one byte is tested, therefore the length element is not allowed. The binary data element may also be used as new data in a REPL parameter. When a binary data element is used with the REPL parameter, individual target bits can be set ON or O F F by using one of the valid data element types as shown in Table on page Duplication Factor Use a duplication factor to avoid coding repetitive data elements.

Code it as any number from 2 through and place it directly before the data element. If you do not code a value, the default is 1.

The value corresponds to the number of times File-AID finds the data contiguously repeated, beginning at the location you specify in the location element. Scanning Parameters Use scanning parameters to search for a sequence of characters within a range of locations in a record. The scan length can be any number from 0 zero through excluding 1 as long as it is greater than the length of the data element. If you use 0 zero , File-AID calculates a scan length from your specified location to the end of the record.

Scanning repositions the input relative location pointer when the data value is found. Note: A scanning parameter can test only for an equal EQ condition. The data element of a scanning parameter is limited to character or hexadecimal data. Comments Comments are used on control cards as a form of documentation.

Code comments by leaving at least one blank position after the final parameter on a control card. If you do not specify parameters, the comment cannot begin before location Access Method Rules This section discusses rules that are required for accessing input and output datasets. Keyed QSAM datasets cannot be processed with their keys. QSAM datasets with unlike characteristics can be concatenated. When processing concatenated datasets, File-AID reports the number of records processed, volume serial number, and dataset name of each concatenated dataset.

When processing multivolume datasets, File-AID reports the number of records processed and volume serial number of each volume. When File-AID reads unblocked ISAM datasets with a relative key position RKP of zero, it reads the key and data portions of the record into contiguous areas, and sets the relative location pointer to the first data byte between the key and data.

See Figure on page To locate the data portion of the record, use a zero or positive relative location. When copying these records to nonkeyed output datasets, use the MOVE parameter with a negative relative location to transfer both the key and data to the output dataset. When copying to a BDAM file, and the number of input records is less than the number of available output slots, File-AID does not write null binary zeros records to the unused slots. Keyed BDAM output datasets should be written in ascending key sequence.

The key is expected to begin in input record location one 1 , followed by the data. If an error is returned from the open macro, the reset option is turned off and another open macro is tried. If an error is still found, the return code is reported and processing of the dataset ceases.

File-AID provides messages that tell you how the output datasets are opened. These control blocks provide transparency between operating systems, and the ability to accept access method changes, which may be implemented by IBM. The block size of the output dataset must be equal to or larger than the block size of the input dataset.

The logical record length is ignored. Copying load modules created for planned overlay, scatter-loaded, or note listed modules is not supported. Copying aliases is not supported. If an alias is copied, the main module that the alias refers to is copied and the alias name is stored. Input Dataset Requirements File-AID can process 1 to input datasets during an execution with no limitation on type or mixture of dataset organizations.

Some additional installation steps may be required to activate support. If needed, use JCL parameters to override label information. Ensure that data is not truncated in the operation. Unit Affinity Statement When File-AID processes more than one dataset, and each resides on the same physical storage unit, use the unit affinity option to minimize unit allocation time.

Product Conventions File-AID works with each dataset separately; it always closes the current dataset before opening the next one. Therefore, multiple input or output datasets can logically occupy the same physical units to reduce excessive unit allocation. Output Dataset Requirements A maximum of output datasets of any dataset organization or access method can be created during a File-AID execution.

The JCL must include a job statement, execute statement, and data definition statements for all input and output files. Each statement of the JCL is described below. STEPCAT: Optional statement that points to a catalog that contains the datasets when the datasets reside in a catalog other than the system catalog. Access a maximum of input datasets per execution. You must use at least one DDxx statement. The xx value must match the xx value in the corresponding input dataset DDxx.

Process a maximum of output datasets per execution. The datasets can be on tape, cards, printers, or disks. Specify the PDS member name in parentheses. Enclose the X R E F member name in parens after the dataset name. Enclose the selection criteria member name in parens after the dataset name.

DDxxCP: Defines a dataset containing the key information and compare criteria to be applied during a compare. DDxxC: Defines the new dataset and member to be compared. Use any name. File-AID can create a default maximum of eight datasets per execution.

They must be in character format, but may be stored on any type of physical sequential device. To save time, you can abbreviate functions on control cards. Table on page shows the abbreviation for each function and its applicable modifiers. The input D D DD01 must specify an existing valid audit trail file.

The audit trail dataset must be specified as DD You can compare a dataset of any file organization supported by File-AID to any other supported file organization.

You must also specify the compare criteria against which these files are compared in DDxxCP. The TYPE parameter is required. Release 8 X R E F members can contain the dataset name of its associated layouts. To copy specific dataset areas, record types, or number of records, use selection and limiting parameters with the COPY function.

Specify the CEM parameter to copy empty members of a partitioned dataset. A maximum of records are copied. The input and output files cannot be the same file. Processing stops when 15 records are copied. Figure on page is an example of the output produced by the D U M P function. A column scale is printed under each characters to help you locate data. The column scale print is controlled by the F O R M parameter. Use parameters to control the number, or selection, of records to print.

When no limiting parameters are specified, an installation default maximum of records are dumped. This default prevents you from accidentally generating a large volume of print. Use the MOVE parameter to print only selected portions of each record. This application of D U M P is useful for packed and other nonprintable data. The print shows the replacement of the value 50 with the value without actually changing the input data. Use the SHOW parameter to control the format of the information presented for each layout field.

When no limiting parameters are specified, an installation default maximum of records is printed in format mode. It is generally used to list JCL, card images, and other character data. The LIST function prints packed and binary data as blanks. No column scale is printed under each line when using the LIST function. Use parameters with the LIST function to control the number, or selection, of records to list. When no limiting parameters are specified, an installation default maximum of records is listed.

When listing input records that are 80 bytes or smaller, File-AID can be directed to format 80 character print lines. A column scale is printed under each line to help you locate data. When no limiting parameters are specified, an installation default maximum of records is printed. This position is maintained only if the subsequent function processes the file in the same direction. Reversing the processing direction causes File-AID to reset the pointer to either the beginning or end of the file.

Positioning in the file cannot be maintained because the UPDATE function requires the dataset to be closed and reopened for update.

If locations 6 and 7 contain a value of 08, File-AID takes a second accumulation. Comment cards are optional and can be entered at any time. Because they are printed in the order in which they are coded, place the comment cards immediately before the control cards that process the accumulation.

It then produces a twoline dataset identification message after the comment and before the accumulation. The next line contains the accumulation output totals. USER allows greater control when writing output records and datasets. USER can perform three tasks: Insert new records at any point in a dataset Repeat records with changed data Write multiple output datasets from a single input dataset.

New records are built by copying the input record, or by moving data to the output record with the MOVE parameter. If a location has no data moved to it, binary zeros remain. The output area is not reinitialized between writes. Note: An installation default forces the USER function to close all of its output datasets after each use. This allows the output from a USER function to be used as input to another function in the same job step.

This dataset contains every tenth record on the input dataset that contains a value not equal to the characters X, Y, or Z in location A maximum of 25 records are written to the output extract file.

The IF parameter checks to see if the record contains a packed decimal value of 5 beginning in location The first MOVE parameter copies the input record to the output area. The second MOVE parameter moves the two-byte packed decimal value to location The second MOVE parameter loads the required data into the record.

The report format includes spaces separating the fields. The SHOW parameter controls the format of the column headings presented for each layout field. When no limiting parameters are specified, an installation default maximum of records is printed in vertical format mode. For each dataset name, the report lists the file organization, the number of tracks, the percentage of tracks used, and the number of extents. If you want to limit the number of datasets within a volume or unit, use the DSNAME parameter to specify a pattern dataset or fully-qualified dataset name.

The VTOC statistics include volume size in tracks, percentage of tracks used, and whether or not the volume is indexed. DSCB and distributed free space statistics include the number of dataset control blocks, the number of free cylinders, the maximum number of contiguous free cylinders, the number of free tracks, and the maximum number of contiguous free tracks. The information is further limited to those volumes with a volume status of STG storage.

Function Modifiers Function modifiers alter or control the way functions operate. This section discusses the use and format of the three function modifiers and provides example control statements. In addition, groups of parameters may be used to perform multiple subfunctions against a single record. You can form these groups by contiguously coding IF parameters separated by action or limiting parameters.

The ALL modifier has no effect on the number of records that are printed. All parameters may be used with this modifier. When a function that uses the BACK modifier is followed by another function that uses the BACK modifier, the second function begins where the first function stopped.

For example, when the following control cards are run against a record input file, File-AID lists records 90 through In the following example, a common misunderstanding is that it will list the last 10 records of the file.

Instead, File-AID lists the first 10 records of the input file. M E M allows File-AID to search for specific data conditions within each member, and then to process the entire member if the condition is found. The abbreviation and type of each parameter is given in Table Valid abbreviations are also given in parentheses in the parameter and element headings.

Default values that are assumed when the parameter is not coded are indicated with the syntax and the element descriptions. Each section of this chapter describes the use and syntax of a parameter. Example control statements are given for the parameters. Parameter compatibility with the various functions is shown in Table The values are defined as: 0: File-AID completes normal EOJ processing by closing all the files and reflecting the highest return code issued.

This value flushes the job stream and does not produce a dump. The condition code is placed in the user code field. It can be used at any time and with any function. Accumulations may be used to total fields containing numeric character, packed decimal, or binary data. This element is not specified when the data to accumulate is packed decimal. For character and binary data accumulations, the length must be specified.

Maximum length values vary based on the type of data being accumulated as follows: Character data: 15 bytes Binary data: 4 bytes data-type: Type of data to accumulate.

This element is not specified when accumulating packed decimal data. For character and binary data accumulations, the data-type must be specified.

If invalid numeric data is found, an error is detected and processing is terminated. When accumulating packed data, length and data-type need not be specified. However, each record selected for accumulation must have valid packed data at the specified location. If invalid packed data is found, an error is detected and processing is terminated. For a binary data type "B", a length of 4 is always signed. Lengths 1, 2, and 3 are unsigned. Table shows examples of interpreted data values. A maximum of 25 alphanumeric characters can be entered; they must be enclosed in single quotes.

If no description is specified, File-AID prints the field's location as the description. The first group of parameters selects all records that contain the characters 91 in location 10 and the characters 01 in location The selected records are accumulated on the 4-byte binary field beginning in location It can be used after the inclusion of at least one IF parameter. AND is used for clarity in statements. The first statement uses two IF parameters. Y: Copy empty members. This is a PDS statistic that is stored in its directory.

The dates can be complete or partial. Leading zeros are required when specifying the year, month, and day. Entering the same dates in the F R O M and TO fields selects members with modification dates that match only that date.

The two-character year is assumed between and The default table supports USA English. This parameter is valid only for condensed compare.

Condensed compare is for Character and Hexadecimal print formats. No, print all lines. Print ruler only at top of page. Print ruler for every inserted, deleted, and matched record, and every pair of changed records. Do not print ruler. N changed data char: Specify a character to underline the changed data. The default value is the pound sign. To suppress the underline character, enter a blank. It uses the default settings for the additional condensed print options: print only changed lines, print the ruler only at the top of each page, an underscore for changed data, and a pound sign for key or sync field underlining.

Apart from several usage of this utility like copy data sets, concatenate datasets etc. General Structure Code:. Back to top. Posted: Fri Sep 02, pm. This is Madhav i am having one doubt in file aid i am having a string "ABC" i would like to change it to "" when i searched for it is shows that this "ABC" is effected to more than 10th proc , in one shot how can i change to "".

Try the following code Code:. Posted: Fri Sep 16, pm. File aid is having two types one which is used for File operations and second one is used for DB2 file aid for DB2. I found one more File Aid Tips.