>>obey TEST_1_3_1_1(tests);
>>
>>------------------------------------------------------------------
>>-- 	TEST CASE
>>------------------------------------------------------------------
>>
>>-- NOTE: the following statement should add a row to cat3.schm.tab3a
>>
>>UPDATE tab1A SET d=2 WHERE a=1;

--- 1 row(s) updated.
>>
>>-- showlabel on trigger should return error
>>showlabel trig1;

*** ERROR[1004] Object CAT1.SCHM.TRIG1 does not exist or object type is invalid for the current operation.

*** ERROR[3225] SHOWLABEL failed for object CAT1.SCHM.TRIG1. The object does not exist in the given namespace TABLE, the object is not accessible, or the object type is not supported. SHOWLABEL supports only SQL tables, views, and indexes.

--- SQL operation failed with errors.
>>
>>showddl tab1A;

CREATE TABLE CAT1.SCHM.TAB1A
  (
    A                                INT NO DEFAULT -- NOT NULL NOT DROPPABLE
  , B                                INT DEFAULT NULL
  , C                                INT DEFAULT NULL
  , D                                INT DEFAULT NULL
  , CONSTRAINT CAT1.SCHM.TAB1A_191488763_9137 PRIMARY KEY (A ASC) NOT DROPPABLE
  , CONSTRAINT CAT1.SCHM.TAB1A_657538763_9137 CHECK (CAT1.SCHM.TAB1A.A IS NOT
      NULL) NOT DROPPABLE
  )
  LOCATION \NSK.$DATA2.ZSDZH88J.HMG4D100
  NAME NSK_DATA2_ZSDZH88J_HMG4D100
  RANGE PARTITION
  STORE BY (A ASC)
  ;
CREATE TRIGGER CAT1.SCHM.TRIG1 AFTER UPDATE ON CAT1.SCHM.TAB1A REFERENCING NEW
  AS NEWROW FOR EACH ROW WHEN (NEWROW.A < 5) INSERT INTO CAT3.SCHM.TAB3A VALUES
  (100, 100);

--- SQL operation complete.
>>showlabel tab1A, detail;
===================================================================

GuardianName: \NSK.$DATA2.ZSDZH88J.HMG4D100
AnsiName: CAT1.SCHM.TAB1A
AnsiNameSpace: TA
AnsiNameObjectType: BT

ObjectSchemaVersion: 2500
ObjectFeatureVersion: 2500

Owner: S-1-5-21-839522115-1383384898-515967899-76232 

RedefTimestamp:    27 Mar, 2012 16:40:47 ( 212199651647650099 )
CreationTimeStamp: 27 Mar, 2012 16:32:10 ( 212199651130971864 )
LastModTimestamp:  27 Mar, 2012 16:37:53 ( 212199651473416615 )
LastOpenTimeStamp: 27 Mar, 2012 16:40:48 ( 212199651648728176 )
SecurityTimestamp: 27 Mar, 2012 16:32:08 ( 212199651128237524 )

SMDtable: F
File Organization: Key-sequenced
Block Length: 4096
File Code: 550

Row Format: ALIGNED FORMAT
AuditCompress: T
Audited: T (If F, a Utility operation is in progress or has failed)
Broken: F
Buffered: T
ClearOnPurge: F
Corrupt: F (If T, a Utility operation is in progress or has failed)
CrashLabel: F
CrashOpen: F

IndexCompress: F
IncompletePartBoundChg: F (If T, a Utility operation is in progress or has failed)
RedoNeeded: F
RollfwdNeeded: F
UndoNeeded: F
UnreclaimedSpace: F (If T, a Utility operation is in progress or has failed)

Primary Extent Size: 16 Pages
Secondary Extent Size: 64 Pages
Max Extents: 160
Extents Allocated: 1
EOF: 12288 

Index Levels: 1

Record Expression Label Length: 11520
Security Label Length: 440

Key Columns: 0 ASC

Partitioning Scheme: RP

