Database Utilities › General Report Writer Program (SARGRW) › Report Writer Field Names

Report Writer Field Names

Field names reference and maintain information or data by the general report writer:

• Database fields reference information from the database.
• Database fields are presented chronologically and by database record.
• Defined fields save information independent from the database.

  The DEFINE control statement defines these fields.

• Reserved fields contain the current date, current time, line size, column position, and so on.

Each field name can contain a single type of data. The types of data that can be maintained are as follows:

• Binary (B)
• Character (C)
• Packed (P)
• Date (D)
• Time (T)

Dates are maintained as the number of days from January 1, 1900 in a binary format. Times are maintained as hundredths of seconds in a binary format.

When date fields are output with the OUTPUT control statement, they are output as a 4-byte Julian date in packed decimal as 0CYYDDDF, where:

• C represents the century as follows:
  • 0 represents years 1900 through 1999
  • 1 represents years 2000 through 2099
• YY represents the last two digits of the year
• DDD represents the day of the year (000 to 366)
• F represents the 4-bit sign character

To alter the appearance of the date field in the output file, use the EDIT function.

Date Field Example

The Julian date '0101025F' represents January 25, 2001.

Sequence in Which Database Records Are Accessed

The SARGRW utility program accesses database records based on the database fields that are referenced. The following guidelines determine the sequence in which database records are accessed:

• If database fields from the report control record are referenced, database records are retrieved in SYSOUT/Report identifier (ID) sequence.
• If database fields from the job control record are referenced, database records are retrieved in JOBNAME sequence.
• If database field from the tape control record are only referenced, database records are sequenced by type of tape (primary, duplex, or disaster recovery) and tape sequence number.

When database fields from the report control record and tape control record are referenced, SARGRW retrieves all tape references for the report including continuation tapes. These tape references are primary backup tapes, duplex backup tapes, and disaster recovery tapes, or a combination of these tape types. The TAPESEQ field identifies the tape sequence number of the tape, and the TAPEPOS fields identify the location on the tape where the report resides. Use the TAPETYPE fields, TAPEDSN fields, or both fields, to determine the type and name of the tape being retrieved.