Subject IBO seems slower for some things compared with the BDE
Author Peter McLeod
> I have an application which I have just ported from the BDE to IBO. I then noticed that the application took longer to load compared with the same application using the BDE (48 seconds compared to 6 seconds).
>
> In order to quantify where the differences were, I then used Sleuth stopwatch to time the two programs. During this time I noticed that IBO seemed to be slow as it was retrieving information about the database (according to Codewatch the time differences coudld be attributable to the functions/procedures SchemaIndexDefinitions, SchemaDefaultedCols and SchemaProcedureInfo, SchemaPrimaryKeyInfo from IB_Schema.pas, and SysGetBlobData from IB_Session).
>
> On the whole examing the time taken for other processes was faster than using the BDE, it was the retrieval of the database information which slowed the whole thing down.
>
> Also I have attached the IBO monitor log to this e-mail which details the application running with IBO. Does anyone know why IBO needs to retrieve this information, or could it be in the porting I have a BDE setting which is causing things to slow down?
>
> Any assistance would be greatly appreciated.
>
> Regards
>
>
> Peter Mc Leod
>
>
> > <<Monitor Report.TXT>>
>
>
>
>

----------

/*---
CONNECT DATABASE SERVER3:D:\PCSTEST\PCS.GDB
DB_HANDLE = 14901564

SECONDS = 0.890
----*/
/*---
DATABASE INFO
DB_HANDLE = 14901564
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14900260

SECONDS = 0.062
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14900260
STMT_HANDLE = 14900308

select count(*) from pcsauditsystem where systemcode = ? /* syscode */

PLAN (PCSAUDITSYSTEM NATURAL)

FIELDS = [ Version 1 SQLd 1 SQLn 30
COUNT = <NIL> ]

SECONDS = 0.219
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14900260
STMT_HANDLE = 14900308
PARAMS = [ Version 1 SQLd 1 SQLn 1
[SYSCODE] = ' ' ]
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14894516
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14894516
STMT_HANDLE = 14894744

SELECT RDB$PROCEDURE_NAME
FROM RDB$PROCEDURES
ORDER BY RDB$PROCEDURE_NAME ASC

PLAN (RDB$PROCEDURES ORDER RDB$INDEX_21)

FIELDS = [ Version 1 SQLd 1 SQLn 30
RDB$PROCEDURES.RDB$PROCEDURE_NAME = <NIL> ]

SECONDS = 0.031
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14894516
STMT_HANDLE = 14894744
PARAMS = [ ]
----*/
/*---
COMMIT
TR_HANDLE = 14894516
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14894516

SECONDS = 0.015
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14894516
STMT_HANDLE = 14894744

SELECT S.RDB$FIELD_NAME
, I.RDB$RELATION_NAME
FROM RDB$RELATION_CONSTRAINTS C
, RDB$INDICES I
, RDB$INDEX_SEGMENTS S
WHERE C.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
AND C.RDB$RELATION_NAME = I.RDB$RELATION_NAME
AND C.RDB$INDEX_NAME = I.RDB$INDEX_NAME
AND I.RDB$INDEX_NAME = S.RDB$INDEX_NAME
ORDER BY I.RDB$RELATION_NAME ASC
, S.RDB$FIELD_POSITION ASC

PLAN SORT (JOIN (C NATURAL,I INDEX (RDB$INDEX_5,RDB$INDEX_31),S INDEX (RDB$INDEX_6)))

FIELDS = [ Version 1 SQLd 2 SQLn 30
RDB$INDEX_SEGMENTS.RDB$FIELD_NAME = <NIL>
RDB$INDICES.RDB$RELATION_NAME = <NIL> ]

SECONDS = 0.016
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14894516
STMT_HANDLE = 14894744
PARAMS = [ ]

SECONDS = 0.391
----*/
/*---
COMMIT
TR_HANDLE = 14894516

SECONDS = 0.016
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14900260
STMT_HANDLE = 14900308


select enabled
, PCSAUDITSYSTEM.RDB$DB_KEY
from pcsauditsystem where systemcode = ? /* syscode */

PLAN (PCSAUDITSYSTEM NATURAL)

FIELDS = [ Version 1 SQLd 2 SQLn 30
PCSAUDITSYSTEM.ENABLED = <NIL>
PCSAUDITSYSTEM.DB_KEY = <NIL> ]