Partition Array - 1 partition[s]

IndexMap Array  - 0 index[es]

Trigger Status Array - 1 trigger[s]
Trigger[0]: trigger created (ID): 212199651647650099
  Status: ENABLED

Rcb version: 2500

Column attributes: maxDataLen: 24 (* marks special columns)
  Attr[  0/  1]    dataType: 132  offset:   8 len:   4 align: 4
  Attr[  1/  2]    dataType: 132  offset:  12 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 0
  Attr[  2/  3]    dataType: 132  offset:  16 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 1
  Attr[  3/ -1]    dataType: 132  offset:  20 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 2

===================================================================


--- SQL operation complete.
>>ALTER TRIGGER DISABLE trig1;

--- SQL operation complete.
>>showddl tab1A;

CREATE TABLE CAT1.SCHM.TAB1A
  (
    A                                INT NO DEFAULT -- NOT NULL NOT DROPPABLE
  , B                                INT DEFAULT NULL
  , C                                INT DEFAULT NULL
  , D                                INT DEFAULT NULL
  , CONSTRAINT CAT1.SCHM.TAB1A_191488763_9137 PRIMARY KEY (A ASC) NOT DROPPABLE
  , CONSTRAINT CAT1.SCHM.TAB1A_657538763_9137 CHECK (CAT1.SCHM.TAB1A.A IS NOT
      NULL) NOT DROPPABLE
  )
  LOCATION \NSK.$DATA2.ZSDZH88J.HMG4D100
  NAME NSK_DATA2_ZSDZH88J_HMG4D100
  RANGE PARTITION
  STORE BY (A ASC)
  ;
CREATE TRIGGER CAT1.SCHM.TRIG1 AFTER UPDATE ON CAT1.SCHM.TAB1A REFERENCING NEW
  AS NEWROW FOR EACH ROW WHEN (NEWROW.A < 5) INSERT INTO CAT3.SCHM.TAB3A VALUES
  (100, 100);
ALTER TRIGGER DISABLE CAT1.SCHM.TRIG1 ;

--- SQL operation complete.
>>showlabel tab1A, detail;
===================================================================

GuardianName: \NSK.$DATA2.ZSDZH88J.HMG4D100
AnsiName: CAT1.SCHM.TAB1A
AnsiNameSpace: TA
AnsiNameObjectType: BT

ObjectSchemaVersion: 2500
ObjectFeatureVersion: 2500

Owner: S-1-5-21-839522115-1383384898-515967899-76232 

RedefTimestamp:    27 Mar, 2012 16:40:47 ( 212199651647650099 )
CreationTimeStamp: 27 Mar, 2012 16:32:10 ( 212199651130971864 )
LastModTimestamp:  27 Mar, 2012 16:37:53 ( 212199651473416615 )
LastOpenTimeStamp: 27 Mar, 2012 16:40:48 ( 212199651648728176 )
SecurityTimestamp: 27 Mar, 2012 16:32:08 ( 212199651128237524 )

SMDtable: F
File Organization: Key-sequenced
Block Length: 4096
File Code: 550

Row Format: ALIGNED FORMAT
AuditCompress: T
Audited: T (If F, a Utility operation is in progress or has failed)
Broken: F
Buffered: T
ClearOnPurge: F
Corrupt: F (If T, a Utility operation is in progress or has failed)
CrashLabel: F
CrashOpen: F

IndexCompress: F
IncompletePartBoundChg: F (If T, a Utility operation is in progress or has failed)
RedoNeeded: F
RollfwdNeeded: F
UndoNeeded: F
UnreclaimedSpace: F (If T, a Utility operation is in progress or has failed)

Primary Extent Size: 16 Pages
Secondary Extent Size: 64 Pages
Max Extents: 160
Extents Allocated: 1
EOF: 12288 

Index Levels: 1

Record Expression Label Length: 11520
Security Label Length: 440

Key Columns: 0 ASC

Partitioning Scheme: RP

