SQL DDL

This topic shows detailed information about Accounting - SQL DDL.

This block shows information about SQL DDL (Data Definition Language) statements.

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

Accounting - SQL DDL

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


SQL DDL    CREATE   DROP  ALTER
---------- ------ ------ ------
TABLE           0      0      0
CRT TTABLE      0    N/A    N/A
DCL TTABLE      0    N/A    N/A
AUX TABLE       0    N/A    N/A
INDEX           0      0      0
TABLESPACE      0      0      0
DATABASE        0      0      0
STOGROUP        0      0      0
SYNONYM         0      0    N/A
VIEW            0      0    513
ALIAS           0      0    N/A
PACKAGE       N/A      0    N/A
PROCEDURE       0      0      0
FUNCTION        0      0      0
TRIGGER         0      0    N/A
DIST TYPE       0      0    N/A
SEQUENCE        0      0      0
TRUST. CTX    521    522    523  	
ROLE          531    532    N/A
JAR           N/A    N/A    543
MASK/PERM       0      0      0   
VARIABLE        0      0    N/A   

TOTAL        1052   1054   1579
TRUNC TBL       0
RENAME TBL      0
RENAME IX     551
COMMENT ON      0
LABEL ON        0

CREATE TABLE

The number of CREATE TABLE statements executed.

Field Name: QXCRTAB

CREATE CRT TTABLE

The number of CREATE GLOBAL TEMPORARY TABLE statements executed.

Field Name: QXCRGTT

CREATE DCL TTABLE

The number of DECLARE GLOBAL TEMPORARY TABLE statements executed.

Field Name: QXDCLGTT

CREATE AUX TTABLE

The number of CREATE AUXILIARY TABLE statements executed.

Field Name: QXCRATB

CREATE INDEX

The number of CREATE INDEX statements executed.

Field Name: QXCRINX

CREATE TABLESPACE

The number of CREATE TABLESPACE statements executed.

Field Name: QXCTABS

CREATE DATABASE

The number of CREATE DATABASE statements executed.

Field Name: QXCRDAB

CREATE STOGROUP

The number of CREATE STOGROUP statements executed.

Field Name: QXCRSTG

CREATE SYNONYM

The number of CREATE SYNONYM statements executed.

Field Name: QXCRSYN

CREATE VIEW

The number of CREATE VIEW statements executed.

Field Name: QXDEFVU

CREATE ALIAS

The number of CREATE ALIAS statements executed.

Field Name: QXCRALS

CREATE PROCEDURE

The number of CREATE PROCEDURE statements issued.

Field Name: QXCRPRO

CREATE FUNCTION

The number of CREATE FUNCTION statements executed.

Field Name: QXCRUDF

CREATE TRIGGER

The number of CREATE TRIGGER statements executed.

Field Name: QXCTRIG

CREATE DIST TYPE

The number of CREATE DISTINCT TYPE statements executed.

Field Name: QXCDIST

CREATE SEQUENCE

The number of CREATE SEQUENCE statements.

Field Name: QXCRESEQ

CREATE TRUST. CTX

The number of CREATE TRUSTED CONTEXT statements issued.

Field Name: QXCRCTX

CREATE ROLE

The number of CREATE ROLE statements executed.

Field Name: QXCRROL

CREATE MASK/PERM

The number of CREATE MASK and CREATE PERMISSION statements executed.

Field Name: QXCREMP

CREATE VARIABLE

The number of CREATE VARIABLE statements.

Field Name: QXCRTSV

TOTAL CREATE

The number of SQL CREATE statements executed.

Field Name: ASTOTCRT

This is an exception field.

DROP TABLE

The number of DROP TABLE statements executed.

Field Name: QXDRPTA

This is an exception field.

DROP INDEX

The number of DROP INDEX statements executed.

Field Name: QXDRPIX

This is an exception field.

DROP TABLESPACE