SECONDS = 0.016
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14894516
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14894516
STMT_HANDLE = 14894744

SELECT R.RDB$FIELD_NAME
, R.RDB$RELATION_NAME
FROM RDB$RELATION_FIELDS R, RDB$FIELDS F
WHERE R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME
AND F.RDB$COMPUTED_SOURCE IS NOT NULL
AND NOT R.RDB$RELATION_NAME STARTING WITH 'RDB$'
ORDER BY 1 ASC

PLAN SORT (JOIN (R NATURAL,F INDEX (RDB$INDEX_2)))

FIELDS = [ Version 1 SQLd 2 SQLn 30
RDB$RELATION_FIELDS.RDB$FIELD_NAME = <NIL>
RDB$RELATION_FIELDS.RDB$RELATION_NAME = <NIL> ]

SECONDS = 0.015
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14894516
STMT_HANDLE = 14894744
PARAMS = [ ]

SECONDS = 0.328
----*/
/*---
COMMIT
TR_HANDLE = 14894516

SECONDS = 0.016
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14894516

SECONDS = 0.016
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14894516
STMT_HANDLE = 14894744

SELECT F.RDB$FIELD_NAME F_FieldName
, F.RDB$RELATION_NAME F_RelationName
, F.RDB$DEFAULT_SOURCE F_DefaultSource
, D.RDB$DEFAULT_SOURCE D_DefaultSource
, D.RDB$FIELD_TYPE D_FieldType
FROM RDB$RELATION_FIELDS F
INNER JOIN RDB$FIELDS D
ON D.RDB$FIELD_NAME = F.RDB$FIELD_SOURCE
WHERE (( F.RDB$DEFAULT_SOURCE IS NOT NULL ) OR ( D.RDB$DEFAULT_SOURCE IS NOT NULL ))
AND NOT F.RDB$RELATION_NAME STARTING WITH 'RDB$'
ORDER BY 1 ASC

PLAN SORT (JOIN (F NATURAL,D INDEX (RDB$INDEX_2)))

FIELDS = [ Version 1 SQLd 5 SQLn 30
RDB$RELATION_FIELDS.RDB$FIELD_NAME[F_FIELDNAME] = <NIL>
RDB$RELATION_FIELDS.RDB$RELATION_NAME[F_RELATIONNAME] = <NIL>
RDB$RELATION_FIELDS.RDB$DEFAULT_SOURCE[F_DEFAULTSOURCE] = <NIL>
RDB$FIELDS.RDB$DEFAULT_SOURCE[D_DEFAULTSOURCE] = <NIL>
RDB$FIELDS.RDB$FIELD_TYPE[D_FIELDTYPE] = <NIL> ]

SECONDS = 0.016
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14894516
STMT_HANDLE = 14894744
PARAMS = [ ]

SECONDS = 0.156
----*/
/*---
COMMIT
TR_HANDLE = 14894516
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14900260
STMT_HANDLE = 14900308
PARAMS = [ Version 1 SQLd 1 SQLn 1
[SYSCODE] = ' ' ]
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14894516
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14894516
STMT_HANDLE = 14900308

SELECT RDB$PARAMETER_NAME
FROM RDB$PROCEDURE_PARAMETERS
WHERE RDB$PARAMETER_TYPE = ? /* RDB$PARAMETER_TYPE */
AND RDB$PROCEDURE_NAME = ? /* RDB$PROCEDURE_NAME */
ORDER BY RDB$PARAMETER_NUMBER ASC

PLAN SORT ((RDB$PROCEDURE_PARAMETERS INDEX (RDB$INDEX_18)))

FIELDS = [ Version 1 SQLd 1 SQLn 30
RDB$PROCEDURE_PARAMETERS.RDB$PARAMETER_NAME = <NIL> ]