Partition Array - 1 partition[s]

IndexMap Array  - 0 index[es]

Trigger Status Array - 1 trigger[s]
Trigger[0]: trigger created (ID): 212199651647650099
  Status: DISABLED

Rcb version: 2500

Column attributes: maxDataLen: 24 (* marks special columns)
  Attr[  0/  1]    dataType: 132  offset:   8 len:   4 align: 4
  Attr[  1/  2]    dataType: 132  offset:  12 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 0
  Attr[  2/  3]    dataType: 132  offset:  16 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 1
  Attr[  3/ -1]    dataType: 132  offset:  20 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 2

===================================================================


--- SQL operation complete.
>>
>>-- NOTE: the following statement should NOT add a row to cat3.schm.tab3a
>>
>>UPDATE tab1A SET c=2 WHERE a=1;

--- 1 row(s) updated.
>>
>>-- RESULT: cat3.schm.tab3a should have one row only
>>
>>SELECT count(*) FROM cat3.schm.tab3a;

(EXPR)              
--------------------

                   1

--- 1 row(s) selected.
>>
>>-- Re-enable a disabled trigger and ensure it is in effect.
>>
>>ALTER TRIGGER ENABLE trig1;

--- SQL operation complete.
>>showddl tab1A;

CREATE TABLE CAT1.SCHM.TAB1A
  (
    A                                INT NO DEFAULT -- NOT NULL NOT DROPPABLE
  , B                                INT DEFAULT NULL
  , C                                INT DEFAULT NULL
  , D                                INT DEFAULT NULL
  , CONSTRAINT CAT1.SCHM.TAB1A_191488763_9137 PRIMARY KEY (A ASC) NOT DROPPABLE
  , CONSTRAINT CAT1.SCHM.TAB1A_657538763_9137 CHECK (CAT1.SCHM.TAB1A.A IS NOT
      NULL) NOT DROPPABLE
  )
  LOCATION \NSK.$DATA2.ZSDZH88J.HMG4D100
  NAME NSK_DATA2_ZSDZH88J_HMG4D100
  RANGE PARTITION
  STORE BY (A ASC)
  ;
CREATE TRIGGER CAT1.SCHM.TRIG1 AFTER UPDATE ON CAT1.SCHM.TAB1A REFERENCING NEW
  AS NEWROW FOR EACH ROW WHEN (NEWROW.A < 5) INSERT INTO CAT3.SCHM.TAB3A VALUES
  (100, 100);

--- SQL operation complete.
>>showlabel tab1A, detail;
===================================================================

GuardianName: \NSK.$DATA2.ZSDZH88J.HMG4D100
AnsiName: CAT1.SCHM.TAB1A
AnsiNameSpace: TA
AnsiNameObjectType: BT

ObjectSchemaVersion: 2500
ObjectFeatureVersion: 2500

Owner: S-1-5-21-839522115-1383384898-515967899-76232 

RedefTimestamp:    27 Mar, 2012 16:40:47 ( 212199651647650099 )
CreationTimeStamp: 27 Mar, 2012 16:32:10 ( 212199651130971864 )
LastModTimestamp:  27 Mar, 2012 16:37:53 ( 212199651473416615 )
LastOpenTimeStamp: 27 Mar, 2012 16:40:49 ( 212199651649525015 )
SecurityTimestamp: 27 Mar, 2012 16:32:08 ( 212199651128237524 )

SMDtable: F
File Organization: Key-sequenced
Block Length: 4096
File Code: 550

Row Format: ALIGNED FORMAT
AuditCompress: T
Audited: T (If F, a Utility operation is in progress or has failed)
Broken: F
Buffered: T
ClearOnPurge: F
Corrupt: F (If T, a Utility operation is in progress or has failed)
CrashLabel: F
CrashOpen: F

IndexCompress: F
IncompletePartBoundChg: F (If T, a Utility operation is in progress or has failed)
RedoNeeded: F
RollfwdNeeded: F
UndoNeeded: F
UnreclaimedSpace: F (If T, a Utility operation is in progress or has failed)