The number of DROP TABLESPACE statements executed.

Field Name: QXDRPTS

This is an exception field.

DROP DATABASE

The number of DROP DATABASE statements executed.

Field Name: QXDRPDB

This is an exception field.

DROP STOGROUP

The number of DROP STOGROUP statements executed.

Field Name: QXDRPST

This is an exception field.

DROP SYNONYM

The number of DROP SYNONYM statements executed.

Field Name: QXDRPSY

This is an exception field.

DROP VIEW

The number of DROP VIEW statements executed.

Field Name: QXDRPVU

This is an exception field.

DROP ALIAS

The number of SQL DROP ALIAS statements executed.

Field Name: QXDRPAL

This is an exception field.

DROP PACKAGE

The number of SQL DROP PACKAGE statements executed.

Field Name: QXDRPPKG

This is an exception field.

DROP PROCEDURE

The number of DROP PROCEDURE statements executed.

Field Name: QXDRPPR

DROP FUNCTION

The number of DROP FUNCTION statements executed.

Field Name: QXDRPFN

DROP TRIGGER

The number of DROP TRIGGER statements executed.

Field Name: QXDRPTR

DROP DIST TYPE

The number of DROP DISTINCT TYPE statements executed.

Field Name: QXDDIST

DROP SEQUENCE

The number of DROP SEQUENCE statements.

Field Name: QXDROSEQ

DROP TRUST. CTX

The number of DROP TRUSTED CONTEXT statements issued.

Field Name: QXDRPCTX

DROP ROLE

The number of DROP ROLE statements issued.

Field Name: QXDRPROL

DROP MASK/PERM

The number of DROP MASK and DROP PERMISSION statements executed.

Field Name: QXDRPMP

DROP VARIABLE

The number of DROP VARIABLE statements.

Field Name: QXDRPSV

TOTAL DROP

The number of SQL DROP statements executed.

Field Name: ASTOTDRP

This is an exception field.

ALTER TABLE

The number of ALTER TABLE statements executed.

Field Name: QXALTTA

This is an exception field.

ALTER INDEX

The number of ALTER INDEX statements executed.

Field Name: QXALTIX

This is an exception field.

ALTER TABLESPACE

The number of ALTER TABLESPACE statements executed.

Field Name: QXALTTS

This is an exception field.

ALTER DATABASE

The number of ALTER DATABASE statements executed.

Field Name: QXALDAB

This is an exception field.

ALTER STOGROUP

The number of ALTER STOGROUP statements executed.

Field Name: QXALTST

This is an exception field.

ALTER VIEW

The number of ALTER VIEW statements issued.

Field Name: QXALTVW

ALTER PROCEDURE

The number of ALTER PROCEDURE statements executed.

Field Name: QXALPRO

ALTER FUNCTION

The number of ALTER FUNCTION statements executed.

Field Name: QXALUDF

ALTER SEQUENCE

The number of ALTER SEQUENCE statements.

Field Name: QXALTSEQ

ALTER TRUST. CTX

The number of ALTER TRUSTED CONTEXT statements issued.

Field Name: QXALTCTX

ALTER ROLE

The number of ALTER JAR statements issued.

Field Name: QXALTJR

ALTER MASK/PERM

The number of ALTER MASK and ALTER PERMISSION statements executed.

Field Name: QXALTMP

TOTAL ALTER

The number of SQL ALTER statements executed.

Field Name: ASTOTALT

This is an exception field.

TRUNC TBL

The number of TRUNCATE TABLE statements issued.

Field Name: QXTRTBL

RENAME TBL

The number of RENAME TABLE statements executed.

Field Name: QXRNTAB

RENAME IX

The number of RENAME INDEX statements issued.

Field Name: QXRNIX

COMMENT ON

The number of COMMENT ON statements executed.

Field Name: QXCMTON

LABEL ON

The number of LABEL ON statements executed.

Field Name: QXLABON