SECONDS = 0.015
----*/
/*---
COMMIT
TR_HANDLE = 14894516

SECONDS = 0.016
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14894516
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14894516
STMT_HANDLE = 14900308
PARAMS = [ Version 1 SQLd 2 SQLn 2
[RDB$PARAMETER_TYPE] = 0
[RDB$PROCEDURE_NAME] = 'PCSAUDITADDGROUP ' ]

SECONDS = 0.031
----*/
/*---
COMMIT
TR_HANDLE = 14894516
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14894516
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14894516
STMT_HANDLE = 14900308
PARAMS = [ Version 1 SQLd 2 SQLn 2
[RDB$PARAMETER_TYPE] = 1
[RDB$PROCEDURE_NAME] = 'PCSAUDITADDGROUP ' ]
----*/
/*---
COMMIT
TR_HANDLE = 14894516
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14900260
STMT_HANDLE = 14894744

EXECUTE PROCEDURE PCSAUDITADDGROUP
? /* SYSTEMCODE */ ,
? /* DESCRIPTION */ ,
? /* GROUPINDEX */ ,
? /* ENABLED */

FIELDS = [ Version 1 SQLd 1 SQLn 30
PCSAUDITADDGROUP.ENABLESTATE = <NIL> ]
----*/
/*---
EXECUTE2 DSQL
TR_HANDLE = 14900260
STMT_HANDLE = 14894744
PARAMS = [ Version 1 SQLd 4 SQLn 4
[SYSTEMCODE] = ''
[DESCRIPTION] = 'Functions (System wide)'
[GROUPINDEX] = 1
[ENABLED] = 'Y' ]
FIELDS = [ Version 1 SQLd 1 SQLn 1
PCSAUDITADDGROUP.ENABLESTATE = 'Y' ]

SECONDS = 0.094
----*/
/*---
COMMIT RETAINING
TR_HANDLE = 14900260
----*/
/*---
EXECUTE2 DSQL
TR_HANDLE = 14900260
STMT_HANDLE = 14894744
PARAMS = [ Version 1 SQLd 4 SQLn 4
[SYSTEMCODE] = ''
[DESCRIPTION] = 'Logins (System wide)'
[GROUPINDEX] = 2
[ENABLED] = 'Y' ]
FIELDS = [ Version 1 SQLd 1 SQLn 1
PCSAUDITADDGROUP.ENABLESTATE = 'Y' ]
----*/
/*---
COMMIT RETAINING
TR_HANDLE = 14900260
----*/
/*---
EXECUTE2 DSQL
TR_HANDLE = 14900260
STMT_HANDLE = 14894744
PARAMS = [ Version 1 SQLd 4 SQLn 4
[SYSTEMCODE] = ''
[DESCRIPTION] = 'Transactions (System wide)'
[GROUPINDEX] = 3
[ENABLED] = 'Y' ]
FIELDS = [ Version 1 SQLd 1 SQLn 1
PCSAUDITADDGROUP.ENABLESTATE = 'Y' ]

SECONDS = 0.016
----*/
/*---
COMMIT RETAINING
TR_HANDLE = 14900260
----*/
/*---
EXECUTE2 DSQL
TR_HANDLE = 14900260
STMT_HANDLE = 14894744
PARAMS = [ Version 1 SQLd 4 SQLn 4
[SYSTEMCODE] = ''
[DESCRIPTION] = 'Sessions (System wide)'
[GROUPINDEX] = 4
[ENABLED] = 'Y' ]
FIELDS = [ Version 1 SQLd 1 SQLn 1
PCSAUDITADDGROUP.ENABLESTATE = 'Y' ]
----*/
/*---
COMMIT RETAINING
TR_HANDLE = 14900260
----*/
/*---
EXECUTE2 DSQL
TR_HANDLE = 14900260
STMT_HANDLE = 14894744
PARAMS = [ Version 1 SQLd 4 SQLn 4
[SYSTEMCODE] = ''
[DESCRIPTION] = 'System Check (System wide)'
[GROUPINDEX] = 5
[ENABLED] = 'Y' ]
FIELDS = [ Version 1 SQLd 1 SQLn 1
PCSAUDITADDGROUP.ENABLESTATE = 'Y' ]
----*/
/*---
COMMIT RETAINING
TR_HANDLE = 14900260
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 29114416

SECONDS = 0.016
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 29114416
STMT_HANDLE = 14893536


select isEOYCopy
, PCSCLIENTCONST.RDB$DB_KEY
from pcsclientconst

PLAN (PCSCLIENTCONST NATURAL)

FIELDS = [ Version 1 SQLd 2 SQLn 30
PCSCLIENTCONST.ISEOYCOPY = <NIL>
PCSCLIENTCONST.DB_KEY[DB_KEY] = <NIL> ]

SECONDS = 0.046
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29114416
STMT_HANDLE = 14893536
PARAMS = [ ]
----*/
/*---
COMMIT
TR_HANDLE = 29114416
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 29114416

SECONDS = 0.015
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29114416
STMT_HANDLE = 14893536
PARAMS = [ ]
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 29114416
STMT_HANDLE = 29114104

select isEOYCopy
, PCSCLIENTCONST.RDB$DB_KEY
from pcsclientconst
WHERE PCSCLIENTCONST.RDB$DB_KEY=? /* BIND_0 */

