Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


Using the READLOG Functionality


The READLOG functionality is controlled using a menu from which different listing options may be set before finally performing the read operation.

The different listing options are set by using menu selections 1-5, 9 and 10. The menu is re-displayed after selecting any of these so that further options may be set for the listing.

When all the desired listing options have been set in this way, a listing is produced from the log by choosing menu selection 6, 7 or 8 from under "List operations".

 List definitions    List restrictions   List operations        Change program id
 ----------------    -----------------   ---------------        -----------------
 1. Log list file    3. Time interval    6. Specified tables     9. Enter program
 2. Log list width   4. Ident            7. Tables in databank  10. Leave program
                     5. Databank         8. All (no data)
 0. EXIT

List Definitions (Output Control)

Log List File

Choosing this option allows the operator to specify the name of a sequential file into which the listing is to be placed. In systems where the terminal may be addressed by a logical file name, this may be given to display the listing on the terminal.

If this option is not selected, a sequential file with the default name RDLOGL will be used.

The following examples sets the log file explicitly:

 Select: 1
 Log list file: READLOG.DAT

Log List Width

This option allows the width of the page to be set for the listing output.

The default value is 80. The value given must lie between 72 and 132.

Example:

 Select: 2
 Log list width: 120

List Restrictions

Time interval

This option allows the listing to be restricted to a given time interval, specified as a starting time and a finishing time.

Times are given as a single parameter representing year, month, day, hour, minute and second in the format YYYYMMDDHHMMSS.

If an incomplete time specification is given (truncated from the right), the remaining parameters are taken as low for the starting time and high for the finishing time. Thus giving 200011 as both the starting and finishing time, lists the log from the beginning to the end of November 2000.

A default time value is assumed if no time interval is specified, or may be chosen for starting or finishing time by specifying a "blank" time.

If no start time is specified, the time at the beginning of the log is assumed. If no end time is specified, the time at the end of the log is assumed.

If neither a start time nor an end time is specified, the following message is displayed:

 ** No time restriction
 

A selected time interval applies for all subsequent list operations in the current session until the time interval is reset.

A time interval of two months has been selected in the following example:

 Select: 3
 Format   : YYYYMMDDHHMMSS
 Starttime: 200011
 Endtime  : 200012

Ident

Selecting an ident restricts the listing to operations performed by that ident. Only one ident may be selected for a given listing.

The default setting lists operations performed by all idents.

The default applies if no ident restriction is selected, or may be chosen by specifying a blank ident. If the default is chosen, the following message is displayed:

 ** No ident restriction
 

A selected ident applies for all subsequent list operations in the current session until the ident is reset.

Example:

 Select: 4
 Identname: HOTELADM

Databank

Selecting a databank restricts the listing to operations performed on that databank. This option must be specified if the list operation 7 (Tables in databank) is to be used. Only one databank may be selected for a given listing.

If no databank is specified, the list operation is done for all databanks. If this is the case, the following message is displayed:

 ** No databank restriction

A selected databank applies for all subsequent list operations in the current session until the databank is reset.

Example:

 Select: 5
 Databank: HOTELDB

List Operations

Specified Tables

This option activates listing of the log for selected tables in the database.

As many tables may be specified as are required, with the table name qualified, if necessary, by the name of the schema to which it belongs.

If no schema is specified, the schema with the same name as the current ident is assumed.

Databank restrictions selected with option 5 are ignored if specified tables are selected. However, any ident and time restrictions selected with options 3 and 4 are applied.

The ident running the READLOG functionality must have SELECT access on the requested tables, otherwise the following message is displayed for the table in question:

 ** No select access on table
 

If a non-existent table is requested, the following message is displayed:

 ** No such table
 

Errors of this type do not abort the listing if valid and invalid requests are mixed in the same operation.

The list operation is activated by giving a blank response to the prompt for a table name when all the required tables have been specified, as in the following example:

 Select: 6
 Table: HOTELADM.EMPLOYEE
 Table: HOTELADM.STAFF
 Table: HOTELADM.SALARY
 Table:
 
Note: The list operation can be interrupted by entering an exclamation mark ("!").

Tables in Databank

Operations on all tables in the databank specified under option 5 are listed. If no databank has been selected, the following message is displayed and the user must select a new option:

 **Databank not entered
 

Time or ident restrictions selected with options 3 or 4 are applied.

Data is listed only for those tables to which the ident running the READLOG functionality has SELECT access.

Tables to which access is denied are indicated by the following message in the log list file:

 Table <schema-name.table-name> - No select access

All (No Data)

This option lists logged operations without details of data records (see below). The ident running the READLOG functionality must have BACKUP privilege.

If the privilege is not held by the current ident the following error message is displayed:

 **   AUTHORIZATION FAILURE

Change Program ID

Enter program ident

If a program ident is the creator of a databank, that ident may be entered to read the log for that databank.

Leave program ident

This option leaves the entered program ident.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL System Management Handbook TOC PREV NEXT INDEX