Primary Extent Size: 16 Pages
Secondary Extent Size: 64 Pages
Max Extents: 160
Extents Allocated: 1
EOF: 12288 

Index Levels: 1

Record Expression Label Length: 11520
Security Label Length: 440

Key Columns: 0 ASC

Partitioning Scheme: RP

Partition Array - 1 partition[s]

IndexMap Array  - 0 index[es]

Trigger Status Array - 1 trigger[s]
Trigger[0]: trigger created (ID): 212199651647650099
  Status: ENABLED

Rcb version: 2500

Column attributes: maxDataLen: 24 (* marks special columns)
  Attr[  0/  1]    dataType: 132  offset:   8 len:   4 align: 4
  Attr[  1/  2]    dataType: 132  offset:  12 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 0
  Attr[  2/  3]    dataType: 132  offset:  16 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 1
  Attr[  3/ -1]    dataType: 132  offset:  20 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 2

===================================================================


--- SQL operation complete.
>>
>>-- NOTE: the following statement should add a row to cat3.schm.tab3a
>>
>>UPDATE tab1A SET b=2 ;

--- 1 row(s) updated.
>>
>>
>>-- RESULT: cat3.schm.tab3a should have two rows
>>
>>SELECT count(*) FROM cat3.schm.tab3a;

(EXPR)              
--------------------

                   2

--- 1 row(s) selected.
>>
>>DELETE FROM cat3.schm.tab3a;

--- 2 row(s) deleted.
>>
>>ALTER TRIGGER DISABLE trig1;

--- SQL operation complete.
>>showddl tab1A;

CREATE TABLE CAT1.SCHM.TAB1A
  (
    A                                INT NO DEFAULT -- NOT NULL NOT DROPPABLE
  , B                                INT DEFAULT NULL
  , C                                INT DEFAULT NULL
  , D                                INT DEFAULT NULL
  , CONSTRAINT CAT1.SCHM.TAB1A_191488763_9137 PRIMARY KEY (A ASC) NOT DROPPABLE
  , CONSTRAINT CAT1.SCHM.TAB1A_657538763_9137 CHECK (CAT1.SCHM.TAB1A.A IS NOT
      NULL) NOT DROPPABLE
  )
  LOCATION \NSK.$DATA2.ZSDZH88J.HMG4D100
  NAME NSK_DATA2_ZSDZH88J_HMG4D100
  RANGE PARTITION
  STORE BY (A ASC)
  ;
CREATE TRIGGER CAT1.SCHM.TRIG1 AFTER UPDATE ON CAT1.SCHM.TAB1A REFERENCING NEW
  AS NEWROW FOR EACH ROW WHEN (NEWROW.A < 5) INSERT INTO CAT3.SCHM.TAB3A VALUES
  (100, 100);
ALTER TRIGGER DISABLE CAT1.SCHM.TRIG1 ;

--- SQL operation complete.
>>showlabel tab1A, detail;
===================================================================

GuardianName: \NSK.$DATA2.ZSDZH88J.HMG4D100
AnsiName: CAT1.SCHM.TAB1A
AnsiNameSpace: TA
AnsiNameObjectType: BT

ObjectSchemaVersion: 2500
ObjectFeatureVersion: 2500

Owner: S-1-5-21-839522115-1383384898-515967899-76232 

RedefTimestamp:    27 Mar, 2012 16:40:47 ( 212199651647650099 )
CreationTimeStamp: 27 Mar, 2012 16:32:10 ( 212199651130971864 )
LastModTimestamp:  27 Mar, 2012 16:37:53 ( 212199651473416615 )
LastOpenTimeStamp: 27 Mar, 2012 16:40:50 ( 212199651650009368 )
SecurityTimestamp: 27 Mar, 2012 16:32:08 ( 212199651128237524 )

SMDtable: F
File Organization: Key-sequenced
Block Length: 4096
File Code: 550

