db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kahat...@apache.org
Subject svn commit: r1341046 [5/6] - in /db/derby/code/trunk/java: drda/org/apache/derby/impl/drda/ engine/org/apache/derby/iapi/services/io/ engine/org/apache/derby/iapi/sql/ engine/org/apache/derby/iapi/types/ engine/org/apache/derby/impl/sql/execute/ shared...
Date Mon, 21 May 2012 14:30:25 GMT
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out?rev=1341046&r1=1341045&r2=1341046&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatelocksJDBC30.out Mon May 21 14:30:24 2012
@@ -57,7 +57,7 @@ ij> --
 create view lock_table as
 select 
     cast(username as char(8)) as username,
-    cast(t.type as char(8)) as trantype,
+    cast(t.type as char(15)) as trantype,
     cast(l.type as char(8)) as type,
     cast(lockcount as char(3)) as cnt,
     mode,
@@ -201,87 +201,87 @@ ij> ------------------------------------
 get with hold cursor scan_cursor as
     'select a, b, c from a for update';
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 2          |20         |two                                                                                                                             
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,8)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |30         |three                                                                                                                           
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 4          |40         |four                                                                                                                            
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,10)    |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,10)    |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 5          |50         |five                                                                                                                            
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 6          |60         |six                                                                                                                             
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,12)    |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,12)    |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 7          |70         |seven                                                                                                                           
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,13)    |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,13)    |GRANT|ACTIVE  
 ij> next scan_cursor;
 No current row
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> close scan_cursor;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> commit;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
 ij> commit;
 ij> --------------------------------------------------------------------------------
 -- Test full cursor scan which deletes "even" rows.
@@ -291,18 +291,18 @@ ij> ------------------------------------
 get with hold cursor scan_cursor as
     'select a, b, c from a for update';
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -310,21 +310,21 @@ A          |B          |C               
 ij> delete from a where current of scan_cursor;
 1 row inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,8)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,8)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |30         |three                                                                                                                           
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -332,23 +332,23 @@ A          |B          |C               
 ij> delete from a where current of scan_cursor;
 1 row inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,10)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,10)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,10)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,10)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 5          |50         |five                                                                                                                            
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,10)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,10)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -356,42 +356,42 @@ A          |B          |C               
 ij> delete from a where current of scan_cursor;
 1 row inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |4   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,12)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,10)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,12)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |4   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,12)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,10)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,12)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 7          |70         |seven                                                                                                                           
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |4   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,13)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,10)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,12)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |4   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,13)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,10)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,12)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 No current row
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |4   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,10)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,12)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |4   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,10)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,12)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
 ij> close scan_cursor;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |4   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,10)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,12)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |4   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,10)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,12)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,8)     |GRANT|ACTIVE  
 ij> commit;
 ij> -- The above delete and commit can allow post commit processing to run before
 -- the subsequent select is run, most likely if this run is on a table where
@@ -403,8 +403,8 @@ ij> -- The above delete and commit can a
 CALL WAIT_FOR_POST_COMMIT();
 0 rows inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
 ij> commit;
 ij> select * from a;
 A          |B          |C                                                                                                                               
@@ -428,60 +428,60 @@ ij> ------------------------------------
 get with hold cursor scan_cursor as
     'select a, b, c from a for update';
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |30         |three                                                                                                                           
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 5          |50         |five                                                                                                                            
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 7          |70         |seven                                                                                                                           
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,13)    |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,13)    |GRANT|ACTIVE  
 ij> next scan_cursor;
 No current row
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> close scan_cursor;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> commit;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
 ij> commit;
 ij> select * from a;
 A          |B          |C                                                                                                                               
@@ -505,18 +505,18 @@ ij> ------------------------------------
 get with hold cursor scan_cursor as
     'select a, b, c from a for update';
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -524,11 +524,11 @@ A          |B          |C               
 ij> update a set a=-3,b=-30,c='-three' where current of scan_cursor;
 1 row inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -536,42 +536,42 @@ A          |B          |C               
 ij> update a set a=-5,b=-50,c='-five' where current of scan_cursor;
 1 row inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,11)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,11)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 7          |70         |seven                                                                                                                           
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,13)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,11)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,13)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,11)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 No current row
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,11)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,11)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
 ij> close scan_cursor;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,11)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,11)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
 ij> commit;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
 ij> commit;
 ij> select * from a;
 A          |B          |C                                                                                                                               
@@ -593,42 +593,42 @@ ij> ------------------------------------
 get with hold cursor scan_cursor as
     'select a, b, c from a where a < 0 for update';
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 -3         |-30        |-three                                                                                                                          
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 -5         |-50        |-five                                                                                                                           
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
 ij> next scan_cursor;
 No current row
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> close scan_cursor;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> commit;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
 ij> commit;
 ij> select * from a;
 A          |B          |C                                                                                                                               
@@ -650,9 +650,9 @@ ij> ------------------------------------
 get with hold cursor scan_cursor as
     'select a, b, c from a where a > 0 for update';
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -660,11 +660,11 @@ A          |B          |C               
 ij> delete from a where current of scan_cursor;
 1 row inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,7)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,7)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -672,27 +672,27 @@ A          |B          |C               
 ij> delete from a where current of scan_cursor;
 1 row inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,13)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,13)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,7)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,13)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,13)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,7)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 No current row
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,13)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,7)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,13)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,7)     |GRANT|ACTIVE  
 ij> close scan_cursor;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,13)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,7)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,13)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,7)     |GRANT|ACTIVE  
 ij> commit;
 ij> -- The above delete and commit can allow post commit processing to run before
 -- the subsequent select is run, most likely if this run is on a table where