PLAN (PCSCLIENTCONST INDEX ())

FIELDS = [ Version 1 SQLd 2 SQLn 2
PCSCLIENTCONST.ISEOYCOPY = <NULL>
PCSCLIENTCONST.DB_KEY[DB_KEY] = DB_KEY <n> $0000000000000000 ]
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 29114416
STMT_HANDLE = 29113672

SELECT PCSCLIENTCONST.RDB$DB_KEY
from pcsclientconst
WHERE PCSCLIENTCONST.RDB$DB_KEY=?

PLAN (PCSCLIENTCONST INDEX ())

FIELDS = [ Version 1 SQLd 1 SQLn 1
PCSCLIENTCONST.DB_KEY[DB_KEY] = DB_KEY $8D00000002000000 ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29114416
STMT_HANDLE = 29113672
PARAMS = [ Version 1 SQLd 1 SQLn 1
PCSCLIENTCONST.DB_KEY[DB_KEY] = DB_KEY $8D00000002000000 ]
----*/
/*---
ROLLBACK
TR_HANDLE = 29114416
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14893536

SECONDS = 0.015
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14893536
STMT_HANDLE = 29113672


select CurRelease
, PCSCLIENTCONST.RDB$DB_KEY
from pcsclientconst

PLAN (PCSCLIENTCONST NATURAL)

FIELDS = [ Version 1 SQLd 2 SQLn 30
PCSCLIENTCONST.CURRELEASE = <NIL>
PCSCLIENTCONST.DB_KEY[DB_KEY] = <NIL> ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14893536
STMT_HANDLE = 29113672
PARAMS = [ ]
----*/
/*---
COMMIT
TR_HANDLE = 14893536
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14893536

SECONDS = 0.015
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14893536
STMT_HANDLE = 29113672
PARAMS = [ ]
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14893536
STMT_HANDLE = 29114104

select CurRelease
, PCSCLIENTCONST.RDB$DB_KEY
from pcsclientconst
WHERE PCSCLIENTCONST.RDB$DB_KEY=? /* BIND_0 */

PLAN (PCSCLIENTCONST INDEX ())

FIELDS = [ Version 1 SQLd 2 SQLn 2
PCSCLIENTCONST.CURRELEASE = <NULL>
PCSCLIENTCONST.DB_KEY[DB_KEY] = DB_KEY <n> $0000000000000000 ]
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14893536
STMT_HANDLE = 29113968

SELECT PCSCLIENTCONST.RDB$DB_KEY
from pcsclientconst
WHERE PCSCLIENTCONST.RDB$DB_KEY=?

PLAN (PCSCLIENTCONST INDEX ())

FIELDS = [ Version 1 SQLd 1 SQLn 1
PCSCLIENTCONST.DB_KEY[DB_KEY] = DB_KEY $8D00000002000000 ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14893536
STMT_HANDLE = 29113968
PARAMS = [ Version 1 SQLd 1 SQLn 1
PCSCLIENTCONST.DB_KEY[DB_KEY] = DB_KEY $8D00000002000000 ]
----*/
/*---
ROLLBACK
TR_HANDLE = 14893536
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14893536

SECONDS = 0.016
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14893536
STMT_HANDLE = 29113968


Select Passwd
, PCSUSERS.RDB$DB_KEY
from PCSUsers
Where UserName=? /* UserName */

PLAN (PCSUSERS INDEX (RDB$PRIMARY8))

FIELDS = [ Version 1 SQLd 2 SQLn 30
PCSUSERS.PASSWD = <NIL>
PCSUSERS.DB_KEY[DB_KEY] = <NIL> ]

SECONDS = 0.015
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14893536
STMT_HANDLE = 29113968
PARAMS = [ Version 1 SQLd 1 SQLn 1
[USERNAME] = 'PCSDBA' ]
----*/
/*---
COMMIT
TR_HANDLE = 14893536
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14893536
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14893536
STMT_HANDLE = 29113968
PARAMS = [ Version 1 SQLd 1 SQLn 1
[USERNAME] = 'PCSDBA' ]
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14893536
STMT_HANDLE = 29114104

Select Passwd
, PCSUSERS.RDB$DB_KEY
from PCSUsers
WHERE PCSUSERS.RDB$DB_KEY=? /* BIND_0 */

PLAN (PCSUSERS INDEX ())

FIELDS = [ Version 1 SQLd 2 SQLn 2
PCSUSERS.PASSWD = <n> ''
PCSUSERS.DB_KEY[DB_KEY] = DB_KEY <n> $0000000000000000 ]

SECONDS = 0.016
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14893536
STMT_HANDLE = 29113828

SELECT PCSUSERS.RDB$DB_KEY
from PCSUsers
WHERE PCSUSERS.RDB$DB_KEY=?
AND UserName=? /* UserName */

PLAN (PCSUSERS INDEX (RDB$PRIMARY8))

FIELDS = [ Version 1 SQLd 1 SQLn 1
PCSUSERS.DB_KEY[DB_KEY] = DB_KEY $8700000001000000 ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14893536
STMT_HANDLE = 29113828
PARAMS = [ Version 1 SQLd 2 SQLn 2
PCSUSERS.DB_KEY[DB_KEY] = DB_KEY $8700000001000000
[USERNAME] = 'PCSDBA' ]
----*/
/*---
ROLLBACK
TR_HANDLE = 14893536

SECONDS = 0.016
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14893536
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14893536
STMT_HANDLE = 14900308
PARAMS = [ Version 1 SQLd 2 SQLn 2
[RDB$PARAMETER_TYPE] = 0
[RDB$PROCEDURE_NAME] = 'PCSAUDITADD ' ]
----*/
/*---
COMMIT
TR_HANDLE = 14893536
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14893536

SECONDS = 0.015
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14893536
STMT_HANDLE = 14900308
PARAMS = [ Version 1 SQLd 2 SQLn 2
[RDB$PARAMETER_TYPE] = 1
[RDB$PROCEDURE_NAME] = 'PCSAUDITADD ' ]
----*/
/*---
COMMIT
TR_HANDLE = 14893536

SECONDS = 0.016
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14900260
STMT_HANDLE = 29113828

EXECUTE PROCEDURE PCSAUDITADD
? /* SESSIONKY */ ,
? /* AUDITTIME */ ,
? /* SYSTEMCODE */ ,
? /* USERNAME */ ,
? /* COMPUTERNAME */ ,
? /* FUNCTIONTYPE */ ,
? /* FUNCTIONDESC */ ,
? /* DETAIL */

FIELDS = [ Version 1 SQLd 1 SQLn 30
PCSAUDITADD.KY = <NIL> ]
----*/
/*---
EXECUTE2 DSQL
TR_HANDLE = 14900260
STMT_HANDLE = 29113828
PARAMS = [ Version 1 SQLd 8 SQLn 8
[SESSIONKY] = -1
[AUDITTIME] = '26 Jun 2003 10:35:33 8900'
[SYSTEMCODE] = ''
[USERNAME] = 'PCSDBA'
[COMPUTERNAME] = 'CLIENTPETER'
[FUNCTIONTYPE] = 'Session: Start'
[FUNCTIONDESC] = ''
[DETAIL] = '' ]
FIELDS = [ Version 1 SQLd 1 SQLn 1
PCSAUDITADD.KY = 26507 ]

SECONDS = 0.266
----*/
/*---
COMMIT RETAINING
TR_HANDLE = 14900260

SECONDS = 0.031
----*/
/*---
EXECUTE2 DSQL
TR_HANDLE = 14900260
STMT_HANDLE = 29113828
PARAMS = [ Version 1 SQLd 8 SQLn 8
[SESSIONKY] = 26507
[AUDITTIME] = '26 Jun 2003 10:37:00 4210'
[SYSTEMCODE] = ''
[USERNAME] = 'PCSDBA'
[COMPUTERNAME] = 'CLIENTPETER'
[FUNCTIONTYPE] = 'Login: Accepted'
[FUNCTIONDESC] = ''
[DETAIL] = '' ]
FIELDS = [ Version 1 SQLd 1 SQLn 1
PCSAUDITADD.KY = 26507 ]

SECONDS = 0.016
----*/
/*---
COMMIT RETAINING
TR_HANDLE = 14900260

SECONDS = 0.031
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 29113640
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064

SELECT RDB$FIELD_NAME
FROM RDB$INDEX_SEGMENTS
WHERE RDB$INDEX_NAME = ? /* Name */
ORDER BY RDB$FIELD_POSITION ASC

PLAN SORT ((RDB$INDEX_SEGMENTS INDEX (RDB$INDEX_6)))

FIELDS = [ Version 1 SQLd 1 SQLn 30
RDB$INDEX_SEGMENTS.RDB$FIELD_NAME = <NIL> ]

SECONDS = 0.016
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29114468

SELECT I.RDB$RELATION_NAME
, I.RDB$INDEX_NAME
, I.RDB$UNIQUE_FLAG
, I.RDB$INDEX_TYPE
, I.RDB$FOREIGN_KEY
, ( SELECT C.RDB$CONSTRAINT_NAME
FROM RDB$RELATION_CONSTRAINTS C
WHERE C.RDB$INDEX_NAME = I.RDB$INDEX_NAME ) AS CNST
, ( SELECT R.RDB$UPDATE_RULE
FROM RDB$REF_CONSTRAINTS R
WHERE R.RDB$CONSTRAINT_NAME =
( SELECT C.RDB$CONSTRAINT_NAME
FROM RDB$RELATION_CONSTRAINTS C
WHERE C.RDB$INDEX_NAME = I.RDB$INDEX_NAME )) AS UR
, ( SELECT R.RDB$DELETE_RULE
FROM RDB$REF_CONSTRAINTS R
WHERE R.RDB$CONSTRAINT_NAME =
( SELECT C.RDB$CONSTRAINT_NAME
FROM RDB$RELATION_CONSTRAINTS C
WHERE C.RDB$INDEX_NAME = I.RDB$INDEX_NAME )) AS DR
FROM RDB$INDICES I
WHERE NOT I.RDB$RELATION_NAME STARTING WITH 'RDB$'

PLAN (C NATURAL)
PLAN (R INDEX (RDB$INDEX_13))
PLAN (C NATURAL)
PLAN (R INDEX (RDB$INDEX_13))
PLAN (C NATURAL)
PLAN (I NATURAL)

FIELDS = [ Version 1 SQLd 8 SQLn 30
RDB$INDICES.RDB$RELATION_NAME = <NIL>
RDB$INDICES.RDB$INDEX_NAME = <NIL>
RDB$INDICES.RDB$UNIQUE_FLAG[RDB$UNIQUE_FLAG] = <NIL>
RDB$INDICES.RDB$INDEX_TYPE[RDB$INDEX_TYPE] = <NIL>
RDB$INDICES.RDB$FOREIGN_KEY = <NIL>
[CNST] = <NIL>
[UR] = <NIL>
[DR] = <NIL> ]

SECONDS = 0.015
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29114468
PARAMS = [ ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY230 ' ]

SECONDS = 19.703
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN231 ' ]

SECONDS = 0.015
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY209 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN210 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY207 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY205 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY364 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN384 ' ]

SECONDS = 0.016
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY425 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN426 ' ]

SECONDS = 0.016
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY363 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN382 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY427 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY396 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN402 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY361 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY362 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY360 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY305 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY355 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN378 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY417 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PRTGRP ' ]

SECONDS = 0.016
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PRTDESC ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY416 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'CONV_JC ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'CONV_GL ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY423 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$424 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY359 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN380 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY357 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY395 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN406 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY394 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY356 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY354 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY358 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY426 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY418 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN419 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY415 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN417 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY393 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN405 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY410 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN411 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY392 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY353 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN373 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN376 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY343 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY298 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY232 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY201 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY203 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY424 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY422 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN423 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY421 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RMPRINTCOMPANY_1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY420 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY409 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY414 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN415 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY413 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY408 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY391 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY407 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY406 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY405 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY412 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY411 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY352 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'ANREPRINTHDR_IDX ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY351 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY349 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY350 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY348 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY404 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY403 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY389 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN398 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY347 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN370 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY341 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN342 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY308 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN310 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY307 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY398 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN399 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN400 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN401 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY387 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN388 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN390 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN392 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN393 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN394 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN395 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN396 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN397 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY383 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RMADDRPOSTALDELIVERYTYPE_1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY381 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RMADDRGEOCODERELIABILITY_1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY379 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RMADDRGEOCODEFEATURETYPE_1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY377 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RMADDRPROPERTYNAME_1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY375 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RMADDRCOUNTRY_1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY374 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RMADDRSTATE_1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY372 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RMADDRLOCALITY_1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY346 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN368 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN369 ' ]

SECONDS = 0.015
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RMADDRSTREETNAME_1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY345 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RMADDRSTREETSUFFIX_1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY344 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RMADDRSTREETTYPE_1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY342 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN343 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RMAUDIT_1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY340 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN341 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY339 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY338 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY317 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN318 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY314 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN421 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PCSTRANTYPE_MAIN ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PCSTRANTYPE_FUNCTIONNAME ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PCSTRANTYPE_SYSTEMTRANTYPE ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY313 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY306 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN420 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY316 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY419 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY304 ' ]

SECONDS = 0.015
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY204 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY390 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN391 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY388 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN389 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY386 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN387 ' ]

SECONDS = 0.016
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY384 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY382 ' ]

SECONDS = 0.016
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN383 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'ANTAGS_IDX ' ]

SECONDS = 0.015
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY373 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN374 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN375 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY380 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN381 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'ANCREDITGLSORT ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY378 ' ]

SECONDS = 0.016
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN379 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY376 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN377 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY371 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN372 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'ANBREED_IDX ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY385 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY369 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY368 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'OWNERNOIDX ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'TRANTYPEIDX ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY337 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY336 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN366 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY335 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN364 ' ]