Row Format: ALIGNED FORMAT
AuditCompress: T
Audited: T (If F, a Utility operation is in progress or has failed)
Broken: F
Buffered: T
ClearOnPurge: F
Corrupt: F (If T, a Utility operation is in progress or has failed)
CrashLabel: F
CrashOpen: F

IndexCompress: F
IncompletePartBoundChg: F (If T, a Utility operation is in progress or has failed)
RedoNeeded: F
RollfwdNeeded: F
UndoNeeded: F
UnreclaimedSpace: F (If T, a Utility operation is in progress or has failed)

Primary Extent Size: 16 Pages
Secondary Extent Size: 64 Pages
Max Extents: 160
Extents Allocated: 1
EOF: 12288 

Index Levels: 1

Record Expression Label Length: 11520
Security Label Length: 440

Key Columns: 0 ASC

Partitioning Scheme: RP

Partition Array - 1 partition[s]

IndexMap Array  - 0 index[es]

Trigger Status Array - 1 trigger[s]
Trigger[0]: trigger created (ID): 212199651647650099
  Status: DISABLED

Rcb version: 2500

Column attributes: maxDataLen: 24 (* marks special columns)
  Attr[  0/  1]    dataType: 132  offset:   8 len:   4 align: 4
  Attr[  1/  2]    dataType: 132  offset:  12 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 0
  Attr[  2/  3]    dataType: 132  offset:  16 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 1
  Attr[  3/ -1]    dataType: 132  offset:  20 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 2

===================================================================


--- SQL operation complete.
>>
>>CREATE TRIGGER trig2 AFTER UPDATE
+>	ON tab1A
+>	REFERENCING NEW AS newrow
+>	FOR EACH ROW
+>		WHEN (newrow.a < 6 )
+>
+>		INSERT INTO cat3.schm.tab3a VALUES (200,200);

--- SQL operation complete.
>>showddl tab1A;

CREATE TABLE CAT1.SCHM.TAB1A
  (
    A                                INT NO DEFAULT -- NOT NULL NOT DROPPABLE
  , B                                INT DEFAULT NULL
  , C                                INT DEFAULT NULL
  , D                                INT DEFAULT NULL
  , CONSTRAINT CAT1.SCHM.TAB1A_191488763_9137 PRIMARY KEY (A ASC) NOT DROPPABLE
  , CONSTRAINT CAT1.SCHM.TAB1A_657538763_9137 CHECK (CAT1.SCHM.TAB1A.A IS NOT
      NULL) NOT DROPPABLE
  )
  LOCATION \NSK.$DATA2.ZSDZH88J.HMG4D100
  NAME NSK_DATA2_ZSDZH88J_HMG4D100
  RANGE PARTITION
  STORE BY (A ASC)
  ;
CREATE TRIGGER CAT1.SCHM.TRIG1 AFTER UPDATE ON CAT1.SCHM.TAB1A REFERENCING NEW
  AS NEWROW FOR EACH ROW WHEN (NEWROW.A < 5) INSERT INTO CAT3.SCHM.TAB3A VALUES
  (100, 100);
CREATE TRIGGER CAT1.SCHM.TRIG2 AFTER UPDATE ON CAT1.SCHM.TAB1A REFERENCING NEW
  AS NEWROW FOR EACH ROW WHEN (NEWROW.A < 6) INSERT INTO CAT3.SCHM.TAB3A VALUES
  (200, 200);
ALTER TRIGGER DISABLE CAT1.SCHM.TRIG1 ;

--- SQL operation complete.
>>showlabel tab1A, detail;
===================================================================

GuardianName: \NSK.$DATA2.ZSDZH88J.HMG4D100
AnsiName: CAT1.SCHM.TAB1A
AnsiNameSpace: TA
AnsiNameObjectType: BT

ObjectSchemaVersion: 2500
ObjectFeatureVersion: 2500

Owner: S-1-5-21-839522115-1383384898-515967899-76232 