@@ -704,8 +704,8 @@ ij> -- The above delete and commit can a
 CALL WAIT_FOR_POST_COMMIT();
 0 rows inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
 ij> commit;
 ij> select * from a;
 A          |B          |C                                                                                                                               
@@ -723,9 +723,9 @@ ij> ------------------------------------
 get with hold cursor scan_cursor as
     'select a, b, c from a where a >= -5 for update';
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -733,31 +733,31 @@ A          |B          |C               
 ij> update a set a=3,b=30,c='three' where current of scan_cursor;
 1 row inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 -5         |-50        |-five                                                                                                                           
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
 ij> close scan_cursor;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
 ij> commit;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
 ij> commit;
 ij> select * from a;
 A          |B          |C                                                                                                                               
@@ -775,9 +775,9 @@ ij> ------------------------------------
 get with hold cursor scan_cursor as
     'select a, b, c from a where a >= -5 for update';
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -785,11 +785,11 @@ A          |B          |C               
 ij> update a set a=33,b=3030,c='threethree' where current of scan_cursor;
 1 row inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -797,19 +797,19 @@ A          |B          |C               
 ij> delete from a where current of scan_cursor;
 1 row inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,11)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,11)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
 ij> close scan_cursor;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,11)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,11)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |X   |A           |(1,9)     |GRANT|ACTIVE  
 ij> commit;
 ij> -- The above delete and commit can allow post commit processing to run before
 -- the subsequent select is run, most likely if this run is on a table where
@@ -821,8 +821,8 @@ ij> -- The above delete and commit can a
 CALL WAIT_FOR_POST_COMMIT();
 0 rows inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
 ij> commit;
 ij> -------------------------------------------------------------------------------
 -- At this point the table should look like:
@@ -919,87 +919,87 @@ ij> ------------------------------------
 get with hold cursor scan_cursor as
     'select a, b, c from a where a >= 1 and a < 20 for update of b, c';
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 2          |20         |two                                                                                                                             
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,8)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |30         |three                                                                                                                           
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 4          |40         |four                                                                                                                            
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,10)    |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,10)    |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 5          |50         |five                                                                                                                            
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 6          |60         |six                                                                                                                             
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,12)    |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,12)    |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 7          |70         |seven                                                                                                                           
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,13)    |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,13)    |GRANT|ACTIVE  
 ij> next scan_cursor;
 No current row
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> close scan_cursor;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> commit;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
 ij> commit;
 ij> --------------------------------------------------------------------------------
 -- Test full cursor scan which does no updates, which exits in middle of scan.
@@ -1007,54 +1007,54 @@ ij> ------------------------------------
 get with hold cursor scan_cursor as
     'select a, b, c from a where a >= 1 and a < 20 for update of b, c';
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 2          |20         |two                                                                                                                             
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,8)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |30         |three                                                                                                                           
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 4          |40         |four                                                                                                                            
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,10)    |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,10)    |GRANT|ACTIVE  
 ij> close scan_cursor;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> commit;
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
 ij> commit;
 ij> --------------------------------------------------------------------------------
 -- Test full cursor scan which deletes "even" rows.
@@ -1062,45 +1062,45 @@ ij> ------------------------------------
 get with hold cursor scan_cursor as
     'select a, b, c from a where a >= 1 and a < 20 for update of b, c';
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |10         |one                                                                                                                             
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 2          |20         |two                                                                                                                             
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,8)     |GRANT|ACTIVE  
 ij> delete from a where current of scan_cursor;
 1 row inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,8)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |2   |X   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,8)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |2   |X   |A           |(1,8)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |30         |three                                                                                                                           
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
-APP     |UserTran|ROW     |2   |X   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,9)     |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |2   |X   |A           |(1,8)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -1108,23 +1108,23 @@ A          |B          |C               
 ij> delete from a where current of scan_cursor;
 1 row inserted/updated/deleted
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |5   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,10)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |2   |X   |A           |(1,10)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |2   |X   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |5   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,10)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |2   |X   |A           |(1,10)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |2   |X   |A           |(1,8)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------
 5          |50         |five                                                                                                                            
 ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
-USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
----------------------------------------------------------------------------
-APP     |UserTran|TABLE   |5   |IX  |A           |Tablelock |GRANT|ACTIVE  
-APP     |UserTran|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |2   |X   |A           |(1,10)    |GRANT|ACTIVE  
-APP     |UserTran|ROW     |2   |X   |A           |(1,8)     |GRANT|ACTIVE  
+USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
+----------------------------------------------------------------------------------
+APP     |UserTransaction|TABLE   |5   |IX  |A           |Tablelock |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |1   |U   |A           |(1,11)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |2   |X   |A           |(1,10)    |GRANT|ACTIVE  
+APP     |UserTransaction|ROW     |2   |X   |A           |(1,8)     |GRANT|ACTIVE  
 ij> next scan_cursor;
 A          |B          |C                                                                                                                               

[... 17836 lines stripped ...]


Mime
View raw message