IFCID 003 - SQL Call Data

Record trace - IFCID 003 - SQL Call Data

The field labels shown in the following sample layout of Record Trace - IFCID 003 - SQL Call Data are described in the following section.

Java Batch Reporter layout:

                                                            SQL CALL DATA

 SELECT................:            0   INSERT................:            0   UPDATE................:            0
 DELETE................:            0   TYPE 1 INSRT ALG......:            0   PREPARE...............:            1
 DESCRIBE..............:            0   TYPE 2 INSRT ALG......:            0   INSRT ALG. 2 TO 1.....:            0
 OPEN..................:            1   CLOSE.................:            1   FETCH.................:            1
 COMMENT ON............:            0   LOCK TABLE............:            0   GRANT.................:            0
 REVOKE................:            0   INCBND INV STMT.......:            0   INCBND APREUSE........:            0
 INCREMENTAL BINDS.....:            0   LABEL ON..............:            0   DESCRIBE TABLE........:            0
 CONNECT TYPE 1........:            0   CONNECT TYPE 2........:            0   RELEASE...............:            0
 ASSOCIATE LOCATOR.....:            0   ALLOCATE CURSOR.......:            0   RENAME TABLE..........:            0
 HOLD LOCATOR..........:            0   FREE LOCATOR..........:            0   MERGE.................:            0
 TRUNCATE TABLE........:            0   RENAME INDEX..........:            0   CREATE DATABASE.......:            0
 DROP DATABASE.........:            0   ALTER DATABASE........:            0   CREATE STOGROUP.......:            0
 DROP STOGROUP.........:            0   ALTER STOGROUP........:            0   CREATE TABSPACE.......:            0
 DROP TABSPACE.........:            0   ALTER TABSPACE........:            0   CREATE TABLE..........:            0
 DROP TABLE............:            0   ALTER TABLE...........:            0   CREATE AUX TABLE......:            0
 CREATE TMP TABLE......:            0   DECLARE TMP TABLE.....:            0   CREATE INDEX..........:            0
 DROP INDEX............:            0   ALTER INDEX...........:            0   CREATE VIEW...........:            0
 DROP VIEW.............:            0   ALTER VIEW............:            0   CREATE SYNONYM........:            0
 DROP SYNONYM..........:            0   CREATE ALIAS..........:            0   DROP ALIAS............:            0
 CREATE SEQUENCE.......:            0   DROP SEQUENCE.........:            0   ALTER SEQUENCE........:            0
 CREATE TRIGGER........:            0   DROP TRIGGER..........:            0   CREATE DIST TYPE......:            0
 DROP DIST TYPE........:            0   CREATE FUNCTION.......:            0   DROP FUNCTION.........:            0
 ALTER FUNCTION........:            0   CREATE PROCEDURE......:            0   DROP PROCEDURE........:            0
 ALTER PROCEDURE.......:            0   CREATE ROLE...........:            0   DROP ROLE.............:            0
 CREATE TRUST CONT.....:            0   DROP TRUST CONT.......:            0   ALTER TRUST CONT......:            0
 CREATE MASK/PERM......:            0   DROP MASK/PERM........:            0   ALTER MASK/PERM.......:            0
 CREATE VARIABLE.......:            0   DROP VARIABLE.........:            0   DROP PACKAGE..........:            0
 ALTER JAR.............:            0   SET CUR SQL ID........:            0   SET HOST VAR..........:            0
 SET CONNECTION........:            0   SET CUR DEGREE........:            0   SET CUR RULES.........:            0
 SET CUR PATH..........:            0   SET CUR PRECISION.....:            0   SET TIMEOUT (APP).....:            0
 SET TIMEOUT (PRF).....:            0   ROWS FETCHED..........:            1   ROWS INSERTED.........:            0
 ROWS UPDATED..........:            0   ROWS DELETED..........:            0