TITLE1, TITLE2, and TITLE3 Commands

Commands › TITLE1, TITLE2, and TITLE3 Commands

TITLE1, TITLE2, and TITLE3 Commands

Three 60-character lines at the top of each page are reserved for titles. The TITLE1, TITLE2, and TITLE3 commands write titles on the first, second, and third of these lines, respectively. If you do not use the TITLE commands, the Report Writer assigns its own title lines to the report.

Titles are printed only for the report in which the TITLE commands occur. Use the GLOBAL TITLEn command to print the same title for all reports in one run.

The TITLE1 title is printed first, the TITLE2 title is printed below it, and the TITLE3 title appears last. Specify the TITLE1, TITLE2, and TITLE3 commands in that order. You can use none, one, or all of these commands in any combination.

These commands have the following syntax:

TITLE1 titletext
TITLE2 titletext
TITLE3 titletext

titletext: Specifies the title that you assign to the report, up to 60 characters. Every character in the title text must be on the same line as the TITLE1, TITLE2, or TITLE3 command. You cannot continue titles with a continuation character. To insert dynamically dates and times into titletext, use the keywords described in the next section.

TITLEn has the following keywords:

You can use keywords to place dynamically dates and times in your report titles. Keywords have the following format:

&SourceRangeFormat

Replace the variables as shown:

&Source

Replace with one of the following to determine the origin of the dates and times:

C-Uses report command specifications

R-Uses the starting and ending times for the data in the report

E-Uses the EACH command specifications

P-Uses the PERIOD command specifications

Range

Replace with one of the following to determine whether to take data from the FROM command or the TO command:

F-Uses the FROM command specification

T-Uses the TO command specification

Format

Replace with one of the following to determine the format of the date and time:

WEEKDAY = Monday, Tuesday, and so on

DATE = mm/dd/yy or dd/mm/yy (European format)

DAY = dd

EDAY = dd, if your dates are in European format

MONTH = mm

EMONTH = mm, if your dates are in European format

YEAR = yy

TIME = hh:mm:ss

HOUR = hh

MINUTE = mm

SECOND = ss

CALMONTH = January, February, and so on

JDAY = dd (Julian date)

Note: Do not use the &RF and &RT variables with the FLASHBACK reports. The way the FLASHBACK reports process records prevents enumerating the date and time range of the records.

Examples: TITLE1, TITLE2, TITLE3 Commands

To have the title Transaction Use by Hour appear on title line 2, enter the following command:
```
TITLE2 Transaction Use by Hour
```
The following commands dynamically create a date and time on title lines 2 and 3. The data in the report and the FROM and TO commands determine the date and time:
```
TITLE2 FROM: &RFWEEKDAY, &RFCALMONTH &RFDAY, 20&RFYEAR at &RFTIME
TITLE3 TO: &RTWEEKDAY, &RTCALMONTH &RTDAY, 20&RTYEAR at &RTTIME
```

The following is sample output for these commands:

FROM: Thursday, January 27 2011 at 02.58.00
TO: Tuesday, February 01 2011 at 11.23.59