Previous Topic: How to UseNext Topic: LOGPRINT=DETAILX Example Split File Report


LOGPRINT=DETAIL Example Split File Report

Following is an example report generated by specifying LOGPRINT=DETAIL (same as the basic syntax without options, that is, REPORT AREA=RXX).

Date: mm/dd/ccyy ******************************************************************************** Page: 1 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 Œ REPORT AREA=RXX FUNCTION=REPORT  AREA=RXX Ž

Œ

The command exactly as entered.



An analysis of keywords encountered and expected. Any errors found are flagged with a note in the left margin.

Ž

Any messages related to syntax processing.

Date: mm/dd/ccyy ******************************************************************************** Page: 2 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** Œ  Ž SPLIT FILE GROUP GROUP START GROUP END GROUP9 1/05/00,10.40.44 1/05/00,10.41.45   DBID TABLE URI BLOCK ACTIVITY 789 C01 00000001 00000002 A U D 789 C01 00000002 00000002 A U D 789 C01 00000003 00000002 A U D 789 C01 00000004 00000002 A U D 789 C01 00000005 00000002 A U D 789 C01 00000006 00000002 A U D 789 C01 00000007 00000002 A U D 789 C01 00000008 00000002 A U D 789 C01 00000009 00000002 A U D . . .

Œ

GROUP identifies the split file group.



GROUP START gives the date/time the group started.

Ž

GROUP END gives the date/time the group ended.



DBID specifies a database ID. This is left blank for records without database IDs. It is printed as a decimal number.



TABLE specifies a database 3-character table name.

URI specifies a Unique Row Indentifier. This is left blank for records without a URI number. It is printed in hexadecimal format.

BLOCK specifies a data area block number. This is left blank for records without a data block. It is printed in hexadecimal format.

ACTIVITY lists the action taken on this record. These letters (action codes) can occur in any order. They are shown only when required/desired to support the CA Datacom/DB facilities (that is, they are provided for Technical Support and are not always shown, even though the description would indicate that it should be shown). The possible letters that can be shown on the report are:

A

Add

D

Delete

M

Moved

U

Update

R

Rollback

I

Incomplete task

The previous example defines the provided and optional reports. Each was described as though the entire input was considered selected data (the default), but be aware that numerous data selection options are available. Remember that a log record, to be selected, must pass all of the specified options (a single option can be specified or any combination, including all of them).