SQL DCL

This topic shows detailed information about Accounting - SQL DCL.

This block shows information about SQL DCL (Data Control Language) declarations.

The following example applies to both, the report layout and the trace layout.

Accounting - SQL DCL

The field labels shown in the following sample layout of Accounting - SQL DCL are described in the following section.


SQL DCL            TOTAL
--------------  --------
LOCK TABLE             0
GRANT                  0
REVOKE                 0
SET CURR.SQLID         0
SET HOST VAR.          0
SET CUR.DEGREE         0
SET RULES              0
SET CURR.PATH          0
SET CURR.PREC          0
CONNECT TYPE 1         0
CONNECT TYPE 2         0
SET CONNECTION         0
RELEASE                0
CALL                   0
ASSOC LOCATORS         0
ALLOC CURSOR           0
HOLD LOCATOR           0
FREE LOCATOR           0
DCL-ALL                0

LOCK TABLE

The number of LOCK TABLE statements executed.

Field Name: QXLOCK

GRANT

The number of GRANT statements executed.

Field Name: QXGRANT

REVOKE

The number of REVOKE statements executed.

Field Name: QXREVOK

SET CURR.SQLID

The number of SET CURRENT SQLID statements executed.

Field Name: QXSETSQL

SET HOST VAR.

The number of SET HOST VARIABLE statements executed. The special register that was retrieved is not tracked.

Field Name: QXSETHV

SET CUR.DEGREE

The number of SET CURRENT DEGREE statements executed.

Field Name: QXSETCDG

SET RULES

The number of SET CURRENT RULES statements executed.

Field Name: QXSETCRL

SET CURR.PATH

The number of SET CURRENT PATH statements executed.

Field Name: QXSETPTH

SET CURR.PREC

The number of SET CURRENT PRECISION statements executed.

Field Name: QXSETCPR

CONNECT TYPE 1

The number of CONNECT type 1 statements executed.

Field Name: QXCON1

CONNECT TYPE 2

The number of CONNECT type 2 statements executed.

Field Name: QXCON2

SET CONNECTION

The number of SET CONNECTION statements executed.

Field Name: QXSETCON

RELEASE

The number of RELEASE statements executed.

Field Name: QXREL

CALL

The number of SQL CALL statements executed.

Field Name: QXCALL

ASSOC LOCATORS

The number of SQL ASSOCIATE LOCATORS statements executed.

Field Name: QXALOCL

ALLOC CURSOR

The number of SQL ALLOCATE CURSOR statements executed.

Field Name: QXALOCC

HOLD LOCATOR

The number of HOLD LOCATOR statements executed.

Field Name: QXHLDLOC

FREE LOCATOR

The number of times a FREE LOCATOR statement was issued.

Field Name: QXFRELOC

DCL-ALL

The total number of DCL statements executed.

Field Name: ASCDCL