SECONDS = 5.954
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN365 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY334 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN361 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN362 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN363 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY333 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$345 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY332 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY331 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$344 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN360 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY330 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$343 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY329 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$341 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$342 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN358 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN359 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY328 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY327 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$340 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN356 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN357 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY326 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN352 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN353 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN354 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN355 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY325 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN351 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY324 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY323 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN350 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY322 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY321 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY320 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$338 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY319 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN346 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN347 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN348 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN349 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY318 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY312 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN313 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY311 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'CMKEYWORD_IDX_KEYWORD ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY315 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN317 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY303 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN304 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN305 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN306 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN307 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN308 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'CMMST_IDX_DESC_KY ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'CMMST_IDX_FILEIDKY ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'CMMST_IDX_FOLIODATE ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY302 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY300 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'CMMEETING_IDX_MDATE ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY247 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'CMFILEID_IDX_FILEDESC ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'CMFILEID_IDX_FILEID ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY246 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'CMOFFICER_IDX_ONAME ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY216 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'CMCORRES_IDX_CNAME ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY245 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PCSFAX_IDX ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'GLBUDGETSMNTHTMP_GLACCOUNT ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'GLBALTMP_GLACCOUNT ' ]

SECONDS = 0.015
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY296 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'INVREPRINTGLSORT ' ]

SECONDS = 0.016
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY292 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY290 ' ]

SECONDS = 0.016
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY289 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'GLOLDTONEWMAP_OLDNEW ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'GLOLDTONEWMAP_NEWOLD ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY288 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY272 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'GLBM_MNTH ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'GLBM_GLACCOUNT ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY131 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY282 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY275 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN276 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY271 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN273 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RCTRNGL_1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RCTRNGL_2 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY279 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY261 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RCTRN_1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY277 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN278 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY259 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$FOREIGN260 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'DRINTERESTAUDIT_IDX ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY257 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY255 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY252 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'GLFUND_NAME ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY294 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 29113640
STMT_HANDLE = 29113064
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY293 ' ]
----*/
/*---
EXECUTE ST<br/><br/>(Message over 64 KB, truncated)