Version 8.2.5
 —  Utilities  —

SPANCOUNT: Count Spanned Records

The SPANCOUNT function counts and displays the number of records in a file that are spanned.

This document covers the following topics:


Syntax

graphics/util_adadbs_spancount.png

Top of page

Essential Parameters

FILE: File Number

FILE specifies the number of the file whose spanned records are to be counted. Specify the valid file number of the file in the database for which you want spanned records counted.

Top of page

Optional Parameters

NOUSERABEND: Termination without Abend

When a parameter error or a functional error occurs while this utility function is running, the utility ordinarily prints an error message and terminates with user abend 34 (with a dump) or user abend 35 (without a dump). If NOUSERABEND is specified, the utility will not abend after printing the error message. Instead, the message "utility TERMINATED DUE TO ERROR CONDITION" is displayed and the utility terminates with condition code 20.

Note:
When NOUSERABEND is specified, we recommend that it be specified as the first parameter of the utility function (before all other parameters). This is necessary to ensure that its parameter error processing occurs properly.

PASSWORD: File Password

The password of the file for which spanned records are to be counted. This parameter is required if the file is password-protected. Specify the password between apostrophes (').

TEST: Test Syntax

The TEST parameter tests the operation syntax without actually performing the operation. Only the syntax of the specified parameters can be tested; not the validity of values and variables. See Syntax Checking with the TEST Parameter for more information on using the TEST parameter in ADADBS functions.

TIMELIMIT: Number of Seconds

The maximum number of seconds the ADADBS SPANCOUNT function may run. If the function takes more time than specified by the TIMELIMIT parameter, the function will be aborted and appropriate error messages are issued.

The default is 60 seconds.

Top of page

Example

In the following example, the spanned records in file 17 are counted.

ADADBS SPANCOUNT FILE=17

The results might look like this:

Records not spanned 15132
Primary records 19345
Secondary records 43897

Top of page