RedefTimestamp:    27 Mar, 2012 16:40:50 ( 212199651650337478 )
CreationTimeStamp: 27 Mar, 2012 16:32:10 ( 212199651130971864 )
LastModTimestamp:  27 Mar, 2012 16:37:53 ( 212199651473416615 )
LastOpenTimeStamp: 27 Mar, 2012 16:40:50 ( 212199651650009368 )
SecurityTimestamp: 27 Mar, 2012 16:32:08 ( 212199651128237524 )

SMDtable: F
File Organization: Key-sequenced
Block Length: 4096
File Code: 550

Row Format: ALIGNED FORMAT
AuditCompress: T
Audited: T (If F, a Utility operation is in progress or has failed)
Broken: F
Buffered: T
ClearOnPurge: F
Corrupt: F (If T, a Utility operation is in progress or has failed)
CrashLabel: F
CrashOpen: F

IndexCompress: F
IncompletePartBoundChg: F (If T, a Utility operation is in progress or has failed)
RedoNeeded: F
RollfwdNeeded: F
UndoNeeded: F
UnreclaimedSpace: F (If T, a Utility operation is in progress or has failed)

Primary Extent Size: 16 Pages
Secondary Extent Size: 64 Pages
Max Extents: 160
Extents Allocated: 1
EOF: 12288 

Index Levels: 1

Record Expression Label Length: 11520
Security Label Length: 440

Key Columns: 0 ASC

Partitioning Scheme: RP

Partition Array - 1 partition[s]

IndexMap Array  - 0 index[es]

Trigger Status Array - 2 trigger[s]
Trigger[0]: trigger created (ID): 212199651647650099
  Status: DISABLED
Trigger[1]: trigger created (ID): 212199651650337478
  Status: ENABLED

Rcb version: 2500

Column attributes: maxDataLen: 24 (* marks special columns)
  Attr[  0/  1]    dataType: 132  offset:   8 len:   4 align: 4
  Attr[  1/  2]    dataType: 132  offset:  12 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 0
  Attr[  2/  3]    dataType: 132  offset:  16 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 1
  Attr[  3/ -1]    dataType: 132  offset:  20 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 2

===================================================================


--- SQL operation complete.
>>
>>ALTER TRIGGER ENABLE ALL OF tab1a;

--- SQL operation complete.
>>showddl tab1A;

CREATE TABLE CAT1.SCHM.TAB1A
  (
    A                                INT NO DEFAULT -- NOT NULL NOT DROPPABLE
  , B                                INT DEFAULT NULL
  , C                                INT DEFAULT NULL
  , D                                INT DEFAULT NULL
  , CONSTRAINT CAT1.SCHM.TAB1A_191488763_9137 PRIMARY KEY (A ASC) NOT DROPPABLE
  , CONSTRAINT CAT1.SCHM.TAB1A_657538763_9137 CHECK (CAT1.SCHM.TAB1A.A IS NOT
      NULL) NOT DROPPABLE
  )
  LOCATION \NSK.$DATA2.ZSDZH88J.HMG4D100
  NAME NSK_DATA2_ZSDZH88J_HMG4D100
  RANGE PARTITION
  STORE BY (A ASC)
  ;
CREATE TRIGGER CAT1.SCHM.TRIG1 AFTER UPDATE ON CAT1.SCHM.TAB1A REFERENCING NEW
  AS NEWROW FOR EACH ROW WHEN (NEWROW.A < 5) INSERT INTO CAT3.SCHM.TAB3A VALUES
  (100, 100);
CREATE TRIGGER CAT1.SCHM.TRIG2 AFTER UPDATE ON CAT1.SCHM.TAB1A REFERENCING NEW
  AS NEWROW FOR EACH ROW WHEN (NEWROW.A < 6) INSERT INTO CAT3.SCHM.TAB3A VALUES
  (200, 200);

--- SQL operation complete.
>>showlabel tab1A, detail;
===================================================================

GuardianName: \NSK.$DATA2.ZSDZH88J.HMG4D100
AnsiName: CAT1.SCHM.TAB1A
AnsiNameSpace: TA
AnsiNameObjectType: BT

ObjectSchemaVersion: 2500
ObjectFeatureVersion: 2500

Owner: S-1-5-21-839522115-1383384898-515967899-76232 

RedefTimestamp:    27 Mar, 2012 16:40:50 ( 212199651650337478 )
CreationTimeStamp: 27 Mar, 2012 16:32:10 ( 212199651130971864 )
LastModTimestamp:  27 Mar, 2012 16:37:53 ( 212199651473416615 )
LastOpenTimeStamp: 27 Mar, 2012 16:40:50 ( 212199651650009368 )
SecurityTimestamp: 27 Mar, 2012 16:32:08 ( 212199651128237524 )

SMDtable: F
File Organization: Key-sequenced
Block Length: 4096
File Code: 550

Row Format: ALIGNED FORMAT
AuditCompress: T
Audited: T (If F, a Utility operation is in progress or has failed)
Broken: F
Buffered: T
ClearOnPurge: F
Corrupt: F (If T, a Utility operation is in progress or has failed)
CrashLabel: F
CrashOpen: F

IndexCompress: F
IncompletePartBoundChg: F (If T, a Utility operation is in progress or has failed)
RedoNeeded: F
RollfwdNeeded: F
UndoNeeded: F
UnreclaimedSpace: F (If T, a Utility operation is in progress or has failed)

Primary Extent Size: 16 Pages
Secondary Extent Size: 64 Pages
Max Extents: 160
Extents Allocated: 1
EOF: 12288 

Index Levels: 1

Record Expression Label Length: 11520
Security Label Length: 440

Key Columns: 0 ASC

Partitioning Scheme: RP

Partition Array - 1 partition[s]

IndexMap Array  - 0 index[es]

Trigger Status Array - 2 trigger[s]
Trigger[0]: trigger created (ID): 212199651647650099
  Status: ENABLED
Trigger[1]: trigger created (ID): 212199651650337478
  Status: ENABLED

Rcb version: 2500

Column attributes: maxDataLen: 24 (* marks special columns)
  Attr[  0/  1]    dataType: 132  offset:   8 len:   4 align: 4
  Attr[  1/  2]    dataType: 132  offset:  12 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 0
  Attr[  2/  3]    dataType: 132  offset:  16 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 1
  Attr[  3/ -1]    dataType: 132  offset:  20 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 2

===================================================================


--- SQL operation complete.
>>
>>-- NOTE: the following statement should add TWO rows to cat3.schm.tab3a
>>
>>UPDATE tab1A SET d=2 ;

--- 1 row(s) updated.
>>
>>select * from cat3.schm.tab3a;

A            B          
-----------  -----------

        100          100
        200          200

--- 2 row(s) selected.
>>
>>ALTER TRIGGER DISABLE ALL OF tab1a;

--- SQL operation complete.
>>showddl tab1A;

CREATE TABLE CAT1.SCHM.TAB1A
  (
    A                                INT NO DEFAULT -- NOT NULL NOT DROPPABLE
  , B                                INT DEFAULT NULL
  , C                                INT DEFAULT NULL
  , D                                INT DEFAULT NULL
  , CONSTRAINT CAT1.SCHM.TAB1A_191488763_9137 PRIMARY KEY (A ASC) NOT DROPPABLE
  , CONSTRAINT CAT1.SCHM.TAB1A_657538763_9137 CHECK (CAT1.SCHM.TAB1A.A IS NOT
      NULL) NOT DROPPABLE
  )
  LOCATION \NSK.$DATA2.ZSDZH88J.HMG4D100
  NAME NSK_DATA2_ZSDZH88J_HMG4D100
  RANGE PARTITION
  STORE BY (A ASC)
  ;
CREATE TRIGGER CAT1.SCHM.TRIG1 AFTER UPDATE ON CAT1.SCHM.TAB1A REFERENCING NEW
  AS NEWROW FOR EACH ROW WHEN (NEWROW.A < 5) INSERT INTO CAT3.SCHM.TAB3A VALUES
  (100, 100);
CREATE TRIGGER CAT1.SCHM.TRIG2 AFTER UPDATE ON CAT1.SCHM.TAB1A REFERENCING NEW
  AS NEWROW FOR EACH ROW WHEN (NEWROW.A < 6) INSERT INTO CAT3.SCHM.TAB3A VALUES
  (200, 200);
ALTER TRIGGER DISABLE CAT1.SCHM.TRIG1 ;
ALTER TRIGGER DISABLE CAT1.SCHM.TRIG2 ;

--- SQL operation complete.
>>showlabel tab1A, detail;
===================================================================

GuardianName: \NSK.$DATA2.ZSDZH88J.HMG4D100
AnsiName: CAT1.SCHM.TAB1A
AnsiNameSpace: TA
AnsiNameObjectType: BT

ObjectSchemaVersion: 2500
ObjectFeatureVersion: 2500

Owner: S-1-5-21-839522115-1383384898-515967899-76232 

RedefTimestamp:    27 Mar, 2012 16:40:50 ( 212199651650337478 )
CreationTimeStamp: 27 Mar, 2012 16:32:10 ( 212199651130971864 )
LastModTimestamp:  27 Mar, 2012 16:37:53 ( 212199651473416615 )
LastOpenTimeStamp: 27 Mar, 2012 16:40:51 ( 212199651651431179 )
SecurityTimestamp: 27 Mar, 2012 16:32:08 ( 212199651128237524 )

SMDtable: F
File Organization: Key-sequenced
Block Length: 4096
File Code: 550

Row Format: ALIGNED FORMAT
AuditCompress: T
Audited: T (If F, a Utility operation is in progress or has failed)
Broken: F
Buffered: T
ClearOnPurge: F
Corrupt: F (If T, a Utility operation is in progress or has failed)
CrashLabel: F
CrashOpen: F

IndexCompress: F
IncompletePartBoundChg: F (If T, a Utility operation is in progress or has failed)
RedoNeeded: F
RollfwdNeeded: F
UndoNeeded: F
UnreclaimedSpace: F (If T, a Utility operation is in progress or has failed)

Primary Extent Size: 16 Pages
Secondary Extent Size: 64 Pages
Max Extents: 160
Extents Allocated: 1
EOF: 12288 

Index Levels: 1

Record Expression Label Length: 11520
Security Label Length: 440

Key Columns: 0 ASC

Partitioning Scheme: RP

Partition Array - 1 partition[s]

IndexMap Array  - 0 index[es]

Trigger Status Array - 2 trigger[s]
Trigger[0]: trigger created (ID): 212199651647650099
  Status: DISABLED
Trigger[1]: trigger created (ID): 212199651650337478
  Status: DISABLED

Rcb version: 2500

Column attributes: maxDataLen: 24 (* marks special columns)
  Attr[  0/  1]    dataType: 132  offset:   8 len:   4 align: 4
  Attr[  1/  2]    dataType: 132  offset:  12 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 0
  Attr[  2/  3]    dataType: 132  offset:  16 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 1
  Attr[  3/ -1]    dataType: 132  offset:  20 len:   4 align: 4 
          nullOff: 4 nullBitIdx: 2

===================================================================


--- SQL operation complete.
>>
>>-- NOTE: the following statement should NOT ADD rows to cat3.schm.tab3a
>>
>>UPDATE tab1A SET c=3 ;

--- 1 row(s) updated.
>>
>>-- RESULT: cat3.schm.tab3a should have two rows
>>
>>SELECT count(*) FROM cat3.schm.tab3a;

(EXPR)              
--------------------

                   2

--- 1 row(s) selected.
>>
>>--------------------------------------------------------
>>LOG;
