c230.dat

v
j
��������Pt
>��
J
'�K0P
�P��J�u



)
�0NUNNM�N�

M&$286cc01e-015a-84fb-0722-00000c404850	getUDTs&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
Bb`SELECT CAST (NULL AS VARCHAR(128)) AS TYPE_CAT, CASE WHEN (SCHEMANAME IS NULL) THEN CAST (NULL AS VARCHAR(128)) ELSE SCHEMANAME END AS TYPE_SCHEM, ALIAS AS TYPE_NAME, JAVACLASSNAME AS CLASS_NAME, 2000 AS DATA_TYPE, CAST (NULL AS VARCHAR(128)) AS REMARKS, CAST (NULL AS SMALLINT) AS BASE_TYPE FROM SYS.SYSALIASES, SYS.SYSSCHEMAS WHERE (ALIASTYPE='A') 	AND (SYS.SYSALIASES.SCHEMAID = SYS.SYSSCHEMAS.SCHEMAID) AND ((1=1) OR ? IS NOT NULL) AND ((1=1) OR ? IS NOT NULL) AND (SCHEMANAME LIKE ?) AND (ALIAS LIKE ?) AND (CAST (java.sql.Types::JAVA_OBJECT AS INTEGER) IN (?)) ORDER BY DATA_TYPE, TYPE_SCHEM, TYPE_NAME
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$6074401f-015a-84fb-0722-00000c404850getTablePrivileges&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
H��SELECT CAST ('' AS VARCHAR(128)) AS TABLE_CAT, S.SCHEMANAME AS TABLE_SCHEM, T.TABLENAME AS TABLE_NAME, CAST( P.GRANTOR AS VARCHAR(128)) AS GRANTOR, CAST( P.GRANTEE AS VARCHAR(128)) AS GRANTEE, X.PRIV AS PRIVILEGE, X.GRANTABLE AS IS_GRANTABLE FROM SYS.SYSTABLEPERMS P, SYS.SYSTABLES T, SYS.SYSSCHEMAS S, (VALUES (CAST('SELECT' AS VARCHAR(128)), CAST('YES'  AS VARCHAR(128))), (CAST('SELECT' AS VARCHAR(128)), CAST('NO'  AS VARCHAR(128))), (CAST('DELETE' AS VARCHAR(128)), CAST('NO'  AS VARCHAR(128))), (CAST('DELETE' AS VARCHAR(128)), CAST('YES'  AS VARCHAR(128))), (CAST('INSERT' AS VARCHAR(128)), CAST('NO'  AS VARCHAR(128))), (CAST('INSERT' AS VARCHAR(128)), CAST('YES'  AS VARCHAR(128))), (CAST('UPDATE' AS VARCHAR(128)), CAST('NO'  AS VARCHAR(128))), (CAST('UPDATE' AS VARCHAR(128)), CAST('YES'  AS VARCHAR(128))), (CAST('REFERENCES' AS VARCHAR(128)), CAST('NO'  AS VARCHAR(128))), (CAST('REFERENCES' AS VARCHAR(128)), CAST('YES'  AS VARCHAR(128))), (CAST('TRIGGER' AS VARCHAR(128)), CAST('NO'  AS VARCHAR(128))), (CAST('TRIGGER' AS VARCHAR(128)), CAST('YES'  AS VARCHAR(128)))) AS X(PRIV,GRANTABLE) WHERE P.TABLEID = T.TABLEID AND S.SCHEMAID = T.SCHEMAID AND ((1=1) OR ? IS NOT NULL) AND (S.SCHEMANAME LIKE ?)  AND (T.TABLENAME LIKE ?) AND ((P.SELECTPRIV = 'y' AND X.PRIV = 'SELECT' AND X.GRANTABLE = 'NO') OR (P.SELECTPRIV = 'Y' AND X.PRIV = 'SELECT' AND X.GRANTABLE = 'YES') OR (P.SELECTPRIV = 'y' AND X.PRIV = 'SELECT' AND X.GRANTABLE = 'NO') OR (P.DELETEPRIV = 'Y' AND X.PRIV = 'DELETE' AND X.GRANTABLE = 'YES') OR (P.DELETEPRIV = 'y' AND X.PRIV = 'DELETE' AND X.GRANTABLE = 'NO') OR (P.INSERTPRIV = 'Y' AND X.PRIV = 'INSERT' AND X.GRANTABLE = 'YES') OR (P.INSERTPRIV = 'y' AND X.PRIV = 'INSERT' AND X.GRANTABLE = 'NO') OR (P.UPDATEPRIV = 'Y' AND X.PRIV = 'UPDATE' AND X.GRANTABLE = 'YES') OR (P.UPDATEPRIV = 'y' AND X.PRIV = 'UPDATE' AND X.GRANTABLE = 'NO') OR (P.REFERENCESPRIV = 'Y' AND X.PRIV = 'REFERENCES' AND X.GRANTABLE = 'YES') OR (P.REFERENCESPRIV = 'y' AND X.PRIV = 'REFERENCES' AND X.GRANTABLE = 'NO') OR (P.TRIGGERPRIV = 'Y' AND X.PRIV = 'TRIGGER' AND X.GRANTABLE = 'YES') OR (P.TRIGGERPRIV = 'y' AND X.PRIV = 'TRIGGER' AND X.GRANTABLE = 'NO')) ORDER BY TABLE_SCHEM, TABLE_NAME, PRIVILEGE
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


d	Fk�</�Eopu


&$787c0020-015a-84fb-0722-00000c404850odbc_getIndexInfo&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
G��SELECT JDBC_SUBQUERY.TABLE_CAT AS TABLE_CAT, JDBC_SUBQUERY.TABLE_SCHEM AS TABLE_SCHEM, JDBC_SUBQUERY.TABLE_NAME AS TABLE_NAME, CAST ( ( CASE WHEN JDBC_SUBQUERY.NON_UNIQUE THEN 1 ELSE 0 END )  AS SMALLINT) AS NON_UNIQUE, JDBC_SUBQUERY.INDEX_QUALIFIER AS INDEX_QUALIFIER, JDBC_SUBQUERY.INDEX_NAME AS INDEX_NAME, CAST (JDBC_SUBQUERY.TYPE AS SMALLINT) AS TYPE, JDBC_SUBQUERY.ORDINAL_POSITION AS ORDINAL_POSITION, JDBC_SUBQUERY.COLUMN_NAME AS COLUMN_NAME, JDBC_SUBQUERY.ASC_OR_DESC AS ASC_OR_DESC, JDBC_SUBQUERY.CARDINALITY AS CARDINALITY, JDBC_SUBQUERY.PAGES AS PAGES, JDBC_SUBQUERY.FILTER_CONDITION AS FILTER_CONDITION FROM ( SELECT CAST ('' AS VARCHAR(128)) AS TABLE_CAT, S.SCHEMANAME AS TABLE_SCHEM, T.TABLENAME AS TABLE_NAME, (CASE WHEN CONGLOMS.DESCRIPTOR.isUnique() OR CONGLOMS.DESCRIPTOR.isUniqueDeferrable() THEN FALSE ELSE TRUE END) AS NON_UNIQUE, CAST ('' AS VARCHAR(128)) AS INDEX_QUALIFIER, CONGLOMS.CONGLOMERATENAME AS INDEX_NAME, java.sql.DatabaseMetaData::tableIndexOther AS TYPE, CAST (CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER) AS SMALLINT) AS ORDINAL_POSITION, COLS.COLUMNNAME AS COLUMN_NAME, CASE WHEN CONGLOMS.DESCRIPTOR.isAscending( CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER)) THEN 'A' ELSE 'D' END AS ASC_OR_DESC, CAST(NULL AS BIGINT) AS CARDINALITY, CAST(NULL AS BIGINT) AS PAGES, CAST(NULL AS VARCHAR(128)) AS FILTER_CONDITION FROM SYS.SYSSCHEMAS S, SYS.SYSTABLES T, SYS.SYSCONGLOMERATES CONGLOMS, SYS.SYSCOLUMNS COLS WHERE T.TABLEID = CONGLOMS.TABLEID AND T.TABLEID = COLS.REFERENCEID AND T.SCHEMAID = S.SCHEMAID AND CONGLOMS.ISINDEX AND (CASE WHEN CONGLOMS.DESCRIPTOR IS NOT NULL THEN CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER) ELSE 0 END) <> 0  AND ((1=1) OR ? IS NOT NULL) AND S.SCHEMANAME LIKE ? AND T.TABLENAME=? AND ( CASE WHEN ? THEN (CONGLOMS.DESCRIPTOR.isUnique() OR CONGLOMS.DESCRIPTOR.isUniqueDeferrable()) ELSE (1=1) END) AND ((1=1) OR ?<>0) ) JDBC_SUBQUERY ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


<q��lPu

&$80840021-015a-84fb-0722-00000c404850odbc_getColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S

&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$888c4022-015a-84fb-0722-00000c404850&$getBestRowIdentifierUniqueKeyColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
ExvSELECT CAST (java.sql.DatabaseMetaData::bestRowSession AS SMALLINT) AS SCOPE, COLS.COLUMNNAME AS COLUMN_NAME, COLS.COLUMNDATATYPE.getJDBCTypeId() AS DATA_TYPE, CAST (COLS.COLUMNDATATYPE.getTypeName() AS VARCHAR(128)) AS TYPE_NAME, COLS.COLUMNDATATYPE.getMaximumWidth() AS COLUMN_SIZE, CAST (NULL AS INT) AS BUFFER_LENGTH, CAST ((CASE WHEN (COLS.COLUMNDATATYPE.getJDBCTypeId() IN ( java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN COLS.COLUMNDATATYPE.getPrecision() ELSE CAST (NULL AS SMALLINT) END) AS SMALLINT) AS DECIMAL_DIGITS, CAST (java.sql.DatabaseMetaData::bestRowNotPseudo AS SMALLINT) AS PSEUDO_COLUMN FROM SYS.SYSSCHEMAS SCHEMAS, SYS.SYSTABLES TABS, SYS.SYSCONSTRAINTS cons, SYS.SYSKEYS keys, SYS.SYSCONGLOMERATES CONGLOMS, SYS.SYSCOLUMNS COLS WHERE TABS.TABLEID = conS.TABLEID AND TABS.TABLEID = COLS.REFERENCEID AND SCHEMAS.SCHEMAID = TABS.SCHEMAID AND conS.CONSTRAINTID = ? AND KEYS.CONSTRAINTID = ? AND conS.CONSTRAINTID = KEYS.CONSTRAINTID AND TABS.TABLEID = CONGLOMS.TABLEID AND KEYS.CONGLOMERATEID = CONGLOMS.CONGLOMERATEID AND (CASE WHEN CONGLOMS.DESCRIPTOR IS NOT NULL THEN CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER) ELSE 0 END) > 0 AND (?<>0 or not COLS.COLUMNDATATYPE.isNullable() )
&$8000000d-00d0-fd77-3ed8-000a0a0b1900



&$e8afc026-015a-84fb-0722-00000c404850getProcedureColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
EqoSELECT CAST (NULL AS VARCHAR(128)) AS PROCEDURE_CAT, SCHEMANAME AS PROCEDURE_SCHEM, A.ALIAS AS PROCEDURE_NAME, V."COLUMN_NAME" AS COLUMN_NAME, V."COLUMN_TYPE" AS COLUMN_TYPE, V."DATA_TYPE" AS DATA_TYPE, V."TYPE_NAME" AS TYPE_NAME, V."PRECISION" AS PRECISION, V."LENGTH" AS LENGTH, CASE WHEN (V."DATA_TYPE" IN (java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN V."SCALE" ELSE CAST (NULL AS SMALLINT) END AS SCALE, CASE WHEN (V."DATA_TYPE" IN (java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DOUBLE, java.sql.Types::FLOAT, java.sql.Types::REAL, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN V."RADIX" ELSE CAST (NULL AS SMALLINT) END AS RADIX, V."NULLABLE" AS NULLABLE, V."REMARKS" AS REMARKS, V."METHOD_ID" AS METHOD_ID, V."PARAMETER_ID" AS PARAMETER_ID FROM SYS.SYSALIASES A, SYS.SYSSCHEMAS, NEW org.apache.derby.catalog.GetProcedureColumns(A.ALIASINFO, A.ALIASTYPE) V WHERE ALIASTYPE = 'P' AND SCHEMANAME LIKE ? AND A.SCHEMAID = SYS.SYSSCHEMAS.SCHEMAID AND A.ALIAS LIKE ? AND V."COLUMN_NAME" LIKE ? ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME, METHOD_ID, PARAMETER_ID
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$c99d403a-015a-84fb-0722-00000c404850getBestRowIdentifierEmpty&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
A�
�SELECT SCOPE, COLUMN_NAME, DATA_TYPE, TYPE_NAME, COLUMN_SIZE, BUFFER_LENGTH, DECIMAL_DIGITS, PSEUDO_COLUMN FROM (VALUES (CAST (2  AS SMALLINT), CAST ('' AS VARCHAR(128)), 0, CAST ('INT' AS VARCHAR(128)), 0, 0,	CAST (0 AS SMALLINT), CAST (0 AS SMALLINT)) ) AS BESTROWIDENTIFIER( SCOPE, COLUMN_NAME, DATA_TYPE, TYPE_NAME, COLUMN_SIZE, BUFFER_LENGTH, DECIMAL_DIGITS, PSEUDO_COLUMN) WHERE (1=0)
&$8000000d-00d0-fd77-3ed8-000a0a0b1900



1
�,<�V��u



O��SELECT JDBC_SUBQUERY.TABLE_CAT AS TABLE_CAT, JDBC_SUBQUERY.TABLE_SCHEM AS TABLE_SCHEM, JDBC_SUBQUERY.TABLE_NAME AS TABLE_NAME, JDBC_SUBQUERY.COLUMN_NAME AS COLUMN_NAME, CAST (JDBC_SUBQUERY.DATA_TYPE AS SMALLINT) AS DATA_TYPE, JDBC_SUBQUERY.TYPE_NAME AS TYPE_NAME, JDBC_SUBQUERY.COLUMN_SIZE AS COLUMN_SIZE, JDBC_SUBQUERY.COL_MAX_WIDTH_IN_BYTES AS BUFFER_LENGTH, CAST (CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::DATE)) THEN CAST (NULL AS SMALLINT) ELSE JDBC_SUBQUERY.DECIMAL_DIGITS END AS SMALLINT) AS DECIMAL_DIGITS, CAST (CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN CAST (2 AS SMALLINT) ELSE JDBC_SUBQUERY.NUM_PREC_RADIX END AS SMALLINT) AS NUM_PREC_RADIX, CAST (JDBC_SUBQUERY.NULLABLE AS SMALLINT) AS NULLABLE, JDBC_SUBQUERY.REMARKS AS REMARKS, JDBC_SUBQUERY.COLUMN_DEF AS COLUMN_DEF, CAST (CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN 9 ELSE JDBC_SUBQUERY.DATA_TYPE END AS SMALLINT) AS SQL_DATA_TYPE, CAST (CASE WHEN (JDBC_SUBQUERY.DATA_TYPE = java.sql.Types::DATE) THEN 1 ELSE (CASE WHEN (JDBC_SUBQUERY.DATA_TYPE = java.sql.Types::TIME) THEN 2 ELSE (CASE WHEN (JDBC_SUBQUERY.DATA_TYPE = java.sql.Types::TIMESTAMP) THEN 3 ELSE CAST (NULL AS SMALLINT) END ) END ) END AS SMALLINT) AS SQL_DATETIME_SUB, CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::CHAR, java.sql.Types::VARCHAR, java.sql.Types::BINARY, java.sql.Types::VARBINARY)) THEN JDBC_SUBQUERY.COL_MAX_WIDTH_IN_BYTES ELSE CAST(NULL AS INT) END AS CHAR_OCTET_LENGTH, JDBC_SUBQUERY.ORDINAL_POSITION AS ORDINAL_POSITION, JDBC_SUBQUERY.IS_NULLABLE AS IS_NULLABLE, JDBC_SUBQUERY.SCOPE_CATALOG AS SCOPE_CATALOG, JDBC_SUBQUERY.SCOPE_SCHEMA AS SCOPE_SCHEMA, JDBC_SUBQUERY.SCOPE_TABLE AS SCOPE_TABLE, JDBC_SUBQUERY.SOURCE_DATA_TYPE AS SOURCE_DATA_TYPE, JDBC_SUBQUERY.IS_AUTOINCREMENT AS IS_AUTOINCREMENT, JDBC_SUBQUERY.IS_GENERATEDCOLUMN AS IS_GENERATEDCOLUMN, JDBC_SUBQUERY.SCOPE_CATLOG AS SCOPE_CATLOG FROM ( SELECT CAST ('' AS VARCHAR(128)) AS TABLE_CAT, S.SCHEMANAME AS TABLE_SCHEM, T.TABLENAME AS TABLE_NAME, C.COLUMNNAME AS COLUMN_NAME, C.COLUMNDATATYPE.getJDBCTypeId() AS DATA_TYPE, (CAST (C.COLUMNDATATYPE.getTypeName() AS VARCHAR(128))) AS TYPE_NAME, CASE WHEN (C.COLUMNDATATYPE.getJDBCTypeId() IN (java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::REAL, java.sql.Types::DOUBLE,java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::FLOAT)) THEN C.COLUMNDATATYPE.getPrecision() ELSE C.COLUMNDATATYPE.getMaximumWidth() END AS COLUMN_SIZE, CAST( NULL AS INT) AS BUFFER_LENGTH, CASE WHEN (C.COLUMNDATATYPE.getJDBCTypeId() IN (java.sql.Types::DECIMAL, 				java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN C.COLUMNDATATYPE.getScale() ELSE CAST(NULL AS INT) END AS DECIMAL_DIGITS, 											CASE WHEN (C.COLUMNDATATYPE.getJDBCTypeId() IN (java.sql.Types::REAL, 					java.sql.Types::DOUBLE, java.sql.Types::FLOAT)) THEN 2 ELSE (CASE WHEN (C.COLUMNDATATYPE.getJDBCTypeId() IN ( java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN 10 ELSE CAST (NULL AS INTEGER) END) END AS NUM_PREC_RADIX, 											CASE WHEN C.COLUMNDATATYPE.isNullable() THEN java.sql.DatabaseMetaData::columnNullable ELSE java.sql.DatabaseMetaData::columnNoNulls END AS NULLABLE, CAST ('' AS VARCHAR(128)) AS REMARKS, CASE WHEN (COLUMNDEFAULT IS NULL) THEN  (CASE WHEN (AUTOINCREMENTINC is NULL) THEN  CAST (NULL AS VARCHAR(254)) ELSE 'AUTOINCREMENT: start ' || -- The AUTOINCREMENT* columns have incorrect meta-data 
 -- if the database was created with an old version of  
 -- Derby (see DERBY-1745 and DERBY-<��"�Bu




F�5274), and the CHAR 
 -- function won't work. Wrap them in a BIGINT function 
 -- call to fix the meta-data, even though the columns  
 -- already are of type BIGINT.                         
 RTRIM(CHAR(BIGINT(AUTOINCREMENTSTART))) || ' increment ' || RTRIM(CHAR(BIGINT(AUTOINCREMENTINC))) END ) ELSE CAST (COLUMNDEFAULT AS VARCHAR(254)) END AS COLUMN_DEF, CAST( NULL AS INT) AS SQL_DATA_TYPE, CAST( NULL AS INT) AS SQL_DATETIME_SUB, CASE WHEN (C.COLUMNDATATYPE.getJDBCTypeId() IN (java.sql.Types::CHAR,	 				java.sql.Types::VARCHAR)) THEN (CASE WHEN (C.COLUMNDATATYPE.getMaximumWidth() * 2.0 > 2147483647) THEN 2147483647 ELSE (C.COLUMNDATATYPE.getMaximumWidth() * 2) END) ELSE CAST(NULL AS INT) END AS CHAR_OCTET_LENGTH,										C.COLUMNNUMBER AS ORDINAL_POSITION, CAST ((CASE WHEN C.COLUMNDATATYPE.isNullable() THEN 'YES' ELSE 'NO' END) AS VARCHAR(128)) AS IS_NULLABLE, CAST (NULL AS VARCHAR(128)) AS SCOPE_CATALOG, CAST (NULL AS VARCHAR(128)) AS SCOPE_SCHEMA, CAST (NULL AS VARCHAR(128)) AS SCOPE_TABLE, CAST (NULL AS SMALLINT) AS SOURCE_DATA_TYPE, CAST ((CASE WHEN (AUTOINCREMENTINC is not NULL) THEN 'YES' ELSE 'NO' END) AS VARCHAR(128)) AS IS_AUTOINCREMENT, CAST ((CASE WHEN (C.COLUMNDEFAULT IS NOT NULL AND C.COLUMNDEFAULT.toString().startsWith( 'GENERATED ALWAYS AS' ) ) THEN 'YES' ELSE  'NO' END) AS VARCHAR(128)) AS IS_GENERATEDCOLUMN, 										CAST (NULL AS VARCHAR(128)) AS SCOPE_CATLOG, C.COLUMNDATATYPE.getMaximumWidthInBytes() AS COL_MAX_WIDTH_IN_BYTES FROM SYS.SYSSCHEMAS S, SYS.SYSTABLES T, SYS.SYSCOLUMNS C WHERE C.REFERENCEID = T.TABLEID AND S.SCHEMAID = T.SCHEMAID AND ((1=1) OR ? IS NOT NULL) AND (S.SCHEMANAME LIKE ?) AND (T.TABLENAME LIKE ?) AND (C.COLUMNNAME LIKE ?) ) JDBC_SUBQUERY ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION<�3��u


&$a094c023-015a-84fb-0722-00000c404850odbc_getTypeInfo&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S

&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$d89d8024-015a-84fb-0722-00000c404850%#odbc_getBestRowIdentifierAllColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
FywSELECT JDBC_SUBQUERY.SCOPE AS SCOPE, JDBC_SUBQUERY.COLUMN_NAME AS COLUMN_NAME, CAST (JDBC_SUBQUERY.DATA_TYPE AS SMALLINT) AS DATA_TYPE, JDBC_SUBQUERY.TYPE_NAME AS TYPE_NAME, JDBC_SUBQUERY.COLUMN_SIZE AS COLUMN_SIZE, JDBC_SUBQUERY.COL_MAX_WIDTH_IN_BYTES AS BUFFER_LENGTH, CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::DATE)) THEN CAST (NULL AS SMALLINT) ELSE JDBC_SUBQUERY.DECIMAL_DIGITS END AS DECIMAL_DIGITS, JDBC_SUBQUERY.PSEUDO_COLUMN AS PSEUDO_COLUMN FROM ( SELECT CAST (java.sql.DatabaseMetaData::bestRowSession AS SMALLINT) AS SCOPE, COLS.COLUMNNAME AS COLUMN_NAME, COLS.COLUMNDATATYPE.getJDBCTypeId() AS DATA_TYPE, CAST (COLS.COLUMNDATATYPE.getTypeName() AS VARCHAR(128)) AS TYPE_NAME, COLS.COLUMNDATATYPE.getMaximumWidth() AS COLUMN_SIZE, CAST (NULL AS INT) AS BUFFER_LENGTH, CAST ((CASE WHEN (COLS.COLUMNDATATYPE.getJDBCTypeId() IN ( java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN COLS.COLUMNDATATYPE.getPrecision() ELSE CAST (NULL AS SMALLINT) END) AS SMALLINT) AS DECIMAL_DIGITS, CAST (java.sql.DatabaseMetaData::bestRowNotPseudo AS SMALLINT) AS PSEUDO_COLUMN, COLS.COLUMNDATATYPE.getMaximumWidthInBytes() AS COL_MAX_WIDTH_IN_BYTES FROM SYS.SYSSCHEMAS SCHEMAS, SYS.SYSTABLES TABS,  SYS.SYSCOLUMNS COLS  WHERE COLS.REFERENCEID = TABS.TABLEID  AND TABS.SCHEMAID = SCHEMAS.SCHEMAID  AND ((1=1) OR ? IS NOT NULL)  AND (SCHEMAS.SCHEMANAME LIKE ?)  AND (TABS.TABLENAME=?) AND ? BETWEEN 0 AND 2  AND (?<>0 OR NOT COLS.COLUMNDATATYPE.isNullable()) ) JDBC_SUBQUERY
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$40a68025-015a-84fb-0722-00000c404850getProcedures40&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
B��SELECT CAST ('' AS VARCHAR(128)) AS PROCEDURE_CAT, SCHEMANAME AS PROCEDURE_SCHEM, ALIAS AS PROCEDURE_NAME, CAST (NULL AS INT) AS RESERVED1, CAST (NULL AS INT) AS RESERVED2, CAST (NULL AS INT) AS RESERVED3, CAST ((JAVACLASSNAME||'.'|| ALIASINFO->getMethodName()) AS VARCHAR(32672)) AS REMARKS, CAST (java.sql.DatabaseMetaData::procedureNoResult AS SMALLINT) AS PROCEDURE_TYPE, SPECIFICNAME AS SPECIFIC_NAME FROM SYS.SYSALIASES, SYS.SYSSCHEMAS WHERE ((1=1) OR ? IS NOT NULL) AND (ALIASTYPE = 'P' AND SCHEMANAME LIKE ?) AND SYS.SYSALIASES.SCHEMAID = SYS.SYSSCHEMAS.SCHEMAID AND ALIAS LIKE ? ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME, SPECIFIC_NAME
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


$�,<����u



O�USELECT JDBC_SUBQUERY.TYPE_NAME AS TYPE_NAME, CAST (JDBC_SUBQUERY.DATA_TYPE AS SMALLINT) AS DATA_TYPE, JDBC_SUBQUERY.COLUMN_SIZE AS COLUMN_SIZE, JDBC_SUBQUERY.LITERAL_PREFIX AS LITERAL_PREFIX, JDBC_SUBQUERY.LITERAL_SUFFIX AS LITERAL_SUFFIX, JDBC_SUBQUERY.CREATE_PARAMS AS CREATE_PARAMS, JDBC_SUBQUERY.NULLABLE AS NULLABLE, CAST ( ( CASE WHEN JDBC_SUBQUERY.CASE_SENSITIVE THEN 1 ELSE 0 END )  AS SMALLINT) AS CASE_SENSITIVE, JDBC_SUBQUERY.SEARCHABLE AS SEARCHABLE, CAST ( ( CASE WHEN CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DOUBLE, java.sql.Types::FLOAT, java.sql.Types::REAL, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN JDBC_SUBQUERY.UNSIGNED_ATTRIBUTE ELSE NULL END IS NULL THEN CAST( NULL AS INTEGER ) WHEN JDBC_SUBQUERY.UNSIGNED_ATTRIBUTE THEN 1 ELSE 0 END )  AS SMALLINT) AS UNSIGNED_ATTRIBUTE, CAST ( ( CASE WHEN JDBC_SUBQUERY.FIXED_PREC_SCALE THEN 1 ELSE 0 END )  AS SMALLINT) AS FIXED_PREC_SCALE, CAST ( ( CASE WHEN CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DOUBLE, java.sql.Types::FLOAT, java.sql.Types::REAL, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN JDBC_SUBQUERY.AUTO_UNIQUE_VAL ELSE NULL END IS NULL THEN CAST( NULL AS INTEGER ) WHEN JDBC_SUBQUERY.AUTO_UNIQUE_VAL THEN 1 ELSE 0 END )  AS SMALLINT) AS AUTO_UNIQUE_VAL, JDBC_SUBQUERY.LOCAL_TYPE_NAME AS LOCAL_TYPE_NAME, JDBC_SUBQUERY.MINIMUM_SCALE AS MINIMUM_SCALE, JDBC_SUBQUERY.MAXIMUM_SCALE AS MAXIMUM_SCALE, CAST (CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN 9 ELSE JDBC_SUBQUERY.DATA_TYPE END AS SMALLINT) AS SQL_DATA_TYPE, CAST (CASE WHEN (JDBC_SUBQUERY.DATA_TYPE = java.sql.Types::DATE) THEN 1 ELSE (CASE WHEN (JDBC_SUBQUERY.DATA_TYPE = java.sql.Types::TIME) THEN 2 ELSE (CASE WHEN (JDBC_SUBQUERY.DATA_TYPE = java.sql.Types::TIMESTAMP) THEN 3 ELSE CAST (NULL AS SMALLINT) END ) END ) END AS SMALLINT) AS SQL_DATETIME_SUB, CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN CAST (2 AS SMALLINT) ELSE JDBC_SUBQUERY.NUM_PREC_RADIX END AS NUM_PREC_RADIX, CAST (NULL AS SMALLINT) AS INTERVAL_PRECISION FROM ( SELECT CAST (RTRIM(CAST (T1 AS CHAR(128))) AS VARCHAR(128)) AS TYPE_NAME, T2 AS DATA_TYPE, T3 AS COLUMN_SIZE, CAST (RTRIM(CAST(T4 AS CHAR(10))) AS VARCHAR(10)) AS LITERAL_PREFIX, CAST (RTRIM(T5) AS VARCHAR(10)) AS LITERAL_SUFFIX, CAST (RTRIM(CAST(T6 AS CHAR(20))) AS VARCHAR(20)) AS CREATE_PARAMS, CAST (T7 AS SMALLINT) AS NULLABLE, T8 AS CASE_SENSITIVE, CAST (T9 AS SMALLINT) AS SEARCHABLE, T10 AS UNSIGNED_ATTRIBUTE, T11 AS FIXED_PREC_SCALE, T12 AS AUTO_UNIQUE_VAL, CAST (RTRIM(CAST(T1 AS CHAR(128))) AS VARCHAR(128)) AS LOCAL_TYPE_NAME, CAST (T14 AS SMALLINT) AS MINIMUM_SCALE, CAST (T15 AS SMALLINT) AS MAXIMUM_SCALE, CAST (NULL AS INT) AS SQL_DATA_TYPE, CAST (NULL AS INT) AS SQL_DATETIME_SUB, T18 AS NUM_PREC_RADIX FROM ( VALUES ('BIGINT',-5,19,CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,FALSE,2,FALSE,FALSE,TRUE,0,0,10),('LONG VARCHAR FOR BIT DATA',-4,32700,'X''','''',CAST (NULL AS CHAR), 1,FALSE,0,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER), CAST (NULL AS INTEGER)), ('VARCHAR () FOR BIT DATA',-3,32672,'X''','''','length', 1,FALSE,2,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER), CAST (NULL AS INTEGER)), ('CHAR () FOR BIT DATA',-2,254,'X''','''','length', 1,FALSE,2,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER), CAST (NULL AS INTEGER)), ('LONG VARCHAR',-1,32700,'''','''',CAST (NULL AS CHAR), 1,TRUE,1,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER), CAST (NULL AS INTEGER)), ('CHAR',1,254,'''',''<�]�
�u




I�'','length', 1,TRUE,3,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER), CAST (NULL AS INTEGER)), ('NUMERIC',2,31,CAST (NULL AS CHAR),CAST (NULL AS CHAR),'precision,scale', 1,FALSE,2,FALSE,TRUE,FALSE,0,31,10),('DECIMAL',3,31,CAST (NULL AS CHAR),CAST (NULL AS CHAR),'precision,scale', 1,FALSE,2,FALSE,TRUE,FALSE,0,31,10),('INTEGER',4,10,CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,FALSE,2,FALSE,FALSE,TRUE,0,0,10),('SMALLINT',5,5,CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,FALSE,2,FALSE,FALSE,TRUE,0,0,10),('FLOAT',6,52,CAST (NULL AS CHAR),CAST (NULL AS CHAR),'precision', 1,FALSE,2,FALSE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),2),('REAL',7,23,CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,FALSE,2,FALSE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),2),('DOUBLE',8,52,CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,FALSE,2,FALSE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),2),('VARCHAR',12,32672,'''','''','length', 1,TRUE,3,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER), CAST (NULL AS INTEGER)), ('BOOLEAN',16,1,CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,FALSE,2,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),CAST (NULL AS INTEGER)),('DATE',91,10,'DATE''','''',CAST (NULL AS CHAR), 1,FALSE,2,TRUE,FALSE,FALSE,0,0,10),('TIME',92,8,'TIME''','''',CAST (NULL AS CHAR), 1,FALSE,2,TRUE,FALSE,FALSE,0,0,10),('TIMESTAMP',93,29,'TIMESTAMP''','''',CAST (NULL AS CHAR), 1,FALSE,2,TRUE,FALSE,FALSE,0,9,10),('OBJECT',2000,CAST (NULL AS INTEGER),CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,FALSE,2,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),CAST (NULL AS INTEGER)),('BLOB',2004,2147483647,CAST (NULL AS CHAR),CAST (NULL AS CHAR),'length', 1,FALSE,0,CAST (NULL AS BOOLEAN),FALSE,CAST (NULL AS BOOLEAN), CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),CAST (NULL AS INTEGER)),('CLOB',2005,2147483647,'''','''','length', 1,TRUE,1,CAST (NULL AS BOOLEAN),FALSE,CAST (NULL AS BOOLEAN), CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),CAST (NULL AS INTEGER)), ('XML',2009,CAST (NULL AS INTEGER),CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,TRUE,0,FALSE,FALSE,FALSE, CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),CAST (NULL AS INTEGER)) ) AS TYPEINFO(T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T14,T15,T18) WHERE (T1 <> 'BOOLEAN' OR CAST(? AS SMALLINT) <> 0) ) JDBC_SUBQUERY<	���u


&$e0b94027-015a-84fb-0722-00000c404850&$getBestRowIdentifierUniqueConstraint&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
CsqSELECT CONS.CONSTRAINTID, IDX.DESCRIPTOR.numberOfOrderedColumns() AS NUMCOLS, java.util.Arrays::toString(IDX.DESCRIPTOR.baseColumnPositions()) AS LOOKS FROM SYS.SYSSCHEMAS SCHEMAS, SYS.SYSTABLES TABS, SYS.SYSCONSTRAINTS cons, SYS.SYSKEYS keys, SYS.SYSCONGLOMERATES IDX WHERE TABS.TABLEID = conS.TABLEID AND SCHEMAS.SCHEMAID = TABS.SCHEMAID AND conS.CONSTRAINTID = KEYS.CONSTRAINTID AND IDX.DESCRIPTOR IS NOT NULL AND KEYS.CONGLOMERATEID = IDX.CONGLOMERATEID AND IDX.ISCONSTRAINT AND conS.type = 'U' AND ((1=1) OR ? IS NOT NULL) AND (SCHEMAS.SCHEMANAME LIKE ?) AND (TABS.TABLENAME=?) ORDER BY NUMCOLS, LOOKS /* LOOKS: Sort based on string of base colums       */ /* of the index, so the query is now fully ordered. */ /* DERBY-6623. Stable as long as row is unchanged   */ /* and no indexes are added or deleted. Not always  */ /* intuitive though [1,11]: sorts before [1,2].     */
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$38c30028-015a-84fb-0722-00000c404850getColumnPrivileges_10_1&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
BSELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, GRANTOR, GRANTEE, PRIVILEGE, IS_GRANTABLE FROM ( VALUES (CAST ('' AS VARCHAR(128)), CAST ('' AS VARCHAR(128)), CAST ('' AS VARCHAR(128)), CAST ('' AS VARCHAR(128)), CAST ('' AS VARCHAR(128)), CAST ('' AS VARCHAR(128)), CAST ('' AS VARCHAR(128)), CAST ('' AS VARCHAR(128))) ) AS COLUMNPRIVILEGES ( TABLE_CAT, TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, GRANTOR, GRANTEE, PRIVILEGE, IS_GRANTABLE ) WHERE (1=0) AND (((1=1) OR ? IS NOT NULL) OR ''=? OR ''=? OR ''=?)
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


	&$21abc03b-015a-84fb-0722-00000c404850 getBestRowIdentifierPrimaryKey&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
AP
NSELECT conS.CONSTRAINTID 	FROM SYS.SYSSCHEMAS SCHEMAS, SYS.SYSTABLES TABS, SYS.SYSCONSTRAINTS cons, SYS.SYSKEYS keys WHERE TABS.TABLEID = conS.TABLEID AND SCHEMAS.SCHEMAID = TABS.SCHEMAID AND conS.CONSTRAINTID = KEYS.CONSTRAINTID AND conS.type = 'P' AND ((1=1) OR ? IS NOT NULL) AND (SCHEMAS.SCHEMANAME LIKE ?)  AND (TABS.TABLENAME=?)
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$c1c9803d-015a-84fb-0722-00000c404850getColumnPrivileges&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
D��SELECT CAST ('' AS VARCHAR(128)) AS TABLE_CAT, S.SCHEMANAME AS TABLE_SCHEM, T.TABLENAME AS TABLE_NAME, C.COLUMNNAME AS COLUMN_NAME, CAST( P.GRANTOR AS VARCHAR(128)) AS GRANTOR, CAST( P.GRANTEE AS VARCHAR(128)) AS GRANTEE, CASE WHEN (P.TYPE = 's' OR P.TYPE = 'S') THEN CAST( 'SELECT' AS VARCHAR(128)) ELSE CASE WHEN (P.TYPE = 'd' OR P.TYPE = 'D') THEN CAST( 'DELETE' AS VARCHAR(128)) ELSE CASE WHEN (P.TYPE = 'i' OR P.TYPE = 'I') THEN CAST( 'INSERT' AS VARCHAR(128)) ELSE CASE WHEN (P.TYPE = 'u' OR P.TYPE = 'U') THEN CAST( 'UPDATE' AS VARCHAR(128)) ELSE CASE WHEN (P.TYPE = 'r' OR P.TYPE = 'R') THEN CAST( 'REFERENCES' AS VARCHAR(128)) ELSE CAST( 'TRIGGER' AS VARCHAR(128)) END END END END END AS PRIVILEGE, CASE WHEN (P.TYPE = 's' OR P.TYPE = 'd' OR P.TYPE = 'i' OR P.TYPE = 'u' OR P.TYPE = 'r' OR P.TYPE = 't') THEN CAST( 'NO' AS VARCHAR(128)) ELSE CAST( 'YES' AS VARCHAR(128)) END AS IS_GRANTABLE FROM SYS.SYSCOLPERMS P, SYS.SYSCOLUMNS C, SYS.SYSTABLES T, SYS.SYSSCHEMAS S WHERE P.TABLEID = T.TABLEID AND C.REFERENCEID = T.TABLEID AND S.SCHEMAID = T.SCHEMAID AND ((1=1) OR ? IS NOT NULL) AND (S.SCHEMANAME LIKE ?)  AND (T.TABLENAME=?) AND (C.COLUMNNAME LIKE ?) AND P.COLUMNS.isSet( C.COLUMNNUMBER - 1) ORDER BY COLUMN_NAME, PRIVILEGE
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$29d8c03e-015a-84fb-0722-00000c404850
getTableTypes&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
@��SELECT CAST (RTRIM(TABLE_TYPE) AS VARCHAR(12)) AS TABLE_TYPE FROM (VALUES 'SYNONYM', 'SYSTEM TABLE', 'TABLE', 'VIEW') TABLETYPES(TABLE_TYPE) ORDER BY TABLE_TYPE
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


�
?	y
�d�<(y��u

&$00cd0029-015a-84fb-0722-00000c404850
getTypeInfo&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S

&$48d7402a-015a-84fb-0722-00000c404850getTablePrivileges_10_1&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
A�
�SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, GRANTOR, GRANTEE, PRIVILEGE, IS_GRANTABLE FROM ( VALUES (CAST ('' AS VARCHAR(128)), CAST ('' AS VARCHAR(128)), CAST ('' AS VARCHAR(128)), CAST ('' AS VARCHAR(128)), CAST ('' AS VARCHAR(128)), CAST ('' AS VARCHAR(128)), CAST ('' AS VARCHAR(128))) ) AS TABLEPRIVILEGES (TABLE_CAT, TABLE_SCHEM, TABLE_NAME, GRANTOR, GRANTEE, PRIVILEGE, IS_GRANTABLE ) WHERE (1=0) AND (((1=1) OR ? IS NOT NULL) OR ''=? OR ''=?) ORDER BY TABLE_SCHEM, TABLE_NAME, PRIVILEGE
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$20e1c02b-015a-84fb-0722-00000c404850getSuperTables&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
@��SELECT CAST(NULL AS VARCHAR(128)) AS TABLE_CAT, CAST(NULL AS VARCHAR(128)) AS TABLE_SCHEM, VARCHAR('', 128) AS TABLE_NAME, VARCHAR('', 128) AS SUPERTABLE_NAME FROM SYSIBM.SYSDUMMY1 WHERE 1=0 WITH UR
&$8000000d-00d0-fd77-3ed8-000a0a0b1900



&$19ba803c-015a-84fb-0722-00000c404850-+odbc_getBestRowIdentifierUniqueIndexColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
F��SELECT JDBC_SUBQUERY.SCOPE AS SCOPE, JDBC_SUBQUERY.COLUMN_NAME AS COLUMN_NAME, CAST (JDBC_SUBQUERY.DATA_TYPE AS SMALLINT) AS DATA_TYPE, JDBC_SUBQUERY.TYPE_NAME AS TYPE_NAME, JDBC_SUBQUERY.COLUMN_SIZE AS COLUMN_SIZE, JDBC_SUBQUERY.COL_MAX_WIDTH_IN_BYTES AS BUFFER_LENGTH, CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::DATE)) THEN CAST (NULL AS SMALLINT) ELSE JDBC_SUBQUERY.DECIMAL_DIGITS END AS DECIMAL_DIGITS, JDBC_SUBQUERY.PSEUDO_COLUMN AS PSEUDO_COLUMN FROM ( SELECT CAST (java.sql.DatabaseMetaData::bestRowSession AS SMALLINT) AS SCOPE, COLS.COLUMNNAME AS COLUMN_NAME, COLS.COLUMNDATATYPE.getJDBCTypeId() AS DATA_TYPE, CAST (COLS.COLUMNDATATYPE.getTypeName() AS VARCHAR(128)) AS TYPE_NAME, COLS.COLUMNDATATYPE.getMaximumWidth() AS COLUMN_SIZE, CAST (NULL AS INT) AS BUFFER_LENGTH, CAST ((CASE WHEN (COLS.COLUMNDATATYPE.getJDBCTypeId() IN ( java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN COLS.COLUMNDATATYPE.getPrecision() ELSE CAST (NULL AS SMALLINT) END) AS SMALLINT) AS DECIMAL_DIGITS, CAST (java.sql.DatabaseMetaData::bestRowNotPseudo AS SMALLINT) AS PSEUDO_COLUMN, COLS.COLUMNDATATYPE.getMaximumWidthInBytes() AS COL_MAX_WIDTH_IN_BYTES FROM SYS.SYSSCHEMAS SCHEMAS, SYS.SYSTABLES TABS, SYS.SYSCONGLOMERATES IDX, SYS.SYSCOLUMNS COLS WHERE TABS.TABLEID = COLS.REFERENCEID and SCHEMAS.SCHEMAID = TABS.SCHEMAID AND TABS.TABLEID = IDX.TABLEID and IDX.CONGLOMERATENUMBER = ? AND (CASE WHEN IDX.DESCRIPTOR IS NOT NULL THEN IDX.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER) ELSE 0 END) > 0 AND (?<>0 or not COLS.COLUMNDATATYPE.isNullable() ) ) JDBC_SUBQUERY
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


��@
f��<n��tu



O~|SELECT CAST (RTRIM(CAST (T1 AS CHAR(128))) AS VARCHAR(128)) AS TYPE_NAME, T2 AS DATA_TYPE, T3 AS PRECISION, CAST (RTRIM(CAST(T4 AS CHAR(10))) AS VARCHAR(10)) AS LITERAL_PREFIX, CAST (RTRIM(T5) AS VARCHAR(10)) AS LITERAL_SUFFIX, CAST (RTRIM(CAST(T6 AS CHAR(20))) AS VARCHAR(20)) AS CREATE_PARAMS, CAST (T7 AS SMALLINT) AS NULLABLE, T8 AS CASE_SENSITIVE, CAST (T9 AS SMALLINT) AS SEARCHABLE, T10 AS UNSIGNED_ATTRIBUTE, T11 AS FIXED_PREC_SCALE, T12 AS AUTO_INCREMENT, CAST (RTRIM(CAST(T1 AS CHAR(128))) AS VARCHAR(128)) AS LOCAL_TYPE_NAME, CAST (T14 AS SMALLINT) AS MINIMUM_SCALE, CAST (T15 AS SMALLINT) AS MAXIMUM_SCALE, CAST (NULL AS INT) AS SQL_DATA_TYPE, CAST (NULL AS INT) AS SQL_DATETIME_SUB, T18 AS NUM_PREC_RADIX FROM ( VALUES ('BIGINT',-5,19,CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,FALSE,2,FALSE,FALSE,TRUE,0,0,10),('LONG VARCHAR FOR BIT DATA',-4,32700,'X''','''',CAST (NULL AS CHAR), 1,FALSE,0,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER), CAST (NULL AS INTEGER)), ('VARCHAR () FOR BIT DATA',-3,32672,'X''','''','length', 1,FALSE,2,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER), CAST (NULL AS INTEGER)), ('CHAR () FOR BIT DATA',-2,254,'X''','''','length', 1,FALSE,2,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER), CAST (NULL AS INTEGER)), ('LONG VARCHAR',-1,32700,'''','''',CAST (NULL AS CHAR), 1,TRUE,1,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER), CAST (NULL AS INTEGER)), ('CHAR',1,254,'''','''','length', 1,TRUE,3,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER), CAST (NULL AS INTEGER)), ('NUMERIC',2,31,CAST (NULL AS CHAR),CAST (NULL AS CHAR),'precision,scale', 1,FALSE,2,FALSE,TRUE,FALSE,0,31,10),('DECIMAL',3,31,CAST (NULL AS CHAR),CAST (NULL AS CHAR),'precision,scale', 1,FALSE,2,FALSE,TRUE,FALSE,0,31,10),('INTEGER',4,10,CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,FALSE,2,FALSE,FALSE,TRUE,0,0,10),('SMALLINT',5,5,CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,FALSE,2,FALSE,FALSE,TRUE,0,0,10),('FLOAT',6,52,CAST (NULL AS CHAR),CAST (NULL AS CHAR),'precision', 1,FALSE,2,FALSE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),2),('REAL',7,23,CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,FALSE,2,FALSE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),2),('DOUBLE',8,52,CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,FALSE,2,FALSE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),2),('VARCHAR',12,32672,'''','''','length', 1,TRUE,3,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER), CAST (NULL AS INTEGER)), ('BOOLEAN',16,1,CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,FALSE,2,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),CAST (NULL AS INTEGER)),('DATE',91,10,'DATE''','''',CAST (NULL AS CHAR), 1,FALSE,2,TRUE,FALSE,FALSE,0,0,10),('TIME',92,8,'TIME''','''',CAST (NULL AS CHAR), 1,FALSE,2,TRUE,FALSE,FALSE,0,0,10),('TIMESTAMP',93,29,'TIMESTAMP''','''',CAST (NULL AS CHAR), 1,FALSE,2,TRUE,FALSE,FALSE,0,9,10),('OBJECT',2000,CAST (NULL AS INTEGER),CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,FALSE,2,TRUE,FALSE,FALSE,CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),CAST (NULL AS INTEGER)),('BLOB',2004,2147483647,CAST (NULL AS CHAR),CAST (NULL AS CHAR),'length', 1,FALSE,0,CAST (NULL AS BOOLEAN),FALSE,CAST (NULL AS BOOLEAN), CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),CAST (NULL AS INTEGER)),('CLOB',2005,2147483647,'''','''','length', 1,TRUE,1,CAST (NULL AS BOOLEAN),FALSE,CAST (NULL AS BOOLEAN), CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),CAST (NULL AS INTEGER)), ('XML',2009,CAST (NULL AS INTEGER),CAST (NULL AS CHAR),CAST (NULL AS CHAR),CAST (NULL AS CHAR), 1,TRUE,0,FALSE,FALSE,FALSE, CAST (NULL AS INTEGER),CAST (NULL AS INTEGER),CAST (NULL AS INTEGER)) ) AS TYPEINFO(T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T14,T15,T18) WHERE (T1 <> 'BOOLEAN' OR CAST(? AS SMALLINT) <> 0)�
02)]��0-fd77-3ed8-000a0a0b1900


<��,�Su

&$98ec802c-015a-84fb-0722-00000c404850getCrossReference&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S


&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$c0f7802d-015a-84fb-0722-00000c404850getVersionColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
A�
�SELECT SCOPE, COLUMN_NAME, DATA_TYPE, TYPE_NAME, COLUMN_SIZE, BUFFER_LENGTH, DECIMAL_DIGITS, PSEUDO_COLUMN FROM ( VALUES (SMALLINT(1), CAST ('' AS VARCHAR(128)), 1, CAST ('' AS VARCHAR(128)), 1, 1, SMALLINT(1), SMALLINT(1)) ) AS VERSIONCOLUMNS (SCOPE, COLUMN_NAME, DATA_TYPE, TYPE_NAME, COLUMN_SIZE, BUFFER_LENGTH, DECIMAL_DIGITS, PSEUDO_COLUMN ) WHERE (1=0) AND (((1=1) OR ? IS NOT NULL) OR ''=? OR ''=?)
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$a902c02e-015a-84fb-0722-00000c404850odbc_getProcedures&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
BPNSELECT CAST ('' AS VARCHAR(128)) AS PROCEDURE_CAT, SCHEMANAME AS PROCEDURE_SCHEM, ALIAS AS PROCEDURE_NAME, CAST (NULL AS INT) AS NUM_INPUT_PARAMS, CAST (NULL AS INT) AS NUM_OUTPUT_PARAMS, CAST (NULL AS INT) AS NUM_RESULT_SETS, CAST ((JAVACLASSNAME||'.'|| ALIASINFO->getMethodName()) AS VARCHAR(32672)) AS REMARKS, CAST (java.sql.DatabaseMetaData::procedureNoResult AS SMALLINT) AS PROCEDURE_TYPE FROM SYS.SYSALIASES, SYS.SYSSCHEMAS WHERE ((1=1) OR ? IS NOT NULL) AND (ALIASTYPE = 'P' AND SCHEMANAME LIKE ?) AND SYS.SYSALIASES.SCHEMAID = SYS.SYSSCHEMAS.SCHEMAID AND ALIAS LIKE ? ORDER BY 2,3
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


	&$610e402f-015a-84fb-0722-00000c404850getPseudoColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
A�
�SELECT CAST(NULL AS VARCHAR(128)) AS TABLE_CAT, CAST(NULL AS VARCHAR(128)) AS TABLE_SCHEM, VARCHAR('', 128) AS TABLE_NAME, VARCHAR('',128) AS COLUMN_NAME, CAST(1 AS INT) AS DATA_TYPE, CAST(1 AS INT) AS COLUMN_SIZE, CAST(NULL AS INT) AS DECIMAL_DIGITS, CAST(NULL AS INT) AS NUM_PREC_RADIX, VARCHAR('',128) AS COLUMN_USAGE, CAST(NULL AS VARCHAR(32672)) AS REMARKS, CAST(NULL AS INT) AS CHAR_OCTET_LENGTH, VARCHAR('NO',128) AS IS_NULLABLE FROM SYSIBM.SYSDUMMY1 WHERE 1=0 WITH UR
&$8000000d-00d0-fd77-3ed8-000a0a0b1900



&$f91a0030-015a-84fb-0722-00000c404850
getSchemas&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
@��SELECT SCHEMANAME AS TABLE_SCHEM, CAST(NULL AS VARCHAR(128)) AS TABLE_CATALOG FROM SYS.SYSSCHEMAS WHERE ((1=1) OR ? IS NOT NULL) AND SCHEMANAME LIKE ? ORDER BY TABLE_SCHEM
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


�
G
}��8<��'{�u




O��SELECT CAST ('' AS VARCHAR(128)) AS PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, PKCOLUMN_NAME, CAST ('' AS VARCHAR(128)) AS FKTABLE_CAT, S2.SCHEMANAME AS FKTABLE_SCHEM, T2.TABLENAME AS FKTABLE_NAME, COLS2.COLUMNNAME AS FKCOLUMN_NAME, CAST (CONGLOMS2.DESCRIPTOR.getKeyColumnPosition( COLS2.COLUMNNUMBER) AS SMALLINT) AS KEY_SEQ, CAST ((CASE WHEN F2.UPDATERULE='S' THEN java.sql.DatabaseMetaData::importedKeyRestrict ELSE  (CASE WHEN F2.UPDATERULE='R' THEN java.sql.DatabaseMetaData::importedKeyNoAction ELSE java.sql.DatabaseMetaData::importedKeyNoAction END) END)  AS SMALLINT) AS UPDATE_RULE, CAST ((CASE WHEN F2.DELETERULE='S' THEN java.sql.DatabaseMetaData::importedKeyRestrict ELSE  (CASE WHEN F2.DELETERULE='R' THEN java.sql.DatabaseMetaData::importedKeyNoAction ELSE (CASE WHEN F2.DELETERULE='C' THEN java.sql.DatabaseMetaData::importedKeyCascade ELSE (CASE WHEN F2.DELETERULE='U' THEN java.sql.DatabaseMetaData::importedKeySetNull ELSE java.sql.DatabaseMetaData::importedKeyNoAction END)END)ENd)END)  AS SMALLINT) AS DELETE_RULE, C2.CONSTRAINTNAME AS FK_NAME, PK_NAME, CAST ( (CASE WHEN C2.STATE = 'E'THEN java.sql.DatabaseMetaData::importedKeyNotDeferrable ELSE ( CASE WHEN C2.STATE = 'i'THEN java.sql.DatabaseMetaData::importedKeyInitiallyImmediate ELSE java.sql.DatabaseMetaData::importedKeyInitiallyDeferred END) END) AS SMALLINT) AS DEFERRABILITY FROM --DERBY-PROPERTIES joinOrder=FIXED 
(SELECT C.CONSTRAINTID AS PK_ID, CONSTRAINTNAME AS PK_NAME, PKTB_SCHEMA AS PKTABLE_SCHEM,  PKTB_NAME AS PKTABLE_NAME, COLS.COLUMNNAME AS PKCOLUMN_NAME, CONGLOMS.DESCRIPTOR.getKeyColumnPosition( COLS.COLUMNNUMBER) AS KEY_SEQ FROM --DERBY-PROPERTIES joinOrder=FIXED 
(SELECT T.TABLEID AS PKTB_ID, S.SCHEMANAME AS PKTB_SCHEMA, T.TABLENAME AS PKTB_NAME FROM  SYS.SYSTABLES t --DERBY-PROPERTIES index = 'SYSTABLES_INDEX1' 
, SYS.SYSSCHEMAS s --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSSCHEMAS_INDEX1' 
WHERE ((1=1) OR ? IS NOT NULL) AND S.SCHEMANAME LIKE ? AND T.TABLENAME=? AND S.SCHEMAID = T.SCHEMAID ) AS PKTB (PKTB_ID, PKTB_SCHEMA, PKTB_NAME), SYS.SYSCONSTRAINTS C --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCONSTRAINTS_INDEX3' 
, SYS.SYSKEYS K --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSKEYS_INDEX1' 
, SYS.SYSCONGLOMERATES CONGLOMS --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCONGLOMERATES_INDEX1' 
, SYS.SYSCOLUMNS COLS --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index =  'SYSCOLUMNS_INDEX1' 
WHERE  PKTB.PKTB_ID = C.TABLEID AND K.CONSTRAINTID = C.CONSTRAINTID  AND PKTB.PKTB_ID = COLS.REFERENCEID AND (CASE WHEN CONGLOMS.DESCRIPTOR IS NOT NULL THEN CONGLOMS.DESCRIPTOR.getKeyColumnPosition( COLS.COLUMNNUMBER) ELSE 0 END) <> 0 AND K.CONGLOMERATEID = CONGLOMS.CONGLOMERATEID ) AS PKINFO(PK_ID, PK_NAME, PKTABLE_SCHEM, PKTABLE_NAME, PKCOLUMN_NAME, KEY_SEQ), SYS.SYSFOREIGNKEYS F2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSFOREIGNKEYS_INDEX1' 
, SYS.SYSCONSTRAINTS c2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCONSTRAINTS_INDEX1'  
, SYS.SYSTABLES T2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSTABLES_INDEX2'  
, SYS.SYSSCHEMAS S2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSSCHEMAS_INDEX2' 
, SYS.SYSCONGLOMERATES CONGLOMS2 --DERBY-PROPERTIES joinStrategy = NESTEDLOOP, index = 'SYSCONGLOMERATES_INDEX1'  
, SYS.SYSCOLUMNS COLS2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCOLUMNS_INDEX1' 
WHERE  F2.keyCONSTRAINTID = PKINFO.PK_ID AND PKINFO.KEY_SEQ = CONGLOMS2.DESCRIPTOR.getKeyColumnPosition(  COLS2.COLUMNNUMBER)  AND T2.TABLEID = C2.TABLEID AND ((1=1) OR ? IS NOT NULL) AND S2.SCHEMANAME LIKE ? AND T2.TABLENAME LIKE ? AND S2.SCHEMAID = T2.SCHEMAID  AND F2.CONSTRAINTID = C2.CONSTRAINTID  AND (CASE WHEN CONGLOMS2.DESCRIPTOR IS NOT NULL THEN CONGLOMS2.DESCRIPTOR.getKeyColumnPosition(COLS2.COLUMNNUMBER) ELSE 0 END) <> 0 AND F2.CONGLOMERATEID = CONGLOMS2.CONGLOMERATEID AND C2.TABLEID = COLS2.REFERENCEID ORDER BY FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, FK_NAME, KEY_SEQ<�� ��u


&$81260031-015a-84fb-0722-00000c404850odbc_getCrossReference&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S

&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$09324032-015a-84fb-0722-00000c404850odbc_getVersionColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
CSELECT JDBC_SUBQUERY.SCOPE AS SCOPE, JDBC_SUBQUERY.COLUMN_NAME AS COLUMN_NAME, CAST (JDBC_SUBQUERY.DATA_TYPE AS SMALLINT) AS DATA_TYPE, JDBC_SUBQUERY.TYPE_NAME AS TYPE_NAME, JDBC_SUBQUERY.COLUMN_SIZE AS COLUMN_SIZE, JDBC_SUBQUERY.BUFFER_LENGTH AS BUFFER_LENGTH, JDBC_SUBQUERY.DECIMAL_DIGITS AS DECIMAL_DIGITS, JDBC_SUBQUERY.PSEUDO_COLUMN AS PSEUDO_COLUMN FROM ( SELECT SCOPE, COLUMN_NAME, DATA_TYPE, TYPE_NAME, COLUMN_SIZE, BUFFER_LENGTH, DECIMAL_DIGITS, PSEUDO_COLUMN FROM ( VALUES (SMALLINT(1), CAST ('' AS VARCHAR(128)), 1, CAST ('' AS VARCHAR(128)), 1, 1, SMALLINT(1), SMALLINT(1)) ) AS VERSIONCOLUMNS (SCOPE, COLUMN_NAME, DATA_TYPE, TYPE_NAME, COLUMN_SIZE, BUFFER_LENGTH, DECIMAL_DIGITS, PSEUDO_COLUMN ) WHERE (1=0) AND (((1=1) OR ? IS NOT NULL) OR ''=? OR ''=?) ) JDBC_SUBQUERY
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$a13ec033-015a-84fb-0722-00000c404850getFunctionColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
G��SELECT CAST(NULL AS VARCHAR(128)) AS FUNCTION_CAT, S.SCHEMANAME       AS FUNCTION_SCHEM, A.ALIAS            AS FUNCTION_NAME, V."COLUMN_NAME"    AS COLUMN_NAME, V."COLUMN_TYPE"    AS COLUMN_TYPE, V."DATA_TYPE"      AS DATA_TYPE, V."TYPE_NAME"      AS TYPE_NAME, V."PRECISION"      AS PRECISION, V."LENGTH"         AS LENGTH, CASE WHEN (V."DATA_TYPE" IN (java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN V."SCALE" ELSE CAST (NULL AS SMALLINT) END AS SCALE, CASE WHEN (V."DATA_TYPE" IN (java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DOUBLE, java.sql.Types::FLOAT, java.sql.Types::REAL, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN V."RADIX" ELSE CAST (NULL AS SMALLINT) END AS RADIX, V."NULLABLE"          AS NULLABLE, V."REMARKS"           AS REMARKS, CASE WHEN (V."DATA_TYPE" IN ( java.sql.Types::CHAR, java.sql.Types::VARCHAR, java.sql.Types::BINARY, java.sql.Types::VARBINARY)) THEN V."LENGTH" ELSE CAST(NULL AS INT) END AS CHAR_OCTET_LENGTH, CASE WHEN (V."COLUMN_TYPE" = 5) THEN CAST((V."PARAMETER_ID" + 1 - V."METHOD_ID") AS INT) ELSE CAST((V."PARAMETER_ID" + 1) AS INT) END AS ORDINAL_POSITION, CAST(( CASE WHEN V."NULLABLE" = java.sql.DatabaseMetaData::procedureNullable THEN 'YES' ELSE 'NO' END) AS VARCHAR(128)) AS IS_NULLABLE, A.SPECIFICNAME        AS SPECIFIC_NAME, V."METHOD_ID"         AS METHOD_ID, V."PARAMETER_ID"      AS PARAMETER_ID FROM SYS.SYSALIASES A, SYS.SYSSCHEMAS S, NEW org.apache.derby.catalog.GetProcedureColumns(A.ALIASINFO, A.ALIASTYPE) V WHERE A.ALIASTYPE = 'F' AND S.SCHEMANAME LIKE ? AND A.SCHEMAID = S.SCHEMAID AND A.ALIAS LIKE ? AND (V."COLUMN_NAME" LIKE ?) ORDER BY FUNCTION_SCHEM, FUNCTION_NAME, SPECIFIC_NAME, PARAMETER_ID, ORDINAL_POSITION
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


�{��<��]u




O��SELECT CAST ('' AS VARCHAR(128)) AS PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, PKCOLUMN_NAME, CAST ('' AS VARCHAR(128)) AS FKTABLE_CAT, S2.SCHEMANAME AS FKTABLE_SCHEM, T2.TABLENAME AS FKTABLE_NAME, COLS2.COLUMNNAME AS FKCOLUMN_NAME, CAST (CONGLOMS2.DESCRIPTOR.getKeyColumnPosition( COLS2.COLUMNNUMBER) AS SMALLINT) AS KEY_SEQ, CAST ((CASE WHEN F2.UPDATERULE='S' THEN java.sql.DatabaseMetaData::importedKeyRestrict ELSE  (CASE WHEN F2.UPDATERULE='R' THEN java.sql.DatabaseMetaData::importedKeyNoAction ELSE java.sql.DatabaseMetaData::importedKeyNoAction END) END)  AS SMALLINT) AS UPDATE_RULE, CAST ((CASE WHEN F2.DELETERULE='S' THEN java.sql.DatabaseMetaData::importedKeyRestrict ELSE  (CASE WHEN F2.DELETERULE='R' THEN java.sql.DatabaseMetaData::importedKeyNoAction ELSE (CASE WHEN F2.DELETERULE='C' THEN java.sql.DatabaseMetaData::importedKeyCascade ELSE (CASE WHEN F2.DELETERULE='U' THEN java.sql.DatabaseMetaData::importedKeySetNull ELSE java.sql.DatabaseMetaData::importedKeyNoAction END)END)ENd)END)  AS SMALLINT) AS DELETE_RULE, C2.CONSTRAINTNAME AS FK_NAME, PK_NAME, CAST ( (CASE WHEN C2.STATE = 'E'THEN java.sql.DatabaseMetaData::importedKeyNotDeferrable ELSE ( CASE WHEN C2.STATE = 'i'THEN java.sql.DatabaseMetaData::importedKeyInitiallyImmediate ELSE java.sql.DatabaseMetaData::importedKeyInitiallyDeferred END) END) AS SMALLINT) AS DEFERRABILITY FROM --DERBY-PROPERTIES joinOrder=FIXED 
(SELECT C.CONSTRAINTID AS PK_ID, CONSTRAINTNAME AS PK_NAME, PKTB_SCHEMA AS PKTABLE_SCHEM,  PKTB_NAME AS PKTABLE_NAME, COLS.COLUMNNAME AS PKCOLUMN_NAME, CONGLOMS.DESCRIPTOR.getKeyColumnPosition( COLS.COLUMNNUMBER) AS KEY_SEQ FROM --DERBY-PROPERTIES joinOrder=FIXED 
(SELECT T.TABLEID AS PKTB_ID, S.SCHEMANAME AS PKTB_SCHEMA, T.TABLENAME AS PKTB_NAME FROM  SYS.SYSTABLES t --DERBY-PROPERTIES index = 'SYSTABLES_INDEX1' 
, SYS.SYSSCHEMAS s --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSSCHEMAS_INDEX1' 
WHERE ((1=1) OR ? IS NOT NULL) AND S.SCHEMANAME LIKE ? AND T.TABLENAME LIKE ? AND S.SCHEMAID = T.SCHEMAID ) AS PKTB (PKTB_ID, PKTB_SCHEMA, PKTB_NAME), SYS.SYSCONSTRAINTS C --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCONSTRAINTS_INDEX3' 
, SYS.SYSKEYS K --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSKEYS_INDEX1' 
, SYS.SYSCONGLOMERATES CONGLOMS --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCONGLOMERATES_INDEX1' 
, SYS.SYSCOLUMNS COLS --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index =  'SYSCOLUMNS_INDEX1' 
WHERE  PKTB.PKTB_ID = C.TABLEID AND K.CONSTRAINTID = C.CONSTRAINTID  AND PKTB.PKTB_ID = COLS.REFERENCEID AND (CASE WHEN CONGLOMS.DESCRIPTOR IS NOT NULL THEN CONGLOMS.DESCRIPTOR.getKeyColumnPosition( COLS.COLUMNNUMBER) ELSE 0 END) <> 0 AND K.CONGLOMERATEID = CONGLOMS.CONGLOMERATEID ) AS PKINFO(PK_ID, PK_NAME, PKTABLE_SCHEM, PKTABLE_NAME, PKCOLUMN_NAME, KEY_SEQ), SYS.SYSFOREIGNKEYS F2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSFOREIGNKEYS_INDEX1' 
, SYS.SYSCONSTRAINTS c2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCONSTRAINTS_INDEX1'  
, SYS.SYSTABLES T2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSTABLES_INDEX2'  
, SYS.SYSSCHEMAS S2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSSCHEMAS_INDEX2' 
, SYS.SYSCONGLOMERATES CONGLOMS2 --DERBY-PROPERTIES joinStrategy = NESTEDLOOP, index = 'SYSCONGLOMERATES_INDEX1'  
, SYS.SYSCOLUMNS COLS2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCOLUMNS_INDEX1' 
WHERE  F2.keyCONSTRAINTID = PKINFO.PK_ID AND PKINFO.KEY_SEQ = CONGLOMS2.DESCRIPTOR.getKeyColumnPosition(  COLS2.COLUMNNUMBER)  AND T2.TABLEID = C2.TABLEID AND ((1=1) OR ? IS NOT NULL) AND S2.SCHEMANAME LIKE ? AND T2.TABLENAME LIKE ? AND S2.SCHEMAID = T2.SCHEMAID  AND F2.CONSTRAINTID = C2.CONSTRAINTID  AND (CASE WHEN CONGLOMS2.DESCRIPTOR IS NOT NULL THEN CONGLOMS2.DESCRIPTOR.getKeyColumnPosition(COLS2.COLUMNNUMBER) ELSE 0 END) <> 0 AND F2.CONGLOMERATEID = CONGLOMS2.CONGLOMERATEID AND C2.TABLEID = COLS2.REFERENCEID ORDER BY FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, FK_NAME, KEY_SEQ<���kpu

&$594b8034-015a-84fb-0722-00000c404850
getAttributes&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
CdbSELECT CAST(NULL AS VARCHAR(128)) AS TYPE_CAT, CAST(NULL AS VARCHAR(128)) AS TYPE_SCHEM, VARCHAR('', 128) AS TYPE_NAME, CAST(NULL AS VARCHAR(128)) AS ATTR_NAME, CAST(NULL AS INT) AS DATA_TYPE, CAST(NULL AS VARCHAR(128)) AS ATTR_TYPE_NAME, CAST(NULL AS INT) AS ATTR_SIZE, CAST(NULL AS INT) AS DECIMAL_DIGITS, CAST(NULL AS INT) AS NUM_PREC_RADIX, CAST(NULL AS INT) AS NULLABLE, CAST(NULL AS VARCHAR(128)) AS REMARKS, CAST(NULL AS VARCHAR(128)) AS ATTR_DEF, CAST(NULL AS INT) AS SQL_DATA_TYPE, CAST(NULL AS INT) AS SQL_DATETIME_SUB, CAST(NULL AS INT) AS CHAR_OCTET_LENGTH, CAST(NULL AS INT) AS ORDINAL_POSITION, CAST(NULL AS VARCHAR(128)) AS IS_NULLABLE, CAST(NULL AS VARCHAR(128)) AS SCOPE_CATALOG, CAST(NULL AS VARCHAR(128)) AS SCOPE_SCHEMA, CAST(NULL AS VARCHAR(128)) AS SCOPE_TABLE, CAST(NULL AS SMALLINT) AS SOURCE_DATA_TYPE FROM SYSIBM.SYSDUMMY1 WHERE 1=0 WITH UR
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$41588035-015a-84fb-0722-00000c404850getFunctions&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
B��SELECT CAST(NULL AS VARCHAR(128)) AS FUNCTION_CAT, SYS.SYSSCHEMAS.SCHEMANAME AS FUNCTION_SCHEM, SYS.SYSALIASES.ALIAS AS FUNCTION_NAME, CAST ((SYS.SYSALIASES.JAVACLASSNAME || '.' || SYS.SYSALIASES.ALIASINFO->getMethodName()) AS VARCHAR(32672)) AS REMARKS, CASE WHEN (SYS.SYSALIASES.ALIASINFO->isTableFunction())THEN CAST (2 AS SMALLINT)ELSE CAST (1 AS SMALLINT) END AS FUNCTION_TYPE, SYS.SYSALIASES.SPECIFICNAME AS SPECIFIC_NAME FROM SYS.SYSSCHEMAS, SYS.SYSALIASES WHERE SYS.SYSALIASES.SCHEMAID = SYS.SYSSCHEMAS.SCHEMAID AND SYS.SYSALIASES.ALIASTYPE = 'F' AND ((1=1) OR ? IS NOT NULL) AND SYS.SYSSCHEMAS.SCHEMANAME LIKE ? AND SYS.SYSALIASES.ALIAS LIKE ? ORDER BY FUNCTION_SCHEM, FUNCTION_NAME, SPECIFIC_NAME
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$6965c036-015a-84fb-0722-00000c404850	getTables&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S

C,*SELECT CAST ('' AS VARCHAR(128)) AS TABLE_CAT, SCHEMANAME AS TABLE_SCHEM,  TABLENAME AS TABLE_NAME, (CAST (RTRIM(TABLE_TYPE) AS VARCHAR(12))) AS TABLE_TYPE, CAST ('' AS VARCHAR(128)) AS REMARKS, CAST (NULL AS VARCHAR(128)) AS TYPE_CAT, CAST (NULL AS VARCHAR(128)) AS TYPE_SCHEM, CAST (NULL AS VARCHAR(128)) AS TYPE_NAME, CAST (NULL AS VARCHAR(128)) AS SELF_REFERENCING_COL_NAME, CAST (NULL AS VARCHAR(128)) AS REF_GENERATION FROM SYS.SYSTABLES, SYS.SYSSCHEMAS, (VALUES ('T','TABLE'), ('S','SYSTEM TABLE'), ('V', 'VIEW'), ('A', 'SYNONYM')) T(TTABBREV,TABLE_TYPE) WHERE (TTABBREV=TABLETYPE 	AND (SYS.SYSTABLES.SCHEMAID = SYS.SYSSCHEMAS.SCHEMAID) AND ((1=1) OR ? IS NOT NULL) AND (SYS.SYSSCHEMAS.SCHEMANAME LIKE ?) AND (TABLENAME LIKE ?) AND TABLETYPE IN (?, ?, ?, ?)) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME�
042�&$8000000d-00d0-fd77-3ed8-000a0a0b1900
1
	&$e1734037-015a-84fb-0722-00000c404850getClientInfoProperties&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
@��SELECT CAST(NULL AS VARCHAR(128)) AS NAME, CAST(NULL AS INT) AS MAX_LEN, CAST(NULL AS VARCHAR(128)) AS DEFAULT_VALUE, CAST(NULL AS VARCHAR(128)) AS DESCRIPTION FROM SYSIBM.SYSDUMMY1 WHERE 1=0 WITH UR
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


u
p��>`<��3u
	
&$b9810038-015a-84fb-0722-00000c404850 getBestRowIdentifierAllColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
DJHSELECT CAST (java.sql.DatabaseMetaData::bestRowSession AS SMALLINT) AS SCOPE, COLS.COLUMNNAME AS COLUMN_NAME, COLS.COLUMNDATATYPE.getJDBCTypeId() AS DATA_TYPE, CAST (COLS.COLUMNDATATYPE.getTypeName() AS VARCHAR(128)) AS TYPE_NAME, COLS.COLUMNDATATYPE.getMaximumWidth() AS COLUMN_SIZE, CAST (NULL AS INT) AS BUFFER_LENGTH, CAST ((CASE WHEN (COLS.COLUMNDATATYPE.getJDBCTypeId() IN ( java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN COLS.COLUMNDATATYPE.getPrecision() ELSE CAST (NULL AS SMALLINT) END) AS SMALLINT) AS DECIMAL_DIGITS, CAST (java.sql.DatabaseMetaData::bestRowNotPseudo AS SMALLINT) AS PSEUDO_COLUMN FROM SYS.SYSSCHEMAS SCHEMAS, SYS.SYSTABLES TABS,  SYS.SYSCOLUMNS COLS  WHERE COLS.REFERENCEID = TABS.TABLEID  AND TABS.SCHEMAID = SCHEMAS.SCHEMAID  AND ((1=1) OR ? IS NOT NULL)  AND (SCHEMAS.SCHEMANAME LIKE ?)  AND (TABS.TABLENAME=?) AND ? BETWEEN 0 AND 2  AND (?<>0 OR NOT COLS.COLUMNDATATYPE.isNullable())
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$018f0039-015a-84fb-0722-00000c404850getProcedureColumns40&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
HMKSELECT CAST (NULL AS VARCHAR(128)) AS PROCEDURE_CAT, S.SCHEMANAME                AS PROCEDURE_SCHEM, A.ALIAS                     AS PROCEDURE_NAME, V."COLUMN_NAME"             AS COLUMN_NAME, V."COLUMN_TYPE"             AS COLUMN_TYPE, V."DATA_TYPE"               AS DATA_TYPE, V."TYPE_NAME"               AS TYPE_NAME, V."PRECISION"               AS PRECISION, V."LENGTH"                  AS LENGTH, CASE WHEN (V."DATA_TYPE" IN (java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN V."SCALE" ELSE CAST (NULL AS SMALLINT) END AS SCALE, CASE WHEN (V."DATA_TYPE" IN (java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DOUBLE, java.sql.Types::FLOAT, java.sql.Types::REAL, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN V."RADIX" ELSE CAST (NULL AS SMALLINT) END AS RADIX, V."NULLABLE"                AS NULLABLE, V."REMARKS"                 AS REMARKS, CAST (NULL AS VARCHAR(254)) AS COLUMN_DEF, CAST (NULL AS INTEGER)      AS SQL_DATA_TYPE, CAST (NULL AS INTEGER)      AS SQL_DATETIME_SUB, CASE WHEN (V."DATA_TYPE" IN (java.sql.Types::CHAR, java.sql.Types::VARCHAR, java.sql.Types::BINARY, java.sql.Types::VARBINARY)) THEN V."LENGTH" ELSE CAST (NULL AS INTEGER) END AS CHAR_OCTET_LENGTH, CAST ((V."PARAMETER_ID" + 1) AS INT) AS ORDINAL_POSITION, CAST ((CASE WHEN (V."NULLABLE" IN (java.sql.DatabaseMetaData::procedureNullable)) THEN 'YES' ELSE 'NO' END) AS VARCHAR(128)) AS IS_NULLABLE, A.SPECIFICNAME   AS SPECIFIC_NAME, V."METHOD_ID"    AS METHOD_ID, V."PARAMETER_ID" AS PARAMETER_ID FROM SYS.SYSALIASES A, SYS.SYSSCHEMAS S, NEW org.apache.derby.catalog.GetProcedureColumns(A.ALIASINFO, A.ALIASTYPE) V WHERE A.ALIASTYPE = 'P' AND S.SCHEMANAME LIKE ? AND A.SCHEMAID = S.SCHEMAID AND A.ALIAS LIKE ? AND V."COLUMN_NAME" LIKE ? ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME, SPECIFIC_NAME, METHOD_ID, PARAMETER_ID
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


5�<����}u


&$61e8403f-015a-84fb-0722-00000c404850getPrimaryKeys&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
ESELECT CAST ('' AS VARCHAR(128)) AS TABLE_CAT, S.SCHEMANAME AS TABLE_SCHEM, T.TABLENAME AS TABLE_NAME, COLS.COLUMNNAME AS COLUMN_NAME, CAST (CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER) AS SMALLINT) AS KEY_SEQ, CONS.CONSTRAINTNAME AS PK_NAME FROM --DERBY-PROPERTIES joinOrder=FIXED 
 SYS.SYSTABLES T --DERBY-PROPERTIES index='SYSTABLES_INDEX1' 
, SYS.SYSSCHEMAS S --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index ='SYSSCHEMAS_INDEX1'  
, SYS.SYSCONSTRAINTS CONS --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index ='SYSCONSTRAINTS_INDEX3'  
, SYS.SYSKEYS KEYS --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index ='SYSKEYS_INDEX1' 
, SYS.SYSCONGLOMERATES CONGLOMS --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCONGLOMERATES_INDEX1' 
, SYS.SYSCOLUMNS COLS --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index ='SYSCOLUMNS_INDEX1' 
WHERE ((1=1) OR ? IS NOT NULL) AND S.SCHEMANAME LIKE ? AND T.TABLENAME=? AND T.SCHEMAID = S.SCHEMAID AND	T.TABLEID = COLS.REFERENCEID AND T.TABLEID = CONGLOMS.TABLEID AND CONS.TABLEID = T.TABLEID AND CONS.TYPE = 'P' AND CONS.CONSTRAINTID = KEYS.CONSTRAINTID AND (CASE WHEN CONGLOMS.DESCRIPTOR IS NOT NULL THEN CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER) ELSE 0 END) <> 0 AND KEYS.CONGLOMERATEID = CONGLOMS.CONGLOMERATEID ORDER BY COLUMN_NAME
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


<�<)'Tu


&$79f80040-015a-84fb-0722-00000c404850
getColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S

NGESELECT CAST ('' AS VARCHAR(128)) AS TABLE_CAT, S.SCHEMANAME AS TABLE_SCHEM, T.TABLENAME AS TABLE_NAME, C.COLUMNNAME AS COLUMN_NAME, C.COLUMNDATATYPE.getJDBCTypeId() AS DATA_TYPE, (CAST (C.COLUMNDATATYPE.getTypeName() AS VARCHAR(128))) AS TYPE_NAME, CASE WHEN (C.COLUMNDATATYPE.getJDBCTypeId() IN (java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::REAL, java.sql.Types::DOUBLE,java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::FLOAT)) THEN C.COLUMNDATATYPE.getPrecision() ELSE C.COLUMNDATATYPE.getMaximumWidth() END AS COLUMN_SIZE, CAST( NULL AS INT) AS BUFFER_LENGTH, CASE WHEN (C.COLUMNDATATYPE.getJDBCTypeId() IN (java.sql.Types::DECIMAL, 				java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN C.COLUMNDATATYPE.getScale() ELSE CAST(NULL AS INT) END AS DECIMAL_DIGITS, 											CASE WHEN (C.COLUMNDATATYPE.getJDBCTypeId() IN (java.sql.Types::REAL, 					java.sql.Types::DOUBLE, java.sql.Types::FLOAT)) THEN 2 ELSE (CASE WHEN (C.COLUMNDATATYPE.getJDBCTypeId() IN ( java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN 10 ELSE CAST (NULL AS INTEGER) END) END AS NUM_PREC_RADIX, 											CASE WHEN C.COLUMNDATATYPE.isNullable() THEN java.sql.DatabaseMetaData::columnNullable ELSE java.sql.DatabaseMetaData::columnNoNulls END AS NULLABLE, CAST ('' AS VARCHAR(128)) AS REMARKS, CASE WHEN (COLUMNDEFAULT IS NULL) THEN  (CASE WHEN (AUTOINCREMENTINC is NULL) THEN  CAST (NULL AS VARCHAR(254)) ELSE 'AUTOINCREMENT: start ' || -- The AUTOINCREMENT* columns have incorrect meta-data 
 -- if the database was created with an old version of  
 -- Derby (see DERBY-1745 and DERBY-5274), and the CHAR 
 -- function won't work. Wrap them in a BIGINT function 
 -- call to fix the meta-data, even though the columns  
 -- already are of type BIGINT.                         
 RTRIM(CHAR(BIGINT(AUTOINCREMENTSTART))) || ' increment ' || RTRIM(CHAR(BIGINT(AUTOINCREMENTINC))) END ) ELSE CAST (COLUMNDEFAULT AS VARCHAR(254)) END AS COLUMN_DEF, CAST( NULL AS INT) AS SQL_DATA_TYPE, CAST( NULL AS INT) AS SQL_DATETIME_SUB, CASE WHEN (C.COLUMNDATATYPE.getJDBCTypeId() IN (java.sql.Types::CHAR,	 				java.sql.Types::VARCHAR)) THEN (CASE WHEN (C.COLUMNDATATYPE.getMaximumWidth() * 2.0 > 2147483647) THEN 2147483647 ELSE (C.COLUMNDATATYPE.getMaximumWidth() * 2) END) ELSE CAST(NULL AS INT) END AS CHAR_OCTET_LENGTH,										C.COLUMNNUMBER AS ORDINAL_POSITION, CAST ((CASE WHEN C.COLUMNDATATYPE.isNullable() THEN 'YES' ELSE 'NO' END) AS VARCHAR(128)) AS IS_NULLABLE, CAST (NULL AS VARCHAR(128)) AS SCOPE_CATALOG, CAST (NULL AS VARCHAR(128)) AS SCOPE_SCHEMA, CAST (NULL AS VARCHAR(128)) AS SCOPE_TABLE, CAST (NULL AS SMALLINT) AS SOURCE_DATA_TYPE, CAST ((CASE WHEN (AUTOINCREMENTINC is not NULL) THEN 'YES' ELSE 'NO' END) AS VARCHAR(128)) AS IS_AUTOINCREMENT, CAST ((CASE WHEN (C.COLUMNDEFAULT IS NOT NULL AND C.COLUMNDEFAULT.toString().startsWith( 'GENERATED ALWAYS AS' ) ) THEN 'YES' ELSE  'NO' END) AS VARCHAR(128)) AS IS_GENERATEDCOLUMN, 										CAST (NULL AS VARCHAR(128)) AS SCOPE_CATLOG FROM SYS.SYSSCHEMAS S, SYS.SYSTABLES T, SYS.SYSCOLUMNS C WHERE C.REFERENCEID = T.TABLEID AND S.SCHEMAID = T.SCHEMAID AND ((1=1) OR ? IS NOT NULL) AND (S.SCHEMANAME LIKE ?) AND (T.TABLENAME LIKE ?) AND (C.COLUMNNAME LIKE ?) ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION�
1(	�7�&$8000000d-00d0-fd77-3ed8-000a0a0b1900
6
<��Wu
	
&$82080041-015a-84fb-0722-00000c404850getIndexInfo&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S

EPNSELECT CAST ('' AS VARCHAR(128)) AS TABLE_CAT, S.SCHEMANAME AS TABLE_SCHEM, T.TABLENAME AS TABLE_NAME, (CASE WHEN CONGLOMS.DESCRIPTOR.isUnique() OR CONGLOMS.DESCRIPTOR.isUniqueDeferrable() THEN FALSE ELSE TRUE END) AS NON_UNIQUE, CAST ('' AS VARCHAR(128)) AS INDEX_QUALIFIER, CONGLOMS.CONGLOMERATENAME AS INDEX_NAME, java.sql.DatabaseMetaData::tableIndexOther AS TYPE, CAST (CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER) AS SMALLINT) AS ORDINAL_POSITION, COLS.COLUMNNAME AS COLUMN_NAME, CASE WHEN CONGLOMS.DESCRIPTOR.isAscending( CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER)) THEN 'A' ELSE 'D' END AS ASC_OR_DESC, CAST(NULL AS BIGINT) AS CARDINALITY, CAST(NULL AS BIGINT) AS PAGES, CAST(NULL AS VARCHAR(128)) AS FILTER_CONDITION FROM SYS.SYSSCHEMAS S, SYS.SYSTABLES T, SYS.SYSCONGLOMERATES CONGLOMS, SYS.SYSCOLUMNS COLS WHERE T.TABLEID = CONGLOMS.TABLEID AND T.TABLEID = COLS.REFERENCEID AND T.SCHEMAID = S.SCHEMAID AND CONGLOMS.ISINDEX AND (CASE WHEN CONGLOMS.DESCRIPTOR IS NOT NULL THEN CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER) ELSE 0 END) <> 0  AND ((1=1) OR ? IS NOT NULL) AND S.SCHEMANAME LIKE ? AND T.TABLENAME=? AND ( CASE WHEN ? THEN (CONGLOMS.DESCRIPTOR.isUnique() OR CONGLOMS.DESCRIPTOR.isUniqueDeferrable()) ELSE (1=1) END) AND ((1=1) OR ?<>0) ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION�
1)-[�@&$8000000d-00d0-fd77-3ed8-000a0a0b1900
>
&$8a184042-015a-84fb-0722-00000c404850,*odbc_getBestRowIdentifierPrimaryKeyColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
GtrSELECT JDBC_SUBQUERY.SCOPE AS SCOPE, JDBC_SUBQUERY.COLUMN_NAME AS COLUMN_NAME, CAST (JDBC_SUBQUERY.DATA_TYPE AS SMALLINT) AS DATA_TYPE, JDBC_SUBQUERY.TYPE_NAME AS TYPE_NAME, JDBC_SUBQUERY.COLUMN_SIZE AS COLUMN_SIZE, JDBC_SUBQUERY.COL_MAX_WIDTH_IN_BYTES AS BUFFER_LENGTH, CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::DATE)) THEN CAST (NULL AS SMALLINT) ELSE JDBC_SUBQUERY.DECIMAL_DIGITS END AS DECIMAL_DIGITS, JDBC_SUBQUERY.PSEUDO_COLUMN AS PSEUDO_COLUMN FROM ( SELECT CAST (java.sql.DatabaseMetaData::bestRowSession AS SMALLINT) AS SCOPE, COLS.COLUMNNAME AS COLUMN_NAME, COLS.COLUMNDATATYPE.getJDBCTypeId() AS DATA_TYPE, CAST (COLS.COLUMNDATATYPE.getTypeName() AS VARCHAR(128)) AS TYPE_NAME, COLS.COLUMNDATATYPE.getMaximumWidth() AS COLUMN_SIZE, CAST (NULL AS INT) AS BUFFER_LENGTH, CAST ((CASE WHEN (COLS.COLUMNDATATYPE.getJDBCTypeId() IN ( java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN COLS.COLUMNDATATYPE.getPrecision() ELSE CAST (NULL AS SMALLINT) END) AS SMALLINT) AS DECIMAL_DIGITS, CAST (java.sql.DatabaseMetaData::bestRowNotPseudo AS SMALLINT) AS PSEUDO_COLUMN, COLS.COLUMNDATATYPE.getMaximumWidthInBytes() AS COL_MAX_WIDTH_IN_BYTES FROM SYS.SYSSCHEMAS SCHEMAS, SYS.SYSTABLES TABS, SYS.SYSCONSTRAINTS cons, SYS.SYSKEYS keys, SYS.SYSCONGLOMERATES CONGLOMS, SYS.SYSCOLUMNS COLS WHERE TABS.TABLEID = conS.TABLEID AND TABS.TABLEID = COLS.REFERENCEID AND SCHEMAS.SCHEMAID = TABS.SCHEMAID AND conS.CONSTRAINTID = ? AND KEYS.CONSTRAINTID = ? AND conS.CONSTRAINTID = KEYS.CONSTRAINTID AND TABS.TABLEID = CONGLOMS.TABLEID AND KEYS.CONGLOMERATEID = CONGLOMS.CONGLOMERATEID AND (CASE WHEN CONGLOMS.DESCRIPTOR IS NOT NULL THEN CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER) ELSE 0 END) <> 0 ) JDBC_SUBQUERY
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


:.<����}u
	
&$a228c043-015a-84fb-0722-00000c404850
getSuperTypes&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
A 
SELECT CAST(NULL AS VARCHAR(128)) AS TYPE_CAT, CAST(NULL AS VARCHAR(128)) AS TYPE_SCHEM, VARCHAR('', 128) AS TYPE_NAME, CAST(NULL AS VARCHAR(128)) AS SUPERTYPE_CAT, CAST(NULL AS VARCHAR(128)) AS SUPERTYPE_SCHEM, VARCHAR('', 128) AS SUPERTYPE_NAME FROM SYSIBM.SYSDUMMY1 WHERE 1=0 WITH UR
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$da398044-015a-84fb-0722-00000c404850+)odbc_getBestRowIdentifierUniqueKeyColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
G��SELECT JDBC_SUBQUERY.SCOPE AS SCOPE, JDBC_SUBQUERY.COLUMN_NAME AS COLUMN_NAME, CAST (JDBC_SUBQUERY.DATA_TYPE AS SMALLINT) AS DATA_TYPE, JDBC_SUBQUERY.TYPE_NAME AS TYPE_NAME, JDBC_SUBQUERY.COLUMN_SIZE AS COLUMN_SIZE, JDBC_SUBQUERY.COL_MAX_WIDTH_IN_BYTES AS BUFFER_LENGTH, CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::DATE)) THEN CAST (NULL AS SMALLINT) ELSE JDBC_SUBQUERY.DECIMAL_DIGITS END AS DECIMAL_DIGITS, JDBC_SUBQUERY.PSEUDO_COLUMN AS PSEUDO_COLUMN FROM ( SELECT CAST (java.sql.DatabaseMetaData::bestRowSession AS SMALLINT) AS SCOPE, COLS.COLUMNNAME AS COLUMN_NAME, COLS.COLUMNDATATYPE.getJDBCTypeId() AS DATA_TYPE, CAST (COLS.COLUMNDATATYPE.getTypeName() AS VARCHAR(128)) AS TYPE_NAME, COLS.COLUMNDATATYPE.getMaximumWidth() AS COLUMN_SIZE, CAST (NULL AS INT) AS BUFFER_LENGTH, CAST ((CASE WHEN (COLS.COLUMNDATATYPE.getJDBCTypeId() IN ( java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN COLS.COLUMNDATATYPE.getPrecision() ELSE CAST (NULL AS SMALLINT) END) AS SMALLINT) AS DECIMAL_DIGITS, CAST (java.sql.DatabaseMetaData::bestRowNotPseudo AS SMALLINT) AS PSEUDO_COLUMN, COLS.COLUMNDATATYPE.getMaximumWidthInBytes() AS COL_MAX_WIDTH_IN_BYTES FROM SYS.SYSSCHEMAS SCHEMAS, SYS.SYSTABLES TABS, SYS.SYSCONSTRAINTS cons, SYS.SYSKEYS keys, SYS.SYSCONGLOMERATES CONGLOMS, SYS.SYSCOLUMNS COLS WHERE TABS.TABLEID = conS.TABLEID AND TABS.TABLEID = COLS.REFERENCEID AND SCHEMAS.SCHEMAID = TABS.SCHEMAID AND conS.CONSTRAINTID = ? AND KEYS.CONSTRAINTID = ? AND conS.CONSTRAINTID = KEYS.CONSTRAINTID AND TABS.TABLEID = CONGLOMS.TABLEID AND KEYS.CONGLOMERATEID = CONGLOMS.CONGLOMERATEID AND (CASE WHEN CONGLOMS.DESCRIPTOR IS NOT NULL THEN CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER) ELSE 0 END) > 0 AND (?<>0 or not COLS.COLUMNDATATYPE.isNullable() ) ) JDBC_SUBQUERY
&$8000000d-00d0-fd77-3ed8-000a0a0b1900



�`<
����u


&$424a8045-015a-84fb-0722-00000c404850'%getBestRowIdentifierPrimaryKeyColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
EECSELECT CAST (java.sql.DatabaseMetaData::bestRowSession AS SMALLINT) AS SCOPE, COLS.COLUMNNAME AS COLUMN_NAME, COLS.COLUMNDATATYPE.getJDBCTypeId() AS DATA_TYPE, CAST (COLS.COLUMNDATATYPE.getTypeName() AS VARCHAR(128)) AS TYPE_NAME, COLS.COLUMNDATATYPE.getMaximumWidth() AS COLUMN_SIZE, CAST (NULL AS INT) AS BUFFER_LENGTH, CAST ((CASE WHEN (COLS.COLUMNDATATYPE.getJDBCTypeId() IN ( java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN COLS.COLUMNDATATYPE.getPrecision() ELSE CAST (NULL AS SMALLINT) END) AS SMALLINT) AS DECIMAL_DIGITS, CAST (java.sql.DatabaseMetaData::bestRowNotPseudo AS SMALLINT) AS PSEUDO_COLUMN FROM SYS.SYSSCHEMAS SCHEMAS, SYS.SYSTABLES TABS, SYS.SYSCONSTRAINTS cons, SYS.SYSKEYS keys, SYS.SYSCONGLOMERATES CONGLOMS, SYS.SYSCOLUMNS COLS WHERE TABS.TABLEID = conS.TABLEID AND TABS.TABLEID = COLS.REFERENCEID AND SCHEMAS.SCHEMAID = TABS.SCHEMAID AND conS.CONSTRAINTID = ? AND KEYS.CONSTRAINTID = ? AND conS.CONSTRAINTID = KEYS.CONSTRAINTID AND TABS.TABLEID = CONGLOMS.TABLEID AND KEYS.CONGLOMERATEID = CONGLOMS.CONGLOMERATEID AND (CASE WHEN CONGLOMS.DESCRIPTOR IS NOT NULL THEN CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER) ELSE 0 END) <> 0
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$ea5bc046-015a-84fb-0722-00000c404850
getProcedures&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
B;9SELECT CAST ('' AS VARCHAR(128)) AS PROCEDURE_CAT, SCHEMANAME AS PROCEDURE_SCHEM, ALIAS AS PROCEDURE_NAME, CAST (NULL AS INT) AS RESERVED1, CAST (NULL AS INT) AS RESERVED2, CAST (NULL AS INT) AS RESERVED3, CAST ((JAVACLASSNAME||'.'|| ALIASINFO->getMethodName()) AS VARCHAR(32672)) AS REMARKS, CAST (java.sql.DatabaseMetaData::procedureNoResult AS SMALLINT) AS PROCEDURE_TYPE FROM SYS.SYSALIASES, SYS.SYSSCHEMAS WHERE ((1=1) OR ? IS NOT NULL) AND (ALIASTYPE = 'P' AND SCHEMANAME LIKE ?) AND SYS.SYSALIASES.SCHEMAID = SYS.SYSSCHEMAS.SCHEMAID AND ALIAS LIKE ? ORDER BY 2,3
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$e26d4047-015a-84fb-0722-00000c404850
getCatalogs&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
@JHSELECT TABLE_CAT FROM ( VALUES ('') ) AS CATALOGS(TABLE_CAT) WHERE (1=0)
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


	�7�<�R}�u


&$3a7f0048-015a-84fb-0722-00000c404850getImportedKeys&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S

C�
1*!˻�&$8000000d-00d0-fd77-3ed8-000a0a0b1900
E
&$02910049-015a-84fb-0722-00000c404850!getBestRowIdentifierUniqueIndex&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
A�
�SELECT IDX.CONGLOMERATENUMBER, IDX.DESCRIPTOR.numberOfOrderedColumns() AS NUMCOLS FROM SYS.SYSSCHEMAS SCHEMAS, SYS.SYSTABLES TABS, SYS.SYSCONGLOMERATES IDX WHERE SCHEMAS.SCHEMAID = TABS.SCHEMAID and not IDX.ISCONSTRAINT AND TABS.TABLEID = IDX.TABLEID  AND (CASE WHEN IDX.DESCRIPTOR IS NULL THEN (1=0) ELSE (IDX.DESCRIPTOR.isUnique() OR IDX.DESCRIPTOR.isUniqueDeferrable()) END)  AND ((1=1) OR ? IS NOT NULL) AND (SCHEMAS.SCHEMANAME LIKE ?) AND (TABS.TABLENAME=?) ORDER BY NUMCOLS
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$4aa3404a-015a-84fb-0722-00000c404850(&getBestRowIdentifierUniqueIndexColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
D��SELECT CAST (java.sql.DatabaseMetaData::bestRowSession AS SMALLINT) AS SCOPE, COLS.COLUMNNAME AS COLUMN_NAME, COLS.COLUMNDATATYPE.getJDBCTypeId() AS DATA_TYPE, CAST (COLS.COLUMNDATATYPE.getTypeName() AS VARCHAR(128)) AS TYPE_NAME, COLS.COLUMNDATATYPE.getMaximumWidth() AS COLUMN_SIZE, CAST (NULL AS INT) AS BUFFER_LENGTH, CAST ((CASE WHEN (COLS.COLUMNDATATYPE.getJDBCTypeId() IN ( java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN COLS.COLUMNDATATYPE.getPrecision() ELSE CAST (NULL AS SMALLINT) END) AS SMALLINT) AS DECIMAL_DIGITS, CAST (java.sql.DatabaseMetaData::bestRowNotPseudo AS SMALLINT) AS PSEUDO_COLUMN FROM SYS.SYSSCHEMAS SCHEMAS, SYS.SYSTABLES TABS, SYS.SYSCONGLOMERATES IDX, SYS.SYSCOLUMNS COLS WHERE TABS.TABLEID = COLS.REFERENCEID and SCHEMAS.SCHEMAID = TABS.SCHEMAID AND TABS.TABLEID = IDX.TABLEID and IDX.CONGLOMERATENUMBER = ? AND (CASE WHEN IDX.DESCRIPTOR IS NOT NULL THEN IDX.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER) ELSE 0 END) > 0 AND (?<>0 or not COLS.COLUMNDATATYPE.isNullable() )
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


^��<�L´u


O��SELECT CAST ('' AS VARCHAR(128)) AS PKTABLE_CAT, S.SCHEMANAME AS PKTABLE_SCHEM, TABLENAME AS PKTABLE_NAME, COLS.COLUMNNAME AS PKCOLUMN_NAME, CAST ('' AS VARCHAR(128)) AS FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, FKCOLUMN_NAME, CAST (CONGLOMS.DESCRIPTOR.getKeyColumnPosition( COLS.COLUMNNUMBER) AS SMALLINT) AS KEY_SEQ, CAST ((CASE WHEN FK_UPDATERULE='S' THEN java.sql.DatabaseMetaData::importedKeyRestrict ELSE  (CASE WHEN FK_UPDATERULE='R' THEN java.sql.DatabaseMetaData::importedKeyNoAction ELSE java.sql.DatabaseMetaData::importedKeyNoAction END) END)  AS SMALLINT) AS UPDATE_RULE, CAST ((CASE WHEN FK_DELETERULE='S' THEN java.sql.DatabaseMetaData::importedKeyRestrict ELSE  (CASE WHEN FK_DELETERULE='R' THEN java.sql.DatabaseMetaData::importedKeyNoAction ELSE (CASE WHEN FK_DELETERULE='C' THEN java.sql.DatabaseMetaData::importedKeyCascade ELSE (CASE WHEN FK_DELETERULE='U' THEN java.sql.DatabaseMetaData::importedKeySetNull ELSE java.sql.DatabaseMetaData::importedKeyNoAction END) END) END) END)  AS SMALLINT) AS DELETE_RULE, FK_NAME, CONSTRAINTNAME AS PK_NAME, CAST ( (CASE WHEN DEFERREDSTATE = 'E'THEN java.sql.DatabaseMetaData::importedKeyNotDeferrable ELSE ( CASE WHEN DEFERREDSTATE = 'i'THEN java.sql.DatabaseMetaData::importedKeyInitiallyImmediate ELSE java.sql.DatabaseMetaData::importedKeyInitiallyDeferred END) END) AS SMALLINT) AS DEFERRABILITY FROM --DERBY-PROPERTIES joinOrder=FIXED 
(SELECT F2.keyCONSTRAINTID AS FK_ID, FKTB_SCHEMA AS FKTABLE_SCHEM, FKTB_NAME AS FKTABLE_NAME, COLS2.COLUMNNAME AS FKCOLUMN_NAME, CONGLOMS2.DESCRIPTOR.getKeyColumnPosition( COLS2.COLUMNNUMBER) AS KEY_SEQ, C2.CONSTRAINTNAME AS FK_NAME, C2.STATE as DEFERREDSTATE, F2.DELETERULE AS FK_UPDATERULE, F2.DELETERULE AS FK_DELETERULE FROM --DERBY-PROPERTIES joinOrder=FIXED 
(SELECT T2.TABLEID AS FKTB_ID, S2.SCHEMANAME AS FKTB_SCHEMA, T2.TABLENAME AS FKTB_NAME FROM  SYS.SYSTABLES T2 --DERBY-PROPERTIES index = 'SYSTABLES_INDEX1' 
, SYS.SYSSCHEMAS S2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSSCHEMAS_INDEX1' 
WHERE ((1=1) OR ? IS NOT NULL) AND S2.SCHEMANAME LIKE ? AND T2.TABLENAME=? AND S2.SCHEMAID = T2.SCHEMAID ) AS FKTB (FKTB_ID, FKTB_SCHEMA, FKTB_NAME), SYS.SYSCONSTRAINTS c2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCONSTRAINTS_INDEX3' 
, SYS.SYSFOREIGNKEYS F2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSFOREIGNKEYS_INDEX1' 
, SYS.SYSCONGLOMERATES CONGLOMS2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCONGLOMERATES_INDEX1' 
, SYS.SYSCOLUMNS COLS2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index =  'SYSCOLUMNS_INDEX1' 
WHERE FKTB.FKTB_ID = C2.TABLEID AND F2.CONSTRAINTID = C2.CONSTRAINTID AND FKTB.FKTB_ID = COLS2.REFERENCEID AND (CASE WHEN CONGLOMS2.DESCRIPTOR IS NOT NULL THEN CONGLOMS2.DESCRIPTOR.getKeyColumnPosition( COLS2.COLUMNNUMBER) ELSE 0 END) <> 0 AND F2.CONGLOMERATEID = CONGLOMS2.CONGLOMERATEID ) AS FKINFO(FK_ID, FKTABLE_SCHEM, FKTABLE_NAME, FKCOLUMN_NAME, KEY_SEQ, FK_NAME, DEFERREDSTATE, FK_UPDATERULE, FK_DELETERULE), SYS.SYSCONSTRAINTS c --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCONSTRAINTS_INDEX1' 
, SYS.SYSTABLES T --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSTABLES_INDEX2' 
, SYS.SYSSCHEMAS S --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSSCHEMAS_INDEX2' 
, SYS.SYSKEYS K --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSKEYS_INDEX1' 
, SYS.SYSCONGLOMERATES CONGLOMS --DERBY-PROPERTIES joinStrategy = NESTEDLOOP, index = 'SYSCONGLOMERATES_INDEX1' 
, SYS.SYSCOLUMNS COLS --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCOLUMNS_INDEX1' 
WHERE T.TABLEID = C.TABLEID  AND C.CONSTRAINTID = FKINFO.FK_ID  AND FKINFO.KEY_SEQ = CONGLOMS.DESCRIPTOR.getKeyColumnPosition(  COLS.COLUMNNUMBER) AND S.SCHEMAID = T.SCHEMAID AND K.CONSTRAINTID = C.CONSTRAINTID AND (CASE WHEN CONGLOMS.DESCRIPTOR IS NOT NULL THEN CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER) ELSE 0 END) <> 0  AND K.CONGLOMERATEID = CONGLOMS.CONGLOMERATEID  AND C.TABLEID = COLS.REFERENCEID  ORDER BY PKT<�!n��u



8ABLE_CAT,  PKTABLE_SCHEM, PKTABLE_NAME, PK_NAME, KEY_SEQ<=F���u
	
&$22b5c04b-015a-84fb-0722-00000c404850odbc_getProcedureColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900
S
M
�SELECT JDBC_SUBQUERY.PROCEDURE_CAT AS PROCEDURE_CAT, JDBC_SUBQUERY.PROCEDURE_SCHEM AS PROCEDURE_SCHEM, JDBC_SUBQUERY.PROCEDURE_NAME AS PROCEDURE_NAME, JDBC_SUBQUERY.COLUMN_NAME AS COLUMN_NAME, JDBC_SUBQUERY.COLUMN_TYPE AS COLUMN_TYPE, CAST (JDBC_SUBQUERY.DATA_TYPE AS SMALLINT) AS DATA_TYPE, JDBC_SUBQUERY.TYPE_NAME AS TYPE_NAME, JDBC_SUBQUERY.COLUMN_SIZE AS COLUMN_SIZE, JDBC_SUBQUERY.BUFFER_LENGTH AS BUFFER_LENGTH, CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::DATE)) THEN CAST (NULL AS SMALLINT) ELSE JDBC_SUBQUERY.DECIMAL_DIGITS END AS DECIMAL_DIGITS, CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN CAST (2 AS SMALLINT) ELSE JDBC_SUBQUERY.NUM_PREC_RADIX END AS NUM_PREC_RADIX, JDBC_SUBQUERY.NULLABLE AS NULLABLE, JDBC_SUBQUERY.REMARKS AS REMARKS, CAST (NULL AS VARCHAR(254)) AS COLUMN_DEF, CAST ((CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN 9 ELSE JDBC_SUBQUERY.DATA_TYPE END) AS SMALLINT) AS SQL_DATA_TYPE, CAST ((CASE WHEN (JDBC_SUBQUERY.DATA_TYPE = java.sql.Types::DATE) THEN 1 ELSE (CASE WHEN (JDBC_SUBQUERY.DATA_TYPE = java.sql.Types::TIME) THEN 2 ELSE (CASE WHEN (JDBC_SUBQUERY.DATA_TYPE = java.sql.Types::TIMESTAMP) THEN 3 ELSE CAST (NULL AS SMALLINT) END ) END ) END) AS SMALLINT) AS SQL_DATETIME_SUB, CASE WHEN (JDBC_SUBQUERY.DATA_TYPE IN (java.sql.Types::CHAR, java.sql.Types::VARCHAR, java.sql.Types::BINARY, java.sql.Types::VARBINARY)) THEN JDBC_SUBQUERY.BUFFER_LENGTH ELSE CAST (NULL AS INT) END AS CHAR_OCTET_LENGTH, CAST ((JDBC_SUBQUERY.PARAMETER_ID + 1) AS INT) AS ORDINAL_POSITION, CAST ((CASE WHEN (JDBC_SUBQUERY.NULLABLE IN (java.sql.DatabaseMetaData::procedureNullable)) THEN 'YES' ELSE 'NO' END) AS VARCHAR(128)) AS IS_NULLABLE, JDBC_SUBQUERY.METHOD_ID AS METHOD_ID, JDBC_SUBQUERY.PARAMETER_ID AS PARAMETER_ID FROM ( SELECT CAST (NULL AS VARCHAR(128)) AS PROCEDURE_CAT, SCHEMANAME AS PROCEDURE_SCHEM, A.ALIAS AS PROCEDURE_NAME, V."COLUMN_NAME" AS COLUMN_NAME, V."COLUMN_TYPE" AS COLUMN_TYPE, V."DATA_TYPE" AS DATA_TYPE, V."TYPE_NAME" AS TYPE_NAME, V."PRECISION" AS COLUMN_SIZE, V."LENGTH" AS BUFFER_LENGTH, CASE WHEN (V."DATA_TYPE" IN (java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN V."SCALE" ELSE CAST (NULL AS SMALLINT) END AS DECIMAL_DIGITS, CASE WHEN (V."DATA_TYPE" IN (java.sql.Types::DECIMAL, java.sql.Types::NUMERIC, java.sql.Types::INTEGER, java.sql.Types::SMALLINT, java.sql.Types::TINYINT, java.sql.Types::BIGINT, java.sql.Types::DOUBLE, java.sql.Types::FLOAT, java.sql.Types::REAL, java.sql.Types::DATE, java.sql.Types::TIME, java.sql.Types::TIMESTAMP)) THEN V."RADIX" ELSE CAST (NULL AS SMALLINT) END AS NUM_PREC_RADIX, V."NULLABLE" AS NULLABLE, V."REMARKS" AS REMARKS, V."METHOD_ID" AS METHOD_ID, V."PARAMETER_ID" AS PARAMETER_ID FROM SYS.SYSALIASES A, SYS.SYSSCHEMAS, NEW org.apache.derby.catalog.GetProcedureColumns(A.ALIASINFO, A.ALIASTYPE) V WHERE ALIASTYPE = 'P' AND SCHEMANAME LIKE ? AND A.SCHEMAID = SYS.SYSSCHEMAS.SCHEMAID AND A.ALIAS LIKE ? AND V."COLUMN_NAME" LIKE ? ) JDBC_SUBQUERY ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME, METHOD_ID, PARAMETER_ID
&$8000000d-00d0-fd77-3ed8-000a0a0b1900


&$9ac8804c-015a-84fb-0722-00000c404850	SQLUDTS&$c013800d-00f8-5b53-28a9-00000019ed88
S
$"CALL SYSIBM.SQLUDTS(?, ?, ?, ?, ?)
&$c013800d-00f8-5b53-28a9-00000019ed88



��<
����u


&$c2db804d-015a-84fb-0722-00000c404850
METADATA&$c013800d-00f8-5b53-28a9-00000019ed88
S
M
SELECT	M->allProceduresAreCallable(),	M->allTablesAreSelectable(),	M->nullsAreSortedHigh(),	M->nullsAreSortedLow(),	M->nullsAreSortedAtStart(),	M->nullsAreSortedAtEnd(),	M->usesLocalFiles(),	M->usesLocalFilePerTable(),	M->storesUpperCaseIdentifiers(),	M->storesLowerCaseIdentifiers(),	M->storesMixedCaseIdentifiers(),	M->storesUpperCaseQuotedIdentifiers(),	M->storesLowerCaseQuotedIdentifiers(),	M->storesMixedCaseQuotedIdentifiers(),	M->getSQLKeywords(),	M->getNumericFunctions(),	M->getStringFunctions(),	M->getSystemFunctions(),	M->getTimeDateFunctions(),	M->getSearchStringEscape(),	M->getExtraNameCharacters(),	M->supportsAlterTableWithAddColumn(),	M->supportsAlterTableWithDropColumn(),	M->supportsConvert(),	'1', M->supportsDifferentTableCorrelationNames(),	M->supportsExpressionsInOrderBy(),	M->supportsOrderByUnrelated(),	M->supportsGroupBy(),	M->supportsGroupByUnrelated(),		M->supportsGroupByBeyondSelect(),	M->supportsMultipleResultSets(),	M->supportsMultipleTransactions(),	M->supportsCoreSQLGrammar(),	M->supportsExtendedSQLGrammar(),	M->supportsANSI92IntermediateSQL(),	M->supportsANSI92FullSQL(),	M->supportsIntegrityEnhancementFacility(),	M->supportsOuterJoins(),	M->supportsFullOuterJoins(),	M->supportsLimitedOuterJoins(),	M->getSchemaTerm(),	M->getProcedureTerm(),	M->getCatalogTerm(),	M->isCatalogAtStart(),	M->getCatalogSeparator(),	M->supportsSchemasInDataManipulation(),	M->supportsSchemasInProcedureCalls(),	M->supportsSchemasInTableDefinitions(),	M->supportsSchemasInIndexDefinitions(),	M->supportsSchemasInPrivilegeDefinitions(),	M->supportsCatalogsInDataManipulation(),	M->supportsCatalogsInProcedureCalls(),	M->supportsCatalogsInTableDefinitions(),	M->supportsCatalogsInIndexDefinitions(),	M->supportsCatalogsInPrivilegeDefinitions(),	M->supportsPositionedDelete(),	M->supportsPositionedUpdate(),	M->supportsSelectForUpdate(),	M->supportsStoredProcedures(),	M->supportsSubqueriesInComparisons(),	M->supportsUnion(),	M->supportsUnionAll(),	M->supportsOpenCursorsAcrossCommit(),	M->supportsOpenCursorsAcrossRollback(),	M->supportsOpenStatementsAcrossCommit(),	M->supportsOpenStatementsAcrossRollback(),	M->getMaxBinaryLiteralLength(),	M->getMaxCharLiteralLength(),	M->getMaxColumnNameLength(),	M->getMaxColumnsInGroupBy(),	M->getMaxColumnsInIndex(),	M->getMaxColumnsInOrderBy(),	M->getMaxColumnsInSelect(),	M->getMaxColumnsInTable(),	M->getMaxConnections(),	M->getMaxCursorNameLength(),	M->getMaxIndexLength(),	M->getMaxSchemaNameLength(),	M->getMaxProcedureNameLength(),	M->getMaxCatalogNameLength(),	M->getMaxRowSize(),	M->doesMaxRowSizeIncludeBlobs(),	M->getMaxStatementLength(),	M->getMaxStatements(),	M->getMaxTableNameLength(),	M->getMaxTablesInSelect(),	M->getMaxUserNameLength(),	M->getDefaultTransactionIsolation(),	M->supportsTransactions(),	'1,2,4,8' ,	M->supportsDataDefinitionAndDataManipulationTransactions(),	M->supportsDataManipulationTransactionsOnly(),	M->dataDefinitionCausesTransactionCommit(),	M->dataDefinitionIgnoredInTransactions(), 	(cast (RTRIM(CAST(java.sql.ResultSet::TYPE_FORWARD_ONLY as CHAR(10))) AS VARCHAR(10)) || (',') || (cast (RTRIM(CAST(java.sql.ResultSet::TYPE_SCROLL_INSENSITIVE AS CHAR(10))) as VARCHAR(10)))), '1003,1007,1008;1004,1007,1008;1005', '','','','1003','1003','1003','','','',M->supportsBatchUpdates()from (values(getCurrentConnection()->getMetaData())) as DBMetaData(M)
&$c013800d-00f8-5b53-28a9-00000019ed88


&$aaeec04e-015a-84fb-0722-00000c404850
SQLSTATISTICS&$c013800d-00f8-5b53-28a9-00000019ed88
S
-+CALL SYSIBM.SQLSTATISTICS(?, ?, ?, ?, ?, ?)
&$c013800d-00f8-5b53-28a9-00000019ed88


&$6302404f-015a-84fb-0722-00000c404850
SQLCOLUMNS&$c013800d-00f8-5b53-28a9-00000019ed88
S
'%CALL SYSIBM.SQLCOLUMNS(?, ?, ?, ?, ?)
&$c013800d-00f8-5b53-28a9-00000019ed88


��
��<
��*��u


&$fb160050-015a-84fb-0722-00000c404850
GETCATALOGS&$c013800d-00f8-5b53-28a9-00000019ed88
S
86CALL SYSIBM.SQLTABLES('', '', '', '', 'GETCATALOGS=1')
&$c013800d-00f8-5b53-28a9-00000019ed88


&$832a0051-015a-84fb-0722-00000c404850
SQLPROCEDURES&$c013800d-00f8-5b53-28a9-00000019ed88
S
'%CALL SYSIBM.SQLPROCEDURES(?, ?, ?, ?)
&$c013800d-00f8-5b53-28a9-00000019ed88


&$0b3e4052-015a-84fb-0722-00000c404850	SQLTABLES&$c013800d-00f8-5b53-28a9-00000019ed88
S
&$CALL SYSIBM.SQLTABLES(?, ?, ?, ?, ?)
&$c013800d-00f8-5b53-28a9-00000019ed88


	&$a352c053-015a-84fb-0722-00000c404850SQLCOLPRIVILEGES&$c013800d-00f8-5b53-28a9-00000019ed88
S
-+CALL SYSIBM.SQLCOLPRIVILEGES(?, ?, ?, ?, ?)
&$c013800d-00f8-5b53-28a9-00000019ed88



&$5b678054-015a-84fb-0722-00000c404850
GETSCHEMAS&$c013800d-00f8-5b53-28a9-00000019ed88
S
75CALL SYSIBM.SQLTABLES('', '', '', '', 'GETSCHEMAS=1')
&$c013800d-00f8-5b53-28a9-00000019ed88


&$437c8055-015a-84fb-0722-00000c404850SQLFOREIGNKEYS&$c013800d-00f8-5b53-28a9-00000019ed88
S
1/CALL SYSIBM.SQLFOREIGNKEYS(?, ?, ?, ?, ?, ?, ?)
&$c013800d-00f8-5b53-28a9-00000019ed88


&$6b91c056-015a-84fb-0722-00000c404850SQLPROCEDURECOLS&$c013800d-00f8-5b53-28a9-00000019ed88
S
-+CALL SYSIBM.SQLPROCEDURECOLS(?, ?, ?, ?, ?)
&$c013800d-00f8-5b53-28a9-00000019ed88



&$e3a74057-015a-84fb-0722-00000c404850SQLSPECIALCOLUMNS&$c013800d-00f8-5b53-28a9-00000019ed88
S
42CALL SYSIBM.SQLSPECIALCOLUMNS(?, ?, ?, ?, ?, ?, ?)
&$c013800d-00f8-5b53-28a9-00000019ed88


&$bbbd0058-015a-84fb-0722-00000c404850
GETTABLETYPES&$c013800d-00f8-5b53-28a9-00000019ed88
S
:8CALL SYSIBM.SQLTABLES('', '', '', '', 'GETTABLETYPES=1')
&$c013800d-00f8-5b53-28a9-00000019ed88


&$03d30059-015a-84fb-0722-00000c404850SQLGETTYPEINFO&$c013800d-00f8-5b53-28a9-00000019ed88
S
" CALL SYSIBM.SQLGETTYPEINFO(?, ?)
&$c013800d-00f8-5b53-28a9-00000019ed88


&$cbe9405a-015a-84fb-0722-00000c404850SQLTABLEPRIVILEGES&$c013800d-00f8-5b53-28a9-00000019ed88
S
,*CALL SYSIBM.SQLTABLEPRIVILEGES(?, ?, ?, ?)
&$c013800d-00f8-5b53-28a9-00000019ed88


&$23ffc05b-015a-84fb-0722-00000c404850SQLPRIMARYKEYS&$c013800d-00f8-5b53-28a9-00000019ed88
S
(&CALL SYSIBM.SQLPRIMARYKEYS(?, ?, ?, ?)
&$c013800d-00f8-5b53-28a9-00000019ed88


��/�p�������,�\���
��
�<�'Xu



&$8000000d-00d0-fd77-3ed8-000a0a0b1900

<5��Hsu



O��
)�
SELECT

9
name
NUM_PREC_RADIX
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQL_DATETIME_SUB
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

SQL_DATA_TYPE
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

MAXIMUM_SCALE
type�SMALLINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

MINIMUM_SCALE
type�SMALLINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
LOCAL_TYPE_NAME
type�VARCHAR
�

	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
AUTO_INCREMENT
type�BOOLEAN



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
FIXED_PREC_SCALE
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
UNSIGNED_ATTRIBUTE
type�BOOLEAN



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name

SEARCHABLE
type�SMALLINT

	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
CASE_SENSITIVE
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
NULLABLE
type�SMALLINT

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

CREATE_PARAMS
type�VARCHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
LITERAL_SUFFIX
type�VARCHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
LITERAL_PREFIX
type�VARCHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
	PRECISION
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
	DATA_TYPE
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
	TYPE_NAME
type�VARCHAR
�

	columnPos
/

isAutoincrement
/
updatableByCursor
/
�

9
name
NUM_PREC_RADIX
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQL_DATETIME_SUB
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

SQL_DATA_TYPE
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

MAXIMUM_SCALE
type�SMALLINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

MINIMUM_SCALE
type�SMALLINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
LOCAL_TYPE_NAME
type�VARCHAR
�

	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
AUTO_INCREMENT
type�BOOLEAN



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
FIXED_PREC_SCALE
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
UNSIGNED_ATTRIBUTE
type�BOOLEAN



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name

SEARCHABLE
type�<�vz�8u



O�SMALLINT

	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
CASE_SENSITIVE
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
NULLABLE
type�SMALLINT

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

CREATE_PARAMS
type�VARCHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
LITERAL_SUFFIX
type�VARCHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
LITERAL_PREFIX
type�VARCHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
	PRECISION
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
	DATA_TYPE
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
	TYPE_NAME
type�VARCHAR
�

	columnPos
/

isAutoincrement
/
updatableByCursor
/�������������������������
����������������������ur[ZW� 9�]�xp�
	

��ur[ZW� 9�]�xp�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
t <���0`u



O�ype�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
!<�Ho!xu



O�type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1"<��%*�u



O�4
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLC#<��`�^u



O�ol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCo$<���cu



O�l1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
S%<�j��u



O�QLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name&<�SV"7u



O�
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
'<�2vu



O�name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

(<�+�\�u



O�9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/)<���u



O�

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCurs*<����u



O�or
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableBy+<�R��u



O�Cursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol15
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol14
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol13
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SQLCol12
type�BOOLEAN



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol11
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol10
type�BOOLEAN



	columnPos
/

isAutoincrement
/
updatab,<�
��u



O�leByCursor
/

9
name
SQLCol9
type�INTEGER


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol8
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol7
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol6
type�CHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol5
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol4
type�CHAR



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol3
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol2
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR

	columnPos
/

isAutoincrement
/
updatableByCursor
/
<org.apache.derby.exe.ac2e31c0abx015ax84fbx0722x00000c4048500
HQ����-
�
<org/apache/derby/exe/ac2e31c0abx015ax84fbx0722x00000c4048500

2org/apache/derby/impl/sql/execute/CursorActivation
<init>
()V

Code
postConstructor
createResultSet
'()Lorg/apache/derby/iapi/sql/ResultSet;
0org/apache/derby/impl/sql/execute/BaseActivation

setParameterValueSet
(IZ)V

reinit
throwIfMissingParms

getResultSetFactory
6()Lorg/apache/derby/iapi/sql/execute/ResultSetFactory;

e0
()Ljava/lang/Object;
+Lorg/apache/derby/iapi/sql/execute/ExecRow;	
getExecutionFactory
6()Lorg/apache/derby/iapi/sql/execute/ExecutionFactory; !
"
2org/apache/derby/iapi/sql/execute/ExecutionFactory$
getValueRow
.(I)Lorg/apache/derby/iapi/sql/execute/ExecRow;&'%(
BIGINT*
getDataValueFactory
0()Lorg/apache/derby/iapi/types/DataValueFactory;,-
.
,org/apache/derby/iapi/types/DataValueFactory0
getCharDataValue
n(Ljava/lang/String;Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue;2314
/org/apache/derby/iapi/types/DataValueDescriptor6
org/apache/derby/iapi/sql/Row8
	setColumn
5(ILorg/apache/derby/iapi/types/DataValueDescriptor;)V:;9<
getDataValue
](ILorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue;>?1@
getNullChar
\(Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue;BC1D
_(ZLorg/apache/derby/iapi/types/BooleanDataValue;)Lorg/apache/derby/iapi/types/BooleanDataValue;>F1G
-org/apache/derby/iapi/error/StandardExceptionI
java/lang/ExceptionK

Exceptions
7org/apache/derby/iapi/services/loader/GeneratedByteCodeO
	getMethod
K(Ljava/lang/String;)Lorg/apache/derby/iapi/services/loader/GeneratedMethod;QRPS?�
2org/apache/derby/iapi/sql/execute/ResultSetFactoryW
getRowResultSet
�(Lorg/apache/derby/iapi/sql/Activation;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;ZIDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;YZX[@
getNormalizeResultSet
k(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;IIDDZ)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;_`Xa
e1c	d
LONG VARCHAR FOR BIT DATAf
X'h

'j
getNullInteger
\(Lorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue;lm1nc
getUnionResultSet
�(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;IDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;qrXs@
e2w	x
VARCHAR () FOR BIT DATAz
length|w
e3	�
CHAR (-<�U��u



O�) FOR BIT DATA�@
e4�	�
LONG VARCHAR��@
e5�	�
CHAR��@@
e6�	�
NUMERIC�
precision,scale��
e7�	�
DECIMAL��@ 
e8�	�
INTEGER��@"
e9�	�
SMALLINT��@$
e10�	�
FLOAT�
	precision��@&
e11�	�
REAL��@(
e12�	�
DOUBLE��@*
e13�	�
VARCHAR��@,
e14�	�
BOOLEAN��@.@0
e15�	�
DATE�
DATE'��
e16�	�
TIME�
TIME'��@1@2
e17�	�
	TIMESTAMP�

TIMESTAMP'��
e18

	

OBJECT


@3
e19
		


BLOB
���
getNullBoolean
^(Lorg/apache/derby/iapi/types/BooleanDataValue;)Lorg/apache/derby/iapi/types/BooleanDataValue;

1

	@4
e20
	

CLOB

@5
e21
	

XML
!
@6
e22
getColumnFromRow
5(II)Lorg/apache/derby/iapi/types/DataValueDescriptor;
'
(

)
+org/apache/derby/iapi/types/StringDataValue
+
	notEquals
�(Lorg/apache/derby/iapi/types/DataValueDescriptor;Lorg/apache/derby/iapi/types/DataValueDescriptor;)Lorg/apache/derby/iapi/types/BooleanDataValue;
-
.7
/
,org/apache/derby/iapi/types/BooleanDataValue
1
equals
(Z)Z
3
4
2
5
getImmutable
0()Lorg/apache/derby/iapi/types/BooleanDataValue;
7
8
2
9
getParameter
4(I)Lorg/apache/derby/iapi/types/DataValueDescriptor;
;
<

=
+org/apache/derby/iapi/types/NumberDataValue
?
-Lorg/apache/derby/iapi/types/NumberDataValue;
&
A	
B
getNullShort
Dm1
E
setValue
4(Lorg/apache/derby/iapi/types/DataValueDescriptor;)V
G
H7
I
or
K

2
L
&
NULL
O
getProjectRestrictResultSet

%(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IIZZZLjava/lang/String;DD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;
Q
RX
S
e23
U	
V
e24
-Lorg/apache/derby/iapi/types/StringDataValue;
X
Y	
Z
e25
\
Y	
]
1org/apache/derby/iapi/types/VariableSizeDataValue
_
setWidth
(IIZ)V
a
b
`
c

 
e
ansiTrim
�(ILorg/apache/derby/iapi/types/StringDataValue;Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue;
g
h
,
i
e26
k
Y	
l
getNullVarchar
nC1
o
e27
q
Y	
r
e28
t
Y	
u
e29
w
Y	
x
e30
z
Y	
{
e31
}
Y	
~
e32
�
Y	
�
e33
�
Y	
�
e34
�
Y	
�
e35
�
A	
�
e36
�
A	
�
e37
�
Y	
�
e38
�
Y	
�
e39
�
Y	
�
e40
�
A	
�
e41
�
A	
�
U

getScrollable
()Z
�
�

�
getScrollInsensitiveResultSet
�(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Lorg/apache/derby/iapi/sql/Activation;IIZDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;
�
�X
�
)org/apache/derby/iapi/sql/execute/ExecRow
�
row
,[Lorg/apache/derby/iapi/sql/execute/ExecRow;
�
�	
�1*cw��������������


	


&
A
U
X
Y
\
Y
k
Y
q
Y
t
Y
w
Y
z
Y
}
Y
�
Y
�
Y
�
Y
�
A
�
A
�
Y
�
Y
�
Y
�
A
�
A

	

*��

M
J	�
�*�*�#�)*_�*�+*�/_
�5�7�=*��*�/_
�A�7�=*�*�/_
�A�7�=*�*�/_
�A�7�=*�*�/_
�H�7�=*�	*�/_
�A�7�=*�
*�/_
�H�7�=*�*�/_
�H�7�=*�*�/_
�H�7�=*�
*�/_
�A�7�=*�*�/_
�A�7�=*�
*�/_
�A�7�=*�#�)*_�e*�eg*�/_
�5�7�=*�e�*�/_
�A�7�=*�e�*�/_
�A�7�=*�ei*�/_
�5�7�=*�ek*�/_
�5�7�=*�e*�/_
�A�7�=*�e*�/_
�H�7�=*�e	*�/_
�A�7�=*�.<�'���u



O�e
*�/_
�H�7�=*�e*�/_
�H�7�=*�e*�/_
�H�7�=*�#�)*_�y*�y{*�/_
�5�7�=*�y�*�/_
�A�7�=*�y�*�/_
�A�7�=*�yi*�/_
�5�7�=*�yk*�/_
�5�7�=*�y}*�/_
�5�7�=*�y*�/_
�A�7�=*�y*�/_
�H�7�=*�y	*�/_
�A�7�=*�y
*�/_
�H�7�=*�y*�/_
�H�7�=*�y*�/_
�H�7�=*�#�)*_��*���*�/_
�5�7�=*���*�/_
�A�7�=*���*�/_
�A�7�=*��i*�/_
�5�7�=*��k*�/_
�5�7�=*��}*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*�#�)*_��*���*�/_
�5�7�=*��*�/_
�A�7�=*���*�/_
�A�7�=*��k*�/_
�5�7�=*��k*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*�#�)*_��*���*�/_
�5�7�=*��*�/_
�A�7�=*���*�/_
�A�7�=*��k*�/_
�5�7�=*��k*�/_
�5�7�=*��}*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*�#�)*_��*���*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�A�7�=*���*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*��
*�/_
�A�7�=*��*�/_
�A�7�=*��
*�/_
�A�7�=*�#�)*_��*���*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�A�7�=*���*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*��
*�/_
�A�7�=*��*�/_
�A�7�=*��
*�/_
�A�7�=*�#�)*_��*���*�/_
�5�7�=*��*�/_
�A�7�=*��
*�/_
�A�7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*��
*�/_
�A�7�=*��*�/_
�A�7�=*��
*�/_
�A�7�=*�#�)*_��*���*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�A�7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*��
*�/_
�A�7�=*��*�/_
�A�7�=*��
*�/_
�A�7�=*�#�)*_��*���*�/_
�5�7�=*��*�/_
�A�7�=*��4*�/_
�A�7�=*���*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�A�7�=*�#�)*_��*���*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�A�7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�A�7�=*�#�)*_��*���*�/_
�5�7�=*��*�/_
�A�7�=*��4*�/_
�A�7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�A�7�=*�#�)*_��*���*�/_
�5�7�=*��*�/_
�A�7�=*���*�/_
�A�7�=*��k*�/_
�5�7�=*��k*�/_
�5�7�=*��}*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*�#�)*_��*���*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�A/<��z�u



O��7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*�#�)*_��*���*�/_
�5�7�=*��[*�/_
�A�7�=*��
*�/_
�A�7�=*���*�/_
�5�7�=*��k*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*��
*�/_
�A�7�=*��*�/_
�A�7�=*��
*�/_
�A�7�=*�#�)*_��*���*�/_
�5�7�=*��\*�/_
�A�7�=*��*�/_
�A�7�=*���*�/_
�5�7�=*��k*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*��
*�/_
�A�7�=*��*�/_
�A�7�=*��
*�/_
�A�7�=*�#�)*_��*���*�/_
�5�7�=*��]*�/_
�A�7�=*��*�/_
�A�7�=*���*�/_
�5�7�=*��k*�/_
�5�7�=*��*�/_
�A�7�=*��*�/_
�H�7�=*��	*�/_
�A�7�=*��
*�/_
�H�7�=*��*�/_
�H�7�=*��*�/_
�H�7�=*��
*�/_
�A�7�=*��	*�/_
�A�7�=*��
*�/_
�A�7�=*�#�)*_�
*�

*�/_
�5�7�=*�
�*�/_
�A�7�=*�
*�/_
�A�7�=*�
*�/_
�H�7�=*�
	*�/_
�A�7�=*�

*�/_
�H�7�=*�
*�/_
�H�7�=*�
*�/_
�H�7�=*�#�)*_�
*�


*�/_
�5�7�=*�
�*�/_
�A�7�=*�

*�/_
�A�7�=*�
}*�/_
�5�7�=*�
*�/_
�A�7�=*�
*�/_
�H�7�=*�
	*�/_
�A�7�=*�
*�/_
�H�7�=*�#�)*_�
*�

*�/_
�5�7�=*�
�*�/_
�A�7�=*�

*�/_
�A�7�=*�
k*�/_
�5�7�=*�
k*�/_
�5�7�=*�
}*�/_
�5�7�=*�
*�/_
�A�7�=*�
*�/_
�H�7�=*�
	*�/_
�A�7�=*�
*�/_
�H�7�=*�#�)*_�
 *�
 
"*�/_
�5�7�=*�
 �*�/_
�A�7�=*�
 *�/_
�A�7�=*�
 *�/_
�H�7�=*�
 	*�/_
�A�7�=*�
 
*�/_
�H�7�=*�
 *�/_
�H�7�=*�
 *�/_
�H�7�=*�/
�
F*_�
C*�#�)*_�
W*�/
�E*_�
^*�/
�
p*_�
m*�/
�E*_�
v*�/
�
p*_�
y*�/
�
p*_�
*�/
�E*_�
�*�/
�
p*_�
�*�/
�
F*_�
�*�/
�
F*_�
�*�/
�E*_�
�*�/
�
p*_�
�*�/
�
F*_�
�*�/
�
F*_�
�*G�
�Z�
�W�M
J	�"
�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*�**N�TU�\	*�_]�b	*�**p�TU�\	]�t*�_u�b	*�**~�TU�\	*�_u�b	u�t*�**��TU�\	*�_��b	��t*�**��TU�\	*�_	��b	��t*�**��T U�\	*�_!
��b	��t*�_"��b	*�**��T#U�\	*�_$��b	��t*�**��T%U�\	*�_&
��b	��t*�**��T'U�\	*�_(��b	��t*�**��T)U�\	*�_*��b	
��t*�**��T+U�\	*�_,��b	��t*�**ȹT-U�\	*�_.��b	��t*�**йT/U�\	*�_0��b	
��t*�**عT1U�\	*�_2��b		��t*�**�T3U�\	*�_4��b	��t*�_5��b	*�**�T6U�\	*�_7��b	��t*�**��T8U�\	*�_9��b	��t*�_:��b	*�**
�T;U�\	*�_<��b	��t*�**
�T=U�\	*�_>
�b	
�t*�**
�T?U�\	*�_@
�b	
�t*�**
�TAU�\	*�_B
�b	
�t*�**
#�TCU�\	*�_D
$�b	
$�t*
N�T
E

P
$�
T
*
��TF

P
$�
T**�
�
$�
�
�M
J	0<��J}pu




N�

*��
MJL	W
K*�*�/
�E�7�=*�*�/
�E�7�=*�*�/
�E�7�=*��
cMJL	q
e*�e*�/
�E�7�=*�e
*�/
�o�7�=*�e*�/
�o�7�=*�e*�/
�o�7�=*�e�
wMJL	Y
M*�y
*�/
�o�7�=*�y*�/
�o�7�=*�y*�/
�o�7�=*�y�
MJL	Y
M*��
*�/
�o�7�=*��*�/
�o�7�=*��*�/
�o�7�=*���
�MJL	q
e*��*�/
�E�7�=*��
*�/
�o�7�=*��*�/
�o�7�=*��*�/
�o�7�=*���
�MJL	Y
M*��
*�/
�o�7�=*��*�/
�o�7�=*��*�/
�o�7�=*���
�MJL	?
3*��*�/
�E�7�=*��*�/
�E�7�=*���
�MJL	?
3*��*�/
�E�7�=*��*�/
�E�7�=*���
�MJL	W
K*��*�/
�E�7�=*��*�/
�E�7�=*��*�/
�E�7�=*���
�MJL	W
K*��*�/
�E�7�=*��*�/
�E�7�=*��*�/
�E�7�=*���
�MJL	o
c*��*�/
�E�7�=*��*�/
�E�7�=*��
*�/
�o�7�=*��*�/
�o�7�=*���
�MJL	�
{*��*�/
�E�7�=*��*�/
�E�7�=*��*�/
�E�7�=*��
*�/
�o�7�=*��*�/
�o�7�=*�Ű
�MJL	�
{*��*�/
�E�7�=*��*�/
�E�7�=*��*�/
�E�7�=*��
*�/
�o�7�=*��*�/
�o�7�=*�Ͱ
�MJL	Y
M*��
*�/
�o�7�=*��*�/
�o�7�=*��*�/
�o�7�=*�հ
�MJL	�
�*��*�/
�E�7�=*��*�/
�E�7�=*��*�/
�E�7�=*��
*�/
�o�7�=*��*�/
�o�7�=*��*�/
�o�7�=*�ݰ
�MJL	)
*��*�/
�E�7�=*��
�MJL	)
*��*�/
�E�7�=*��
�MJL	)
*��*�/
�E�7�=*���


MJL	�
�*�
*�/
�o�7�=*�
*�/
�E�7�=*�
*�/
�E�7�=*�
*�/
�E�7�=*�

*�/
�o�7�=*�
*�/
�o�7�=*�
*�/
�o�7�=*�
�

	MJL	�
�*�
*�/
�E�7�=*�
*�/
�E�7�=*�

*�/
�
�7�=*�
*�/
�
�7�=*�

*�/
�o�7�=*�
*�/
�o�7�=*�
*�/
�o�7�=*�
�

MJL	�
}*�

*�/
�
�7�=*�
*�/
�
�7�=*�

*�/
�o�7�=*�
*�/
�o�7�=*�
*�/
�o�7�=*�
�

MJL	�
�*�
 *�/
�o�7�=*�
 *�/
�E�7�=*�
 *�/
�E�7�=*�
 *�/
�E�7�=*�
 
*�/
�o�7�=*�
 *�/
�o�7�=*�
 *�/
�o�7�=*�
 �

&MJL	�
��*�/_
�5�7Y*�
*�
,�7_�
0Y�
6��
:
�Z*�/_
�A�7Y*�
>�
@*�
C_�
J*�
C�7_�
0Y�
6��
:
�*�/_
�H�
M�
M�

UMJL	�
�*�
W*E�
*�
,*�
^_�
J*�
^Y��
d
f*�/_
�5*�
[�
jY*_�
[*�
m_�
J*�
mY��
d�7�=*�
W*E�
*�
,*�
v_�
J*�
vY
�
d
f*�/_
�5*�
s�
jY*_�
s*�
y_�
J*�
yY
�
d�7�=*�
W*E�
*�
,
f*�/_
�5*�
|�
jY*_�
|*�
_�
J*�
Y
�
d�7�=*�
W*E�
*�
,*�
�_�
J*�
�Y�
d
f*�/_
�5*�
��
jY*_�
�*�
�_�
J*�
�Y�
d�7�=*�
W*E�
*�
@*�
�_�
J*�
��7�=*�
W	*E	�
*�
@*�
�_�
J*�
��7�=*�
W
*E�
*�
,*�
�_�
J*�
�Y��
d
f*�/_
�5*�
��
jY*_�
�*�
�_�
J*�
�Y��
d�7�=*�
W*E
�
*�
@*�
�_�
J*�
��7�=*�
W*E�
*�
@*�
�_�
J*�
��7�=*�
W*�/
�o�7�=*�
W*�/
�o�7�=*�
W�<��%�u



O��
)
�
SELECT


9
name
REF_GENERATION
type�VARCHAR
�

	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SELF_REFERENCING_COL_NAME
type�VARCHAR
�

	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
	TYPE_NAME
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

TYPE_SCHEM
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
TYPE_CAT
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
REMARKS
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

TABLE_TYPE
type�VARCHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName
	SYSTABLES
name

TABLE_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
	tableName

SYSSCHEMAS
name
TABLE_SCHEM
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
name
	TABLE_CAT
type�VARCHAR�

	columnPos
/

isAutoincrement
/
updatableByCursor
/
�


9
name
REF_GENERATION
type�VARCHAR
�

	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
SELF_REFERENCING_COL_NAME
type�VARCHAR
�

	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name
	TYPE_NAME
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

TYPE_SCHEM
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
TYPE_CAT
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
REMARKS
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

TABLE_TYPE
type�VARCHAR


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName
	SYSTABLES
name

TABLE_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
	tableName

SYSSCHEMAS
name
TABLE_SCHEM
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
name
	TABLE_CAT
type�VARCHAR�

	columnPos
/

isAutoincrement
/
updatableByCursor
/
�
�

�
�
����
������������������������������ur[ZW� 9�]�xp
�
��ur[ZW� 9�]�xp

p

p

p�������������
�
�`NUNNN

�VARCHAR�
Z��ur[IM�`&v겥xp


�
h
�q
UNZ`�
�
�`NUNNN

�VARCHAR�
�CHAR

�CHAR$
��ur[IM�`&v겥xp�
��ur[ZW� 9�]�xp

@

�

@�����
�
��NUU

�CHAR$
Z��ur[IM�`&v겥xp

h
��

NZ�
�
�
��NUU


�VARCHAR�
��ur[IM�`&v겥xp

�2<���;�u



O�
��ur[ZW� 9�]�xp�

9
name
SQLCol2
type�CHAR

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR


	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol2
type�CHAR

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR


	columnPos
/

isAutoincrement
/
updatableByCursor
/�

9
name
SQLCol2
type�CHAR

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQLCol1
type�CHAR


	columnPos
/

isAutoincrement
/
updatableByCursor
/

�VARCHAR�
�VARCHAR�
�VARCHAR�
�VARCHAR

�VARCHAR�
�VARCHAR
�
�VARCHAR
�
�VARCHAR
�
�VARCHAR
�
�VARCHAR
�
��ur[IM�`&v겥xp

	



<org.apache.derby.exe.acd15980bdx015ax84fbx0722x00000c4048500
+�����-
�
<org/apache/derby/exe/acd15980bdx015ax84fbx0722x00000c4048500

2org/apache/derby/impl/sql/execute/CursorActivation
<init>
()V

Code
postConstructor
createResultSet
'()Lorg/apache/derby/iapi/sql/ResultSet;
0org/apache/derby/impl/sql/execute/BaseActivation

setParameterValueSet
(IZ)V

reinit
throwIfMissingParms

getResultSetFactory
6()Lorg/apache/derby/iapi/sql/execute/ResultSetFactory;

e0
()Ljava/lang/Object;
getExecutionFactory
6()Lorg/apache/derby/iapi/sql/execute/ExecutionFactory;

2org/apache/derby/iapi/sql/execute/ExecutionFactory!
getIndexableRow
3(I)Lorg/apache/derby/iapi/sql/execute/ExecIndexRow;#$"%
0Lorg/apache/derby/iapi/sql/execute/ExecIndexRow;'	(
e1
-Lorg/apache/derby/iapi/types/StringDataValue;*+	,
getParameter
4(I)Lorg/apache/derby/iapi/types/DataValueDescriptor;./
0
+org/apache/derby/iapi/types/StringDataValue2
/org/apache/derby/iapi/types/DataValueDescriptor4
	getObject657
java/lang/String9
getDataValueFactory
0()Lorg/apache/derby/iapi/types/DataValueFactory;;<
=
,org/apache/derby/iapi/types/DataValueFactory?
getDataValue
](ILorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue;AB@C
g0
0(Lorg/apache/derby/iapi/types/NumberDataValue;)I
intG
nullToPrimitiveTest
F(Lorg/apache/derby/iapi/types/DataValueDescriptor;Ljava/lang/String;)VIJ
K
getInt
()IMN5O
-org/apache/derby/iapi/error/StandardExceptionQ

ExceptionsEF
T
 org/apache/derby/iapi/types/LikeV
greaterEqualStringFromParameter
'(Ljava/lang/String;I)Ljava/lang/String;XY
WZ
getVarcharDataValue
n(Ljava/lang/String;Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue;\]@^
e2`+	a
getNullVarchar
\(Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue;cd@e
setValue
4(Lorg/apache/derby/iapi/types/DataValueDescriptor;)Vgh5i
1org/apache/derby/iapi/types/VariableSizeDataValuek
setWidth
(IIZ)Vmnlo
org/apache/derby/iapi/sql/Rowq
	setColumn
5(ILorg/apache/derby/iapi/types/DataValueDescriptor;)Vstru
7org/apache/derby/iapi/services/loader/GeneratedByteCodex
	getMethod
K(Ljava/lang/String;)Lorg/apache/derby/iapi/services/loader/GeneratedMethod;z{y|
e3~'	
e4�+	�
g1�F
�
lessThanStringFromParameter�Y
W�
e5�+	�*
	SYSTABLES�
SYSTABLES_INDEX1�?���Q�@�?��
2org/apache/derby/iapi/sql/execute/ResultSetFactory3<����u



O��
getBulkTableScanResultSet

A(Lorg/apache/derby/iapi/sql/Activation;JIIILorg/apache/derby/iapi/services/loader/GeneratedMethod;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IZ[[Lorg/apache/derby/iapi/store/access/Qualifier;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZIIIZIIZZDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;����
e6�+	�
g2�F
�
e7�+	�
getColumnFromRow
5(II)Lorg/apache/derby/iapi/types/DataValueDescriptor;��
�
lessThan
�(Lorg/apache/derby/iapi/types/DataValueDescriptor;Lorg/apache/derby/iapi/types/DataValueDescriptor;)Lorg/apache/derby/iapi/types/BooleanDataValue;��5�
,org/apache/derby/iapi/types/BooleanDataValue�
equals
(Z)Z����
getImmutable
0()Lorg/apache/derby/iapi/types/BooleanDataValue;����
e8�+	�
g3�F
�
e9�+	�
greaterOrEquals��5�
_(ZLorg/apache/derby/iapi/types/BooleanDataValue;)Lorg/apache/derby/iapi/types/BooleanDataValue;A�@�
and
^(Lorg/apache/derby/iapi/types/BooleanDataValue;)Lorg/apache/derby/iapi/types/BooleanDataValue;����
java/lang/Exception�`
getIndexRowToBaseRowResultSet
�(JILorg/apache/derby/iapi/sql/execute/NoPutResultSet;IILjava/lang/String;IIIILorg/apache/derby/iapi/services/loader/GeneratedMethod;ZDDI)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;����
e10
2[Lorg/apache/derby/iapi/types/DataValueDescriptor;��	�
g4�
�
in
�(Lorg/apache/derby/iapi/types/DataValueDescriptor;[Lorg/apache/derby/iapi/types/DataValueDescriptor;Z)Lorg/apache/derby/iapi/types/BooleanDataValue;��5�
like
a(Lorg/apache/derby/iapi/types/DataValueDescriptor;)Lorg/apache/derby/iapi/types/BooleanDataValue;��3�~
e11
+Lorg/apache/derby/iapi/sql/execute/ExecRow;��	�
getValueRow
.(I)Lorg/apache/derby/iapi/sql/execute/ExecRow;��"��
	isNotNull��5�
or�����
NULL�
getProjectRestrictResultSet

%(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IIZZZLjava/lang/String;DD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;����
e12�'	�
.org/apache/derby/iapi/sql/execute/ExecIndexRow�
orderedNulls
(I)V�����

SYSSCHEMAS


SYSSCHEMAS_INDEX2
?�m3	A�"
getTableScanResultSet

?(Lorg/apache/derby/iapi/sql/Activation;JIIILorg/apache/derby/iapi/services/loader/GeneratedMethod;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IZ[[Lorg/apache/derby/iapi/store/access/Qualifier;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZIIIZIZDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;

�
	
e13
+	

g5
F


e14
+	

e15
+	

g6
F


e16
+	
�
e17
�	
�@+]9�
getNestedLoopJoinResultSet
�(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;ILorg/apache/derby/iapi/sql/execute/NoPutResultSet;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IZZDDLjava/lang/String;)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;
$
%�
&
e18
(�	
)

T
+
getCharDataValue
-]@
.
TABLE
0�
getRowResultSet
�(Lorg/apache/derby/iapi/sql/Activation;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;ZIDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;
3
4�
5?���Q�
getNormalizeResultSet
k(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;IIDDZ)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;
9
:�
;
e19
=�	
>

S
@
SYSTEM TABLE
B�
getUnionResultSet
�(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;IDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;
E
F�
G
e20
I�	
J

V
L
VIEW
N�?��G�z�
e21
S�	
T

A
V
SYNONYM
X�?���Q���5
]

e22
`�	
a

c
e23
e+	
f
e24
h+	
i

 
k
ansiTrim
�(ILorg/apache/derby/i4<�[y'�u



O�api/types/StringDataValue;Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue;
m
n3
o
e25
q+	
r
e26
t+	
u

getSortResultSet
n(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;ZZIIIIDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;
x
y�
z

getScrollable
()Z
|
}

~?u�	]̹�
getScrollInsensitiveResultSet
�(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Lorg/apache/derby/iapi/sql/Activation;IIZDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;
�
��
�
)org/apache/derby/iapi/sql/execute/ExecRow
�
row
,[Lorg/apache/derby/iapi/sql/execute/ExecRow;
�
�	
�1'*+`+~'�+�+�+�+�+�+�����'
+
+
+
+
�
(�
=�
I�
S�
`�
e+
h+
q+
t+

	

*��

S
R	
*�*� �&*_�)*�>
�f*_�b*� �&*_��*�>
�f*_��*�>
�f*_��*�>
�f*_���5*_��*� ��*_��*� �&*_��*�>
�f*_�
*�>
�f*_�
*� ��*_�
 *� ��*_�
**�
*
,*�>_
�
/�5�v*�
*
1*�>_
�
/�5�v*� ��*_�
?*�
?
A*�>_
�
/�5�v*�
?
C*�>_
�
/�5�v*� ��*_�
K*�
K
M*�>_
�
/�5�v*�
K
O*�>_
�
/�5�v*� ��*_�
U*�
U
W*�>_
�
/�5�v*�
U
Y*�>_
�
/�5�v*� 
��*_�
b*�>
�f*_�
g*�>
�f*_�
s*�>
�f*_�
v*�
�Z�
�W�S
R	�(
�*�*�*�*�*�*�*�`�
*�*q�
*w�}*��}
�
������	*̹}����*�}*�}*�}�����*�*���*�*�*
�}




�
�



�
��*
�}*
!�}
��
��
�
"
�
'*�*�*�*�*�**
2�}��
6	*�_

7�
<	*�**
D�}��
6	
7�
H*�**
P�}��
6	*�_
Q�
<	

Q�
H*�**
Z�}��
6	*�_
[�
<		
[�
H*
_�}

�
[��

[
"
�
'
*
w�}
�
[
"��	,
[
"�
{*
*�

�
"�
�
�S
R	

*��
S
R	n
b*�)*�1�3�8
�:�*�>_
�D*_�U�[*�>_*�-�_Y*_�-*�b_�j*�bY��p�v*�)�EFS
R	
+YH�L�P
�
*S
R	n
b*��*�1�3�8
�:�*�>_
�D*_����*�>_*���_Y*_��*��_�j*��Y��p�v*����FS
R	
+YH�L�P
�
`SR�	



*�1�3�8
�:�*�>_
�D*_����*�>_*���_Y*_��*��_�j*��Y��p�5Y*���3�5_��Y�����
��*�1�3�8
�:�*�>_
�D*_���[*�>_*���_Y*_��*��_�j*��Y��p�5Y*���3�5_��Y�����
�*�>_
��������FS
R	
+YH�L�P
��FS
R	
+YH�L�P
�
~SR�	u
i*��*���3Y*����Y�����
�A*���3*�1�3��Y�����
�*�>_
��������S
R	J
>*��*�1�3_S*��*�1�3_S*��*�1�3_S*��*�1�3_S�
�SR�	'
*��*���3�5�v*��
�SR�	c
W*�>_
��Y�����
�;*�1�3�5��
Y�����
�*�>_
�������
�S
R	.
"*��*���3�v*����*���
�SR�	
I

=*�1�3�8
�:�*�>_
�D*_�
��*�>_*�

�_Y*_�

*�
_�j*�
Y��p�5Y*���3�5_��Y�����
��*�1�3�8
�:�*�>_
�D*_�
�[*�>_*�
�_Y*_�
*�
_�j*�
Y��p�5Y*���3�5_��Y�����
�B*���3*�1�3��Y�����
�*�>_
���������
FS
R	
+YH�L�P
�
FS
R	
+YH�L�P
�
�SR�	(
*�
 *���3�5�v*�
 �
5<�[�u




BJ�SR�	

*�
*�
�SR�	

*�
?�
�SR�	

*�
K�
�SR�	

*�
U�

SR�	-
!*���3�5Y*	���3�5_�
^�

SR�	
>

2*�
b
d*�>_
�
/*�
g_�j*�
gY��p�5�v*�
b*���3
l*�>_
�
/*�
j�
pY*_�
j*�
s_�j*�
sY�p�5�v*�
b
d*�>_
�
/*�
v_�j*�
vY��p�5�v*�
b*�>
�f�5�v*�
b*�>
�f�5�v*�
b*�>
�f�5�v*�
b	*�>
�f�5�v*�
b
*�>
�f�5�v*�
b�<P��S�u



O��
)
�
SELECT

9
name
SCOPE_CATLOG
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
IS_GENERATEDCOLUMN
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
IS_AUTOINCREMENT
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SOURCE_DATA_TYPE
type�SMALLINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SCOPE_TABLE
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SCOPE_SCHEMA
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

SCOPE_CATALOG
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
IS_NULLABLE
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName

SYSCOLUMNS
name
ORDINAL_POSITION
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
name
CHAR_OCTET_LENGTH
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQL_DATETIME_SUB
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

SQL_DATA_TYPE
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

COLUMN_DEF
type�VARCHAR
�

	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
REMARKS
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
NULLABLE
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
NUM_PREC_RADIX
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
DECIMAL_DIGITS
type�INTEGER



	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name

BUFFER_LENGTH
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
COLUMN_SIZE
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
	TYPE_NAME
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
	DATA_TYPE
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName

SYSCOLUMNS
name
COLUMN_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
	tableName
	SYSTABLES
name

TABLE_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
	tableName

SYSSCHEMAS
name
TABLE_SCHEM
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
name
	TABLE_CAT
type�VARCHAR�

	columnPos
/

isAutoincrement
/
updatableByCursor
/
#�

9
name
SCOPE_CATLOG
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
IS_GENERATEDCO7<�-f��u



O�LUMN
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
IS_AUTOINCREMENT
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SOURCE_DATA_TYPE
type�SMALLINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SCOPE_TABLE
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SCOPE_SCHEMA
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

SCOPE_CATALOG
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
IS_NULLABLE
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName

SYSCOLUMNS
name
ORDINAL_POSITION
type�INTEGER


	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
name
CHAR_OCTET_LENGTH
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
SQL_DATETIME_SUB
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

SQL_DATA_TYPE
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

COLUMN_DEF
type�VARCHAR
�

	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
REMARKS
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
NULLABLE
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
NUM_PREC_RADIX
type�INTEGER



	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
DECIMAL_DIGITS
type�INTEGER



	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
name

BUFFER_LENGTH
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
COLUMN_SIZE
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
	TYPE_NAME
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
	DATA_TYPE
type�INTEGER



	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName

SYSCOLUMNS
name
COLUMN_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
	tableName
	SYSTABLES
name

TABLE_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
	tableName

SYSSCHEMAS
name
TABLE_SCHEM
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
name
	TABLE_CAT
type�VARCHAR�

	columnPos
/

isAutoincrement
/
updatableByCursor
/
�

�
�
���������������������������������������������������������������������������������������ur[ZW� 9�]�xp�
��ur[ZW� 9�]�xp

�

�

����������
�
��NUU

�VARCHAR�
Z��ur[IM�`&v겥xp

h
��8<�ʹ�u



O�

UZ�
�
�
��NUU

�CHAR$
�VARCHAR�
��ur[IM�`&v겥xp
�
��ur[ZW� 9�]�xp

�

�

��������������
�
�`NUNNN

�VARCHAR�
�CHAR$
Z��ur[IM�`&v겥xp

h
�q
UNZ`�
�
�`NUNNN

�CHAR$
�VARCHAR�
�CHAR$
��ur[IM�`&v겥xp
�
��ur[ZW� 9�]�xp

	��

	��

	�������������������������������
�
��	NUP



NTTT

�CHAR$
�VARCHAR�
Z��ur[IM�`&v겥xp

h
��
NUZ��
�
��	NUP



NTTT

�CHAR$
�VARCHAR�
�INTEGER

�
'org.apache.derby.catalog.TypeDescriptor'org.apache.derby.catalog.TypeDescriptor����
�
java.io.Serializablejava.io.Serializable
����
�BIGINT

�BIGINT

��ur[IM�`&v겥xp
		
�VARCHAR�
�VARCHAR�
�VARCHAR�
�VARCHAR�
�INTEGER


�VARCHAR
�
�INTEGER


�INTEGER


�INTEGER


�INTEGER


�INTEGER


�VARCHAR�
�VARCHAR
�
�INTEGER


�INTEGER


�INTEGER


�INTEGER

�VARCHAR�
�VARCHAR
�
�VARCHAR
�
�VARCHAR
�
�SMALLINT

�VARCHAR�
�VARCHAR�
�VARCHAR
�
��ur[IM�`&v겥xp
	


<org.apache.derby.exe.ac38c30028x015ax84fbxba5fx00000a0923180
O�����-�
<org/apache/derby/exe/ac38c30028x015ax84fbxba5fx00000a0923180

2org/apache/derby/impl/sql/execute/CursorActivation
<init>
()V

Code
postConstructor
createResultSet
'()Lorg/apache/derby/iapi/sql/ResultSet;
0org/apache/derby/impl/sql/execute/BaseActivation

setParameterValueSet
(IZ)V

reinit
throwIfMissingParms

getResultSetFactory
6()Lorg/apache/derby/iapi/sql/execute/ResultSetFactory;

e0
()Ljava/lang/Object;
getExecutionFactory
6()Lorg/apache/derby/iapi/sql/execute/ExecutionFactory;

2org/apache/derby/iapi/sql/execute/ExecutionFactory!
getIndexableRow
3(I)Lorg/apache/derby/iapi/sql/execute/ExecIndexRow;#$"%
0Lorg/apache/derby/iapi/sql/execute/ExecIndexRow;'	(
e1
-Lorg/apache/derby/iapi/types/StringDataValue;*+	,
getParameter
4(I)Lorg/apache/derby/iapi/types/DataValueDescriptor;./
0
+org/apache/derby/iapi/types/StringDataValue2
/org/apache/derby/iapi/types/DataValueDescriptor4
	getObject657
java/lang/String9
getDataValueFactory
0()Lorg/apache/derby/iapi/types/DataValueFactory;;<
=
,org/apache/derby/iapi/types/DataValueFactory?
getDataValue
](ILorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue;AB@C
g0
0(Lorg/apache/derby/iapi/types/NumberDataValue;)I
intG
nullToPrimitiveTest
F(Lorg/apache/derby/iapi/types/DataValueDescriptor;Ljava/lang/String;)VIJ
K
getInt
()IMN5O
-org/apache/derby/iapi/error/StandardE9<�w7R|u



O�xceptionQ

ExceptionsEF
T
 org/apache/derby/iapi/types/LikeV
greaterEqualStringFromParameter
'(Ljava/lang/String;I)Ljava/lang/String;XY
WZ
getVarcharDataValue
n(Ljava/lang/String;Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue;\]@^
e2`+	a
getNullVarchar
\(Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue;cd@e
setValue
4(Lorg/apache/derby/iapi/types/DataValueDescriptor;)Vgh5i
1org/apache/derby/iapi/types/VariableSizeDataValuek
setWidth
(IIZ)Vmnlo
org/apache/derby/iapi/sql/Rowq
	setColumn
5(ILorg/apache/derby/iapi/types/DataValueDescriptor;)Vstru
7org/apache/derby/iapi/services/loader/GeneratedByteCodex
	getMethod
K(Ljava/lang/String;)Lorg/apache/derby/iapi/services/loader/GeneratedMethod;z{y|
e3~'	
e4�+	�
g1�F
�
lessThanStringFromParameter�Y
W�
e5�+	�*

SYSSCHEMAS�
SYSSCHEMAS_INDEX1�?ٙ�����@��p:�~
2org/apache/derby/iapi/sql/execute/ResultSetFactory�
getBulkTableScanResultSet

A(Lorg/apache/derby/iapi/sql/Activation;JIIILorg/apache/derby/iapi/services/loader/GeneratedMethod;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IZ[[Lorg/apache/derby/iapi/store/access/Qualifier;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZIIIZIIZZDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;����
e6�+	�
g2�F
�
e7�+	�
getColumnFromRow
5(II)Lorg/apache/derby/iapi/types/DataValueDescriptor;��
�
greaterOrEquals
�(Lorg/apache/derby/iapi/types/DataValueDescriptor;Lorg/apache/derby/iapi/types/DataValueDescriptor;)Lorg/apache/derby/iapi/types/BooleanDataValue;��5�
,org/apache/derby/iapi/types/BooleanDataValue�
equals
(Z)Z����
getImmutable
0()Lorg/apache/derby/iapi/types/BooleanDataValue;����
e8�+	�
g3�F
�
e9�+	�
lessThan��5�
_(ZLorg/apache/derby/iapi/types/BooleanDataValue;)Lorg/apache/derby/iapi/types/BooleanDataValue;A�@�
and
^(Lorg/apache/derby/iapi/types/BooleanDataValue;)Lorg/apache/derby/iapi/types/BooleanDataValue;����
java/lang/Exception�`
getIndexRowToBaseRowResultSet
�(JILorg/apache/derby/iapi/sql/execute/NoPutResultSet;IILjava/lang/String;IIIILorg/apache/derby/iapi/services/loader/GeneratedMethod;ZDDI)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;����
like
a(Lorg/apache/derby/iapi/types/DataValueDescriptor;)Lorg/apache/derby/iapi/types/BooleanDataValue;��3�~
e10
+Lorg/apache/derby/iapi/sql/execute/ExecRow;��	�
getValueRow
.(I)Lorg/apache/derby/iapi/sql/execute/ExecRow;��"��
	isNotNull��5�
or�����
NULL�
getProjectRestrictResultSet

%(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IIZZZLjava/lang/String;DD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;����
e11�'	�
e12�+	�
g4�F
�
e13�+	�
.org/apache/derby/iapi/sql/execute/ExecIndexRow�
orderedNulls
(I)V�����
e14�'	

e15
+	

g5
F


e16
+	
	�
e17
0[[Lorg/apache/derby/iapi/store/access/Qualifier;


	

reinitializeQualifiers
3([[Lorg/apache/derby/iapi/store/access/Qualifier;)V




/[Lorg/apache/derby/iapi/store/access/Qualifier;

allocateQualArray
5([[Lorg/apache/derby/iapi/store/access/Qualifier;II)V



�
getQualifier
�(IILorg/apache/derby/iapi/services/loader/GeneratedMethod;Lorg/apache/derby/iapi/sql/Activation;ZZZI)Lorg/apache/derby/iapi/store/access/Qualifier;

"

setQualifier
c([[Lorg/apache/derby/iapi/store/access/Qualifier;Lorg/apache/derby/iapi/store/access/Qualifier;II)V

 

!
	SYSTABLES
#
SYSTABLES_INDEX1
%?�/��v�?��������5
+
e18
-+	
:<��cSu



O�.
g6
0F

1
e19
3+	
4
e20
6+	
7
g7
9F

:
e21
<+	
=��
e22
A�	
B�@8�h���
getNestedLoopJoinResultSet
�(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;ILorg/apache/derby/iapi/sql/execute/NoPutResultSet;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IZZDDLjava/lang/String;)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;
G
H�
I
e23
K'	
L
e24
N+	
O
g8
QF

R
e25
T+	
U�
e26
X'	
Y
e27
[+	
\
g9
^F

_
e28
a+	
b�

SYSCOLUMNS
e
SYSCOLUMNS_INDEX1
g?�tS��Ml@v�3� �
e29
m+	
n
g10
pF

q
e30
s+	
t
e31
v+	
w
g11
yF

z
e32
|+	
}�

e33
��	
�
@%W��=V
e34
��	
�

�
getCharDataValue
�]@
�
e35
�+	
�
e36
)Lorg/apache/derby/catalog/TypeDescriptor;
�
�	
�
)org/apache/derby/iapi/types/UserDataValue
�
'org/apache/derby/catalog/TypeDescriptor
�
e37
-Lorg/apache/derby/iapi/types/NumberDataValue;
�
�	
�
getNullInteger
\(Lorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue;
�
�@
�
e38
�
�	
�

getJDBCTypeId
�N
�
�
e39
�
�	
�
e40
�+	
�
e41
�+	
�
getTypeName
()Ljava/lang/String;
�
�
�
�
e42
�+	
�
e43
2[Lorg/apache/derby/iapi/types/DataValueDescriptor;
�
�	
�
g12
e44
�
�	
�
java/sql/Types
�
INTEGER

I
�
�	
�
�
e45
�
�	
�
SMALLINT
�
�	
�
�
e46
�
�	
�
TINYINT
�
�	
�
�
e47
�
�	
�
BIGINT
�
�	
�
�
e48
�
�	
�
REAL
�
�	
�
�
e49
�
�	
�
DOUBLE
�
�	
�
�
e50
�
�	
�
DECIMAL
�
�	
�
�
e51
�
�	
�
NUMERIC
�
�	
�
�
e52
�
�	
�
FLOAT
�
�	
�
�
�

�
e53
�
�	
�
e54
�
�	
�
e55
�
�	
�
in
�(Lorg/apache/derby/iapi/types/DataValueDescriptor;[Lorg/apache/derby/iapi/types/DataValueDescriptor;Z)Lorg/apache/derby/iapi/types/BooleanDataValue;
5
e56
�	
e57
�		
e58
�	
getPrecisionN
�
e59
�	
e60
�	
e61
�	
getMaximumWidthN
�
e62
�	
g13
e63!
�	"
e64$
�	%
e65'
�	(
e66*
�	+
e67-
�	.
e680
�	1
e693
�	4
DATE6
�	
�7
e709
�	:
TIME<
�	
�=
e71?
�	@
	TIMESTAMPB
�	
�C 
E
e72G
�	H
e73J
�	K
e74M
�	N
e75P
�	Q
e76S
�	T
e77V
�	W
getScaleYN
�Z
e78\
�	]
g14
e79`
�	a
e80c
�	d
e81f
�	g_
i
e82k
�	l
e83n
�	o
e84q
�	r
e85t
�	u
g15
e86x
�	y
e87{
�	|
e88~
�	
e89�
�	�
e90�
�	�
e91�
�	�
e92�
�	�
e93�
�	�
e94�
�	�w
�
e95�
�	�
e96�
�	�
e97�
�	�
e98�
�	�
e99
.Lorg/apache/derby/iapi/types/BooleanDataValue;��	�
getNullBoolean��@�
e100��	�

isNullable
()Z��
��
e101�
�	�
java/sql/DatabaseMetaData�
columnNullable�
�	��
e102�
�	�

columnNoNulls�
�	��
e103�+	�
isNullOp��5�
+org/apache/derby/iapi/types/NumberDataValue�
e104�+	�
e105�
�	�
getNullLong�
�@�
e106�+	�
getNullChar�d@�

 �
ansiTrim
�(ILorg/apache/derby/iapi/types/StringDataValue;Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue;��3�
e107�+	�
e108�
�	�
e109�+	�
AUTOINCREMENT: start �
e110�+	�
concatenate
�(Lorg/apache/derby/iapi/types/StringDataValue;Lorg/apache/derby/iapi/types/StringDataValue;Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue;��3�
 increment �
e111�+	�
e112�+	�
e113�+	�
java.lang.String�
setObjectForCast
((Ljava/lang/Object;ZLjava/lang/String;)V��5�
e114�
�	�
g16
e115

�	
CHAR
�	
�
e116
�	
VARCHAR

�	
�


e117
�	
e118
�	
e119
�	;<��<2�u



O�
java/math/BigDecimal
2.0
(Ljava/lang/String;)V

getDecimalDataValue
n(Ljava/lang/Number;Lorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue; @!
e120#
�	$
e121&
�	'
e122)
�	*
e123,
�	-
times
�(Lorg/apache/derby/iapi/types/NumberDataValue;Lorg/apache/derby/iapi/types/NumberDataValue;Lorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue;/0�1���
greaterThan4�55
e1247
�	8
e125:
�	;
e126=
�	>
e127@
�	A
e128C
�	D
e129F�	G
e130I�	J
YESL
NON
e131P+	Q
getNullShortS
�@T
e132V+	W
e133
Ljava/lang/String;YZ	[
e134
Ljava/io/Serializable;]^	_
java/io/Serializablea
java/lang/Objectc
toStringe
�
df
e135h�	i
e136k�	l
GENERATED ALWAYS ASn

startsWith
(Ljava/lang/String;)Zpq
:r
e137t+	u

getSortResultSet
n(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;ZZIIIIDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;xy�z

getScrollable|�
}
getScrollInsensitiveResultSet
�(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Lorg/apache/derby/iapi/sql/Activation;IIZDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;���
)org/apache/derby/iapi/sql/execute/ExecRow�
row
,[Lorg/apache/derby/iapi/sql/execute/ExecRow;��	�1�'*+`+~'�+�+�+�+�+�+���'�+�+�'
+
+



-+
3+
6+
<+
A�
K'
N+
T+
X'
[+
a+
m+
s+
v+
|+
��
��
�+
�
�
�
�
�
�
�
�
�+
�+
�+
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�!
�$
�'
�*
�-
�0
�3
�9
�?
�G
�J
�M
�P
�S
�V
�\
�`
�c
�f
�k
�n
�q
�t
�x
�{
�~
��
��
��
��
��
��
��
��
��
��
������
��
��+�+�
��+�+�
��+�+�+�+�+�
�

�
�
�
�
�#
�&
�)
�,
�7
�:
�=
�@
�C
�F�I�P+V+YZ]^h�k�t+'

	

*��

S
R	s

g*�*� �&*_�)*�>
�f*_�b*� �&*_��*�>
�f*_��*�>
�f*_��*�>
�f*_��*� ��*_��*� �&*_��*�>
�f*_��*� �&*_�

*�>
�f*_�

�
*_�
*�
�
*�
*� *
�}*�
	�
"*�>
�f*_�
5*�>
�f*_�
>*� ��*_�
C*� �&*_�
M*�>
�f*_�
V*� �&*_�
Z*�>
�f*_�
c*�>
�f*_�
u*�>
�f*_�
~*� ��*_�
�*� ��*_�
�*�>
�f*_�
�*�>
�f*_�
�	�5*_�
�	�5*_��5*_�^	�5*_�v*�>
�f*_��*�>
��*_��*�>
��*_��*�>
��*_��*�>
��*_��*�>
�f*_���5*_��*�>
�f*_�R*�>
�f*_�X*�>
�f*_�v*��Z��W�S
R	e*
Y*�*�*�*�*�*�*���
*�*х*w�}*��}
�
�����
�	*̹}����*չ}*޹}*�}�����*�*�`�*�*q�*��}*
�}*�

$

&
'
)��
$*
?�}
'
)��*
@�}*
D�}
�
'
)��

'
E
�
J*�*���*�*�� 
*
W�}*
d�}

f

h
i
k��!	
f*
�}
i
k	��*
��}*
��}
�
i
k��

i
�
�
J
*w�}
�
i
���"B

i
��{**�~
i
���
�S
R	

*�*�
�
�
S
R	n
b*�)*�1�3�8
�:�*�>_
�D<<�Oܲu



O�*_�U�[*�>_*�-�_Y*_�-*�b_�j*�bY��p�v*�)�EFS
R	
+YH�L�P
�
*S
R	n
b*��*�1�3�8
�:�*�>_
�D*_����*�>_*���_Y*_��*��_�j*��Y��p�v*����FS
R	
+YH�L�P
�
`SR�	



*�1�3�8
�:�*�>_
�D*_���[*�>_*���_Y*_��*��_�j*��Y��p�5Y*���3�5_��Y�����
��*�1�3�8
�:�*�>_
�D*_����*�>_*���_Y*_��*��_�j*��Y��p�5Y*���3�5_��Y�����
�*�>_
��������FS
R	
+YH�L�P
��FS
R	
+YH�L�P
�
~SR�	#
*���3*�1�3���
�SR�	'
*��*���3�5�v*�ٰ
�SR�	c
W*�>_
��Y�����
�;*�1�3�5��
Y�����
�*�>_
�������
�S
R	�
*��*�1�3�8
�:�*�>_
�D*_���[*�>_*��_Y*_��*��_�j*��Y��p�v*��*���3�v*����*���FS
R	
+YH�L�P
�
�S
R	n
b*�

*�1�3�8
�:�*�>_
�D*_�
��*�>_*�
�_Y*_�
*�

_�j*�

Y��p�v*�

�
FS
R	
+YH�L�P
�
�SR�	

*���3�
�SR�	
R

F*���3�5Y*���3�5_�
,Y�����
�
*�1�3�8
�:�*�>_
�D*_�
2�[*�>_*�
/�_Y*_�
/*�
5_�j*�
5Y��p�5Y*���3�5_��Y�����
��*�1�3�8
�:�*�>_
�D*_�
;��*�>_*�
8�_Y*_�
8*�
>_�j*�
>Y��p�5Y*���3�5_��Y�����
�*�>_
���������
0FS
R	
+YH�L�P
�
9FS
R	
+YH�L�P
�
�SR�	$
*���3*�1�3���
�SR�	(
*�
C*���3�5�v*�
C�
�S
R	�
�*�
M*���3�v*�
M��*�
M*�1�3�8
�:�*�>_
�D*_�
S�[*�>_*�
P�_Y*_�
P*�
V_�j*�
VY��p�v*�
M�
QFS
R	
+YH�L�P
�
�S
R	�
�*�
Z*���3�v*�
Z��*�
Z*�1�3�8
�:�*�>_
�D*_�
`��*�>_*�
]�_Y*_�
]*�
c_�j*�
cY��p�v*�
Z�
^FS
R	
+YH�L�P
�
�SR�	
S

G*�1�3�8
�:�*�>_
�D*_�
r��*�>_*�
o�_Y*_�
o*�
u_�j*�
uY��p�5Y*	���3�5_��Y�����
��*�1�3�8
�:�*�>_
�D*_�
{�[*�>_*�
x�_Y*_�
x*�
~_�j*�
~Y��p�5Y*	���3�5_��Y�����
�L*���3�5Y*	���3�5_�
,Y�����
�*�>_
���������
pFS
R	
+YH�L�P
�
yFS
R	
+YH�L�P
�

SR�	$
*	���3*�1�3���

SR�	(
*�
�*	���3�5�v*�
��

SR�	
1	

%*�
�
�*�>_
�
�*�
�_�j*�
�Y��p�5�v*�
�*	���
��8
�
�Y*_�
��*�
�*�>_�
�� *�
��
�
*�>_*�
��DY*_�
��5�v*�
�*	���
��8
�
�Y*_�
��*�
�*�>_�f� *�
��
�
*�>_*�
��_Y*_�
�*�
�_�j*�
�Y��p�5�v*�
�*�
�*	���
��8
�
�Y*_�
��*�
�*�>_�
�� *�
��
�
*�>_*��DY*_�Y*�
�����O*	���
��8
�
�Y*_��*�
*�>_�
�� *��
*�>_*�
�DY*_�
�L*	���
��8
�
�Y*_��*�*�>_�
�� *��
*�>_*��DY*_��5�v*�
�*�>
�
��5�v*�
�	*�F*	���
��8
�
�Y*_�I�*�L*�>_�
�� *�I�
�
*�>_*�O�DY*_�OY*�����O*	���
��8
�
�Y*_�R�*�U*�>_�
�� *�R�[
*�>_*�X�DY*_�X�
*�>
�
��5�v*�
�
*�j*	���
��8
�
�Y*_�m�*�p*�>_�
�� *�m�
�
*�>_*�s�DY*_�sY*�^����*�>_
�D�~*��*	���
��8
�
�Y*_���*��*�>_�
�� *���
�
*�>_*���DY*_��Y*�v����
*�>_
�D�
=<�
^�_u




J�*�>
�
��5�v*�
�*	���
��8
�
�Y*_���*��*�>_��� *����
*�>_*����Y*_�������*�>_*���DY*_�����*�>_*���DY*_���5�v*�
�
�*�>_
�
�*��_�j*��Y��p�5�v*�
�
*
���
��5��
���
*�����5��
���*�>
�f��*����*��_�j*��*��_�j*��Y�p�*�>_
�
�*�ǹ�Y*_��Y*����*��_�j*��*��_�j*��Y�p�*�>_
�
�*�ܹ�Y*_��Y�*�>_
�
�_*���Y*_��Y�*�>_
�
�*���Y*_��_*���Y*_��2*
���
��8
*��_Y�:���*��Y��p�5�v*�
�*�>
�
��5�v*�
�*�>
�
��5�v*�
�*�*	���
��8
�
�Y*_��*�*�>_�
�� *��
�
*�>_*��DY*_�Y*������
�Y�*�>_
�"Y*	���
��8
�
�Y*_�%�*�(*�>_�
�� *�%�
*�>_*�+�DY*_�+_*�.�2Y�pY*_�.�5Y3*�>_
�D�5�6���3*�>_
�D�i*�>_
�DY*	���
��8
�
�Y*_�9�*�<*�>_�
�� *�9�
*�>_*�?�DY*_�?_*�B�2Y*_�B�
*�>
�
��5�v*�
�*	���
��8
�
�Y*_�E�*�H*�>_��� *�E��
*�>_*�K��Y*_�K���M*�>_
�
��O*�>_
�
�*�R_�j*�RY��p�5�v*�
�*�>
�f�5�v*�
�*�>
�f�5�v*�
�*�>
�f�5�v*�
�*�>
�U�5�v*�
�*�����5��
���M*�>_
�
��O*�>_
�
�*�X_�j*�XY��p�5�v*�
�*
���
��5��
Y�����
�y*
���
��8
�bY*_�`�
�
*�`�gY*_�\�*�j*�>_���4*�\o*�>_
�
��8
�:�s*�>_*�m��Y*_�m�����M*�>_
�
��O*�>_
�
�*�v_�j*�vY��p�5�v*�
�*�>
�f�5�v*�
��
�S
R	


*�
��
�*�>_*�
��DY*_�
�_S*�
��
�*�>_*�
ȹDY*_�
�_S*�
��
�*�>_*�
ιDY*_�
�_S*�
��
�*�>_*�
ԹDY*_�
�_S*�
��
�*�>_*�
ڹDY*_�
�_S*�
��
�*�>_*�
�DY*_�
�_S*�
��
�*�>_*�
�DY*_�
�_S*�
��
�*�>_*�
�DY*_�
�_S*�
��
�*�>_*�
�DY*_�
�_S� S
R	


*��
�*�>_*�#�DY*_�#_S*��
�*�>_*�&�DY*_�&_S*��
�*�>_*�)�DY*_�)_S*��
�*�>_*�,�DY*_�,_S*��
�*�>_*�/�DY*_�/_S*��
�*�>_*�2�DY*_�2_S*��8*�>_*�5�DY*_�5_S*��>*�>_*�;�DY*_�;_S*��D*�>_*�A�DY*_�A_S�_S
R	g
[*�^�
�*�>_*�b�DY*_�b_S*�^�
�*�>_*�e�DY*_�e_S*�^�
�*�>_*�h�DY*_�h_S�wS
R	


*�v�
�*�>_*�z�DY*_�z_S*�v�
�*�>_*�}�DY*_�}_S*�v�
�*�>_*���DY*_��_S*�v�
�*�>_*���DY*_��_S*�v�
�*�>_*���DY*_��_S*�v�
�*�>_*���DY*_��_S*�v�8*�>_*���DY*_��_S*�v�>*�>_*���DY*_��_S*�v�D*�>_*���DY*_��_S�S
R	I
=*���*�>_*��DY*_�_S*���*�>_*�	�DY*_�	_S�<
��?�u

	

O��
)
�
SELECT


9
name
FILTER_CONDITION
type�VARCHAR
�

	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
PAGES
type�BIGINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
CARDINALITY
type�BIGINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
ASC_OR_DESC
type�CHAR


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
	tableName

SYSCOLUMNS
name
COLUMN_NAME
type�VARCHAR�

	columnPos
/	
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
name
ORDINAL_POSITION
type�SMALLINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
TYPE
type�SMALLINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName
SYSCONGLOMERATES
name

INDEX_NAME
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
name
INDEX_QUALIFIER
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

NON_UNIQUE
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName
	SYSTABLES
name

TABLE_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
	tableName

SYSSCHEMAS
name
TABLE_SCHEM
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
name
	TABLE_CAT
type�VARCHAR�

	columnPos
/

isAutoincrement
/
updatableByCursor
/
,�


9
name
FILTER_CONDITION
type�VARCHAR
�

	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
PAGES
type�BIGINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
CARDINALITY
type�BIGINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
ASC_OR_DESC
type�CHAR


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
	tableName

SYSCOLUMNS
name
COLUMN_NAME
type�VARCHAR�

	columnPos
/	
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
name
ORDINAL_POSITION
type�SMALLINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
TYPE
type�SMALLINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName
SYSCONGLOMERATES
name

INDEX_NAME
type�VARCHAR
�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
name
INDEX_QUALIFIER
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name

NON_UNIQUE
type�BOOLEAN


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName
	SYSTABLES
name

TABLE_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
	tableName

SYSSCHEMAS
name
TABLE_SCHEM
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
name
?<�:ѷau

	

O�	TABLE_CAT
type�VARCHAR�

	columnPos
/

isAutoincrement
/
updatableByCursor
/
�
�
�
�
�
��������������������������������������ur[ZW� 9�]�xp
�
��ur[ZW� 9�]�xp

�

�

����������
�
��NUU

�VARCHAR�
Z��ur[IM�`&v겥xp

h
��

UZ�
�
�
��NUU

�CHAR$
�VARCHAR�
��ur[IM�`&v겥xp


�

�

������

�
�`NUNNN

�VARCHAR�
�CHAR$
Z��ur[IM�`&v겥xp

h
�q
UNZ`�
�
�`NUNNN


�CHAR$
��ur[IM�`&v겥xp



�
��ur[ZW� 9�]�xp

\

\

\�����������������
�
� NNTUM

MN

�CHAR$
Z��ur[IM�`&v겥xp

h
�Q
NZ 
�
�
� NNTUM

MN

�CHAR$
�VARCHAR
�
�BOOLEAN


�
(org.apache.derby.catalog.IndexDescriptor(org.apache.derby.catalog.IndexDescriptor
����
��ur[IM�`&v겥xp�
��ur[ZW� 9�]�xp

	�

	�

	��������������
�
��	NUP



NTTT

�CHAR$
Z��ur[IM�`&v겥xp


�
h
��
NUZ��
�
��	NUP



NTTT

�CHAR$
�VARCHAR�
�INTEGER

��ur[IM�`&v겥xp


�VARCHAR�
�VARCHAR�
�VARCHAR�
�BOOLEAN

�VARCHAR�
�VARCHAR
�
�SMALLINT

�SMALLINT

�VARCHAR�
�CHAR

�BIGINT

�BIGINT

�VARCHAR
�
��ur[IM�`&v겥xp

	




<org.apache.derby.exe.ac81260031x015ax84fbxba5fx00000a0923180
/�����-
�
<org/apache/derby/exe/ac81260031x015ax84fbxba5fx00000a0923180

2org/apache/derby/impl/sql/execute/CursorActivation
<init>
()V

Code
postConstructor
createResultSet
'()Lorg/apache/derby/iapi/sql/ResultSet;
0org/apache/derby/impl/sql/execute/BaseActivation

setParameterValueSet
(IZ)V

reinit
throwIfMissingParms

getResultSetFactory
6()Lorg/apache/derby/iapi/sql/execute/ResultSetFactory;

e0
()Ljava/lang/Object;
getExecutionFactory
6()Lorg/apache/derby/iapi/sql/execute/ExecutionFactory;

2org/apache/derby/iapi/sql/execute/ExecutionFactory!
getIndexableRow
3(I)Lorg/apache/derby/iapi/sql/execute/ExecIndexRow;#$"%
0Lorg/apache/derby/iapi/sql/execute/ExecIndexRow;'	(
e1
-Lorg/apache/derby/iapi/types/StringDataValue;*+	,
getParameter
4(I)Lorg/apache/derby/iapi/types/DataValueDescriptor;./
0
+org/apache/derby/iapi/types/StringDataValue2
/org/apache/derby/iapi/types/DataValueDescriptor4
	getObject657
java/lang/String9
getDataValueFactory
0()Lorg/apache/derby/iapi/types/DataValueFactory;;<
=
,org/apache/derby/iapi/types/DataValueFactory?
getDataValue
](ILorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue;AB@C
g0
0(Lorg/apache/derby/iapi/types/NumberDataValue;)I
in@<��u-u

	

O�tG
nullToPrimitiveTest
F(Lorg/apache/derby/iapi/types/DataValueDescriptor;Ljava/lang/String;)VIJ
K
getInt
()IMN5O
-org/apache/derby/iapi/error/StandardExceptionQ

ExceptionsEF
T
 org/apache/derby/iapi/types/LikeV
greaterEqualStringFromParameter
'(Ljava/lang/String;I)Ljava/lang/String;XY
WZ
getVarcharDataValue
n(Ljava/lang/String;Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue;\]@^
e2`+	a
getNullVarchar
\(Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue;cd@e
setValue
4(Lorg/apache/derby/iapi/types/DataValueDescriptor;)Vgh5i
1org/apache/derby/iapi/types/VariableSizeDataValuek
setWidth
(IIZ)Vmnlo
org/apache/derby/iapi/sql/Rowq
	setColumn
5(ILorg/apache/derby/iapi/types/DataValueDescriptor;)Vstru
7org/apache/derby/iapi/services/loader/GeneratedByteCodex
	getMethod
K(Ljava/lang/String;)Lorg/apache/derby/iapi/services/loader/GeneratedMethod;z{y|
e3~'	
e4�+	�
g1�F
�
lessThanStringFromParameter�Y
W�
e5�+	�*

SYSSCHEMAS�
SYSSCHEMAS_INDEX1�?ə�����@��p:�~
2org/apache/derby/iapi/sql/execute/ResultSetFactory�
getBulkTableScanResultSet

A(Lorg/apache/derby/iapi/sql/Activation;JIIILorg/apache/derby/iapi/services/loader/GeneratedMethod;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IZ[[Lorg/apache/derby/iapi/store/access/Qualifier;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZIIIZIIZZDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;����
e6�+	�
g2�F
�
e7�+	�
getColumnFromRow
5(II)Lorg/apache/derby/iapi/types/DataValueDescriptor;��
�
greaterOrEquals
�(Lorg/apache/derby/iapi/types/DataValueDescriptor;Lorg/apache/derby/iapi/types/DataValueDescriptor;)Lorg/apache/derby/iapi/types/BooleanDataValue;��5�
,org/apache/derby/iapi/types/BooleanDataValue�
equals
(Z)Z����
getImmutable
0()Lorg/apache/derby/iapi/types/BooleanDataValue;����
e8�+	�
g3�F
�
e9�+	�
lessThan��5�
_(ZLorg/apache/derby/iapi/types/BooleanDataValue;)Lorg/apache/derby/iapi/types/BooleanDataValue;A�@�
and
^(Lorg/apache/derby/iapi/types/BooleanDataValue;)Lorg/apache/derby/iapi/types/BooleanDataValue;����
java/lang/Exception�`
getIndexRowToBaseRowResultSet
�(JILorg/apache/derby/iapi/sql/execute/NoPutResultSet;IILjava/lang/String;IIIILorg/apache/derby/iapi/services/loader/GeneratedMethod;ZDDI)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;����
like
a(Lorg/apache/derby/iapi/types/DataValueDescriptor;)Lorg/apache/derby/iapi/types/BooleanDataValue;��3�~
e10
+Lorg/apache/derby/iapi/sql/execute/ExecRow;��	�
getValueRow
.(I)Lorg/apache/derby/iapi/sql/execute/ExecRow;��"��
	isNotNull��5�
or����
+org/apache/derby/iapi/types/NumberDataValue�
	notEquals��5��
NULL�
getProjectRestrictResultSet

%(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IIZZZLjava/lang/String;DD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;����
e11�'	�
.org/apache/derby/iapi/sql/execute/ExecIndexRow�
orderedNulls
(I)V�����
	SYSTABLES�
SYSTABLES_INDEX1�?�B����
getTableScanResultSet

?(Lorg/apache/derby/iapi/sql/Activation;JIIILorg/apache/derby/iapi/services/loader/GeneratedMethod;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IZ[[Lorg/apache/derby/iapi/store/access/Qualifier;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZIIIZIZDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;


�
@�vȴ9X
getNestedLoopJoinResultSet
�(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;ILorg/apache/derby/iapi/sql/execute/NoPutResultSet;ILoA<��^��u

	

O�rg/apache/derby/iapi/services/loader/GeneratedMethod;IZZDDLjava/lang/String;)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;

�
	
e12
'	
�
SYSCONGLOMERATES

SYSCONGLOMERATES_INDEX3
?�Q��@,���A_G��5
�
e13
*Lorg/apache/derby/catalog/IndexDescriptor;

	

)org/apache/derby/iapi/types/UserDataValue

(org/apache/derby/catalog/IndexDescriptor
 
e14
.Lorg/apache/derby/iapi/types/BooleanDataValue;
"
#	
$
getNullBoolean
&�@
'
e15
)
#	
*
isUnique
()Z
,
-
!
.
e16
0
	
1
e17
3
#	
4
e18
6
#	
7
isUniqueDeferrable
9
-
!
:�
e19
=�	
>�@4�M��
e20
C'	
D�

SYSCOLUMNS
G
SYSCOLUMNS_INDEX1
I@#����@T�n�_�

e21
P
	
Q
e22
-Lorg/apache/derby/iapi/types/NumberDataValue;
S
T	
U
getNullInteger
\(Lorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue;
W
X@
Y
e23
[
T	
\
g4
^F

_
getKeyColumnPosition
(I)I
a
b
!
c

e24
f�	
g
"@Y�l���<
e25
l�	
m

o
getCharDataValue
q]@
r
e26
t+	
u
e27
w
	
x
e28
z
#	
{
e29
}
#	
~
e30
�
	
�
e31
�
#	
�
e32
�
#	
�
e33
�+	
�
e34
�
T	
�
java/sql/DatabaseMetaData
�
tableIndexOther

S
�
�	
�
�
](SLorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue;A
�@
�
e35
�
	
�
e36
�
T	
�
e37
�
T	
�
g5
�F

�
e38
�
T	
�
getNullShort
�
X@
�
e39
�
	
�
e40
�
#	
�
e41
�
#	
�
e42
�
	
�
e43
�
T	
�
e44
�
T	
�
g6
�F

�
java/lang/Integer
�
isAscending
(Ljava/lang/Integer;)Z
�
�
!
�

A
�

D
�
getNullLong
�
X@
�
)
getSortResultSet
n(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;ZZIIIIDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;
�
��
�

getScrollable
�
-

�
getScrollInsensitiveResultSet
�(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Lorg/apache/derby/iapi/sql/Activation;IIZDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;
�
��
�
)org/apache/derby/iapi/sql/execute/ExecRow
�
row
,[Lorg/apache/derby/iapi/sql/execute/ExecRow;
�
�	
�1-'*+`+~'�+�+�+�+�+�+���'
'


"
#
)
#
0

3
#
6
#
=�
C'
P

S
T
[
T
f�
l�
t+
w

z
#
}
#
�

�
#
�
#
�+
�
T
�

�
T
�
T
�
T
�

�
#
�
#
�

�
T
�
T

	

*��

S
R	


*�*� �&*_�)*�>
�f*_�b*� �&*_��*�>
�f*_��*�>
�f*_��*�>
�f*_��*� ��*_��*� �&*_��*� �&*_�

*� ��*_�
?*� �&*_�
E*� ��*_�
h*� 
��*_�
n*�>
�f*_�
v*�>
�f*_�
�*�>
�
�*_�
�*�
�Z�
�W�S
R	�*
�*�*�*�*�*�*�*�*���
*�*х*w�}*��}
�
�����
�	*̹}����*չ}*޹}*�}�����*�`�*�*q�*��}

�
����
�
����
�

�

*�*� �*�*Q�
*
�}






��	
*
�}

��*
<�}*
@�}
�

��


A
�

	*�*���&*�*��)'
*
F�}


H

J(
K
M��*
H"#$%*
O�}
K
M	��*
e�}*
i�}
 !�
K
M��

K
j
�


*
̹}
�
K
j��+'
K
j�
�*
*�
�
K
j�
�
�S
R	

*��
S
R	n
b*�)*�1�3�8
�:�*�>_
�D*_�U�[*�>_*�-�_Y*_�-*�b_�j*�bY��p�v*�)�EFS
R	
+YH�L�P
�
*S
R	n
b*��*�1�3�8
�:�*�>_
�D*_����*�>_*���_Y*_��*��_�j*��Y��p�v*����FS
R	
+B<��k��u




J�YH�L�P
�
`SR�	



*�1�3�8
�:�*�>_
�D*_���[*�>_*���_Y*_��*��_�j*��Y��p�5Y*���3�5_��Y�����
��*�1�3�8
�:�*�>_
�D*_����*�>_*���_Y*_��*��_�j*��Y��p�5Y*���3�5_��Y�����
�*�>_
��������FS
R	
+YH�L�P
��FS
R	
+YH�L�P
�
~SR�	#
*���3*�1�3���
�SR�	'
*��*���3�5�v*�ٰ
�SR�	

�*�>_
��Y�����
�;*�1�3�5��
Y�����
�*�>_
������Y�����
��*�>_
��Y�����
�L*�>_
�D�5Y*�1���5_��Y�����
�*�>_
������Y�����
�*�>_
�������
�S
R	@
4*��*�1�3�v*��*���3�v*����*��
�S
R	/
#*�

*���3�v*�

��*�

�
�SR�	.
"*	���3�5Y*���3�5_�
�
�SR�	


*	����Y�����
��*�1������*	���
�8
�
!Y*_�
�*�
%*�>_�
(� *�
�
/
*�>_*�
+��Y*_�
+Y�����
�Q*	���
�8
�
!Y*_�
2�*�
5*�>_�
(� *�
2�
;
*�>_*�
8��Y*_�
8���*�>_
��Y�����
�*�>_
�������
�SR�	(
*�
?*	���3�5�v*�
?�
�S
R	/
#*�
E*���3�v*�
E��*�
E�

SR�	.
"*���3�5Y*���3�5_�
�

SR�	�
�*�>_
�D�5Y*	���
�5��
���^*	���
�8
�
!Y*_�
R�*�
V*�>_�
Z�/*�
R*����*_�
`�
d*�>_*�
]�DY*_�
]�*�>_
�D�5_���
^FS
R	
+YH�L�P
�

"SR�	(
*�
h*���3�5�v*�
h�

)SR�	
*�
n
p*�>_
�
s*�
v_�j*�
vY��p�5�v*�
n*	���
�8
�
!Y*_�
y�*�
|*�>_�
(� *�
y�
/
*�>_*�
��Y*_�
Y�����
�Q*	���
�8
�
!Y*_�
��*�
�*�>_�
(� *�
��
;
*�>_*�
���Y*_�
������*�>_
���*�>_
���5�v*�
n
p*�>_
�
s*�
�_�j*�
�Y��p�5�v*�
n�
�*�>_*�
��
�Y*_�
��5�v*�
n*	���
�8
�
!Y*_�
��*�
�*�>_�
Z�/*�
�*����*_�
��
d*�>_*�
��DY*_�
�*�
�_�j*�
��5�v*�
n
*	���
�8
�
!Y*_�
��*�
�*�>_�
(��*�
�*	���
�8
�
!Y*_�
��*�
�*�>_�
Z�/*�
�*����*_�
��
d*�>_*�
��DY*_�
��8
�
��
�*�>_*�
���Y*_�
����
�*�>_
�
s�
�*�>_
�
s�5�v*�
n*�>
�
��5�v*�
n*�>
�
��5�v*�
n
*�>
�f�5�v*�
n�
�FS
R	
+YH�L�P
�
�FS
R	
+YH�L�P
�<
��B޽u

	

O��SELECT CAST ('' AS VARCHAR(128)) AS PKTABLE_CAT, S.SCHEMANAME AS PKTABLE_SCHEM, TABLENAME AS PKTABLE_NAME, COLS.COLUMNNAME AS PKCOLUMN_NAME, CAST ('' AS VARCHAR(128)) AS FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, FKCOLUMN_NAME, CAST (CONGLOMS.DESCRIPTOR.getKeyColumnPosition( COLS.COLUMNNUMBER) AS SMALLINT) AS KEY_SEQ, CAST ((CASE WHEN FK_UPDATERULE='S' THEN java.sql.DatabaseMetaData::importedKeyRestrict ELSE  (CASE WHEN FK_UPDATERULE='R' THEN java.sql.DatabaseMetaData::importedKeyNoAction ELSE java.sql.DatabaseMetaData::importedKeyNoAction END) END)  AS SMALLINT) AS UPDATE_RULE, CAST ((CASE WHEN FK_DELETERULE='S' THEN java.sql.DatabaseMetaData::importedKeyRestrict ELSE  (CASE WHEN FK_DELETERULE='R' THEN java.sql.DatabaseMetaData::importedKeyNoAction ELSE (CASE WHEN FK_DELETERULE='C' THEN java.sql.DatabaseMetaData::importedKeyCascade ELSE (CASE WHEN FK_DELETERULE='U' THEN java.sql.DatabaseMetaData::importedKeySetNull ELSE java.sql.DatabaseMetaData::importedKeyNoAction END) END) END) END)  AS SMALLINT) AS DELETE_RULE, FK_NAME, CONSTRAINTNAME AS PK_NAME, CAST ( (CASE WHEN DEFERREDSTATE = 'E'THEN java.sql.DatabaseMetaData::importedKeyNotDeferrable ELSE ( CASE WHEN DEFERREDSTATE = 'i'THEN java.sql.DatabaseMetaData::importedKeyInitiallyImmediate ELSE java.sql.DatabaseMetaData::importedKeyInitiallyDeferred END) END) AS SMALLINT) AS DEFERRABILITY FROM --DERBY-PROPERTIES joinOrder=FIXED 
(SELECT F2.keyCONSTRAINTID AS FK_ID, FKTB_SCHEMA AS FKTABLE_SCHEM, FKTB_NAME AS FKTABLE_NAME, COLS2.COLUMNNAME AS FKCOLUMN_NAME, CONGLOMS2.DESCRIPTOR.getKeyColumnPosition( COLS2.COLUMNNUMBER) AS KEY_SEQ, C2.CONSTRAINTNAME AS FK_NAME, C2.STATE as DEFERREDSTATE, F2.DELETERULE AS FK_UPDATERULE, F2.DELETERULE AS FK_DELETERULE FROM --DERBY-PROPERTIES joinOrder=FIXED 
(SELECT T2.TABLEID AS FKTB_ID, S2.SCHEMANAME AS FKTB_SCHEMA, T2.TABLENAME AS FKTB_NAME FROM  SYS.SYSTABLES T2 --DERBY-PROPERTIES index = 'SYSTABLES_INDEX1' 
, SYS.SYSSCHEMAS S2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSSCHEMAS_INDEX1' 
WHERE ((1=1) OR ? IS NOT NULL) AND S2.SCHEMANAME LIKE ? AND T2.TABLENAME=? AND S2.SCHEMAID = T2.SCHEMAID ) AS FKTB (FKTB_ID, FKTB_SCHEMA, FKTB_NAME), SYS.SYSCONSTRAINTS c2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCONSTRAINTS_INDEX3' 
, SYS.SYSFOREIGNKEYS F2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSFOREIGNKEYS_INDEX1' 
, SYS.SYSCONGLOMERATES CONGLOMS2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCONGLOMERATES_INDEX1' 
, SYS.SYSCOLUMNS COLS2 --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index =  'SYSCOLUMNS_INDEX1' 
WHERE FKTB.FKTB_ID = C2.TABLEID AND F2.CONSTRAINTID = C2.CONSTRAINTID AND FKTB.FKTB_ID = COLS2.REFERENCEID AND (CASE WHEN CONGLOMS2.DESCRIPTOR IS NOT NULL THEN CONGLOMS2.DESCRIPTOR.getKeyColumnPosition( COLS2.COLUMNNUMBER) ELSE 0 END) <> 0 AND F2.CONGLOMERATEID = CONGLOMS2.CONGLOMERATEID ) AS FKINFO(FK_ID, FKTABLE_SCHEM, FKTABLE_NAME, FKCOLUMN_NAME, KEY_SEQ, FK_NAME, DEFERREDSTATE, FK_UPDATERULE, FK_DELETERULE), SYS.SYSCONSTRAINTS c --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCONSTRAINTS_INDEX1' 
, SYS.SYSTABLES T --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSTABLES_INDEX2' 
, SYS.SYSSCHEMAS S --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSSCHEMAS_INDEX2' 
, SYS.SYSKEYS K --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSKEYS_INDEX1' 
, SYS.SYSCONGLOMERATES CONGLOMS --DERBY-PROPERTIES joinStrategy = NESTEDLOOP, index = 'SYSCONGLOMERATES_INDEX1' 
, SYS.SYSCOLUMNS COLS --DERBY-PROPERTIES joinStrategy=NESTEDLOOP, index = 'SYSCOLUMNS_INDEX1' 
WHERE T.TABLEID = C.TABLEID  AND C.CONSTRAINTID = FKINFO.FK_ID  AND FKINFO.KEY_SEQ = CONGLOMS.DESCRIPTOR.getKeyColumnPosition(  COLS.COLUMNNUMBER) AND S.SCHEMAID = T.SCHEMAID AND K.CONSTRAINTID = C.CONSTRAINTID AND (CASE WHEN CONGLOMS.DESCRIPTOR IS NOT NULL THEN CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER) ELSE 0 END) <> 0  AND K.CONGLOMERATEID = CONGLOMS.CONGLOMERATEID  AND C.TABLEID = COLS.REFERENCEID  ORDER BY PKTD<��1�u




8ABLE_CAT,  PKTABLE_SCHEM, PKTABLE_NAME, PK_NAME, KEY_SEQ<=��'�u

	

O��
)
�
SELECT

9
name

DEFERRABILITY
type�SMALLINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName
SYSCONSTRAINTS
name
PK_NAME
type�VARCHAR�

	columnPos
/

isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
	tableName
C2
name
FK_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
DELETE_RULE
type�SMALLINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
UPDATE_RULE
type�SMALLINT


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
KEY_SEQ
type�SMALLINT


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
	tableName
COLS2
name

FKCOLUMN_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName
FKTB
name
FKTABLE_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName
FKTB
name

FKTABLE_SCHEM
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
FKTABLE_CAT
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName

SYSCOLUMNS
name

PKCOLUMN_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
	tableName
	SYSTABLES
name
PKTABLE_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
	tableName

SYSSCHEMAS
name

PKTABLE_SCHEM
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
name
PKTABLE_CAT
type�VARCHAR�

	columnPos
/

isAutoincrement
/
updatableByCursor
/
p�

9
name

DEFERRABILITY
type�SMALLINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName
SYSCONSTRAINTS
name
PK_NAME
type�VARCHAR�

	columnPos
/

isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
	tableName
C2
name
FK_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
DELETE_RULE
type�SMALLINT


	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
UPDATE_RULE
type�SMALLINT


	columnPos
/

isAutoincrement
/
updatableByCursor
/

9
name
KEY_SEQ
type�SMALLINT


	columnPos
/	
isAutoincrement
/
updatableByCursor
/

9
	tableName
COLS2
name

FKCOLUMN_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName
FKTB
name
FKTABLE_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName
FKTB
name

FKTABLE_SCHEM
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
name
FKTABLE_CAT
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

9
	tableName

SYSCOLUMNS
name

PKCOLUMN_NAME
type�VARCHAR�

	columnPos
/
isAuF<�υ��u

	

O�toincrement
/
updatableByCursor
/

schemaName
SYS

9
	tableName
	SYSTABLES
name
PKTABLE_NAME
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
	tableName

SYSSCHEMAS
name

PKTABLE_SCHEM
type�VARCHAR�

	columnPos
/
isAutoincrement
/
updatableByCursor
/

schemaName
SYS

9
name
PKTABLE_CAT
type�VARCHAR�

	columnPos
/

isAutoincrement
/
updatableByCursor
/
�

�
�
�
���������������������������ur[ZW� 9�]�xp�	
������ur[ZW� 9�]�xp	
���ur[ZW� 9�]�xp�
��ur[ZW� 9�]�xp

�

�

������
�
��NUU

�VARCHAR�
Z��ur[IM�`&v겥xp

h
��

UZ�
�
�
��NUU


�CHAR$
��ur[IM�`&v겥xp





�

�

������

�
�`NUNNN

�VARCHAR�
�CHAR$
Z��ur[IM�`&v겥xp

h
�q
UNZ`�
�
�`NUNNN


�CHAR$
��ur[IM�`&v겥xp





�

�

��������������
�
��NNUNNNP

�CHAR$
Z��ur[IM�`&v겥xp

h
�
!
NZ�
�
�
��NNUNNNP

�CHAR$
�VARCHAR�
�CHAR

��ur[IM�`&v겥xp


p

�

p�������������
�
�NNNNN

�CHAR$
Z��ur[IM�`&v겥xp

h
�

NZ
�
�
�NNNNN

�CHAR$
�CHAR$
�CHAR

��ur[IM�`&v겥xp





�����
�
� NNTUM

MN

�CHAR$
Z��ur[IM�`&v겥xp

h
�1
NZ 
�
�
� NNTUM

MN


�
(org.apache.derby.catalog.IndexDescriptor(org.apache.derby.catalog.IndexDescriptor
����
��ur[IM�`&v겥xp

�
��ur[ZW� 9�]�xp

	 

	�

	 �
����
�
��	NUP



NTTT

�CHAR$
�VARCHAR�
Z��ur[IM�`&v겥xp

h
��
NUZ��
�
��	NUP



NTTT


�INTEGER

��ur[IM�`&v겥xp



`

�

`���������
�
��NNUNNNP

�CHAR$
Z��ur[IM�`&v겥xp

h
�



NZ�
�
�
��NNUNNNP

�CHAR$
�VARCHAR�
��ur[IM�`&v겥xp

P

�

P���������
�
�`NUNNN

�CHAR$
Z��ur[IM�`&v겥xp

h
��

NZ`
�
�
�`NUNNN

�VARCHAR�
�CHAR$
��ur[IM�`&v겥xp

@

�

@�����
�
��NUU

�CHAR$
ZG<�doo�u

	

O���ur[IM�`&v겥xp

h
��

NZ�
�
�
��NUU


�VARCHAR�
��ur[IM�`&v겥xp



@

�

@�����
�
�
0NN

�CHAR$
Z��ur[IM�`&v겥xp

h
�
A

NZ
0
�
�
�
0NN


�CHAR$
��ur[IM�`&v겥xp







���������
�
� NNTUM

MN

�CHAR$
Z��ur[IM�`&v겥xp

h
�1
NZ 
�
�
� NNTUM

MN

�
(org.apache.derby.catalog.IndexDescriptor(org.apache.derby.catalog.IndexDescriptor
����
�CHAR$
��ur[IM�`&v겥xp�
��ur[ZW� 9�]�xp

	�

	�

	��������������
�
��	NUP



NTTT

�CHAR$
Z��ur[IM�`&v겥xp


�
h
��
NUZ��
�
��	NUP



NTTT

�CHAR$
�VARCHAR�
�INTEGER

��ur[IM�`&v겥xp

�VARCHAR�
�VARCHAR�
�VARCHAR�
�VARCHAR�
�VARCHAR�
�VARCHAR�
�VARCHAR�
�VARCHAR�
�SMALLINT

�SMALLINT

�SMALLINT

�VARCHAR�
�VARCHAR�
�SMALLINT

��ur[IM�`&v겥xp
	


<org.apache.derby.exe.ac6965c036x015ax84fbxba5fx00000a0923180
=����-d
<org/apache/derby/exe/ac6965c036x015ax84fbxba5fx00000a0923180

2org/apache/derby/impl/sql/execute/CursorActivation
<init>
()V

Code
postConstructor
createResultSet
'()Lorg/apache/derby/iapi/sql/ResultSet;
0org/apache/derby/impl/sql/execute/BaseActivation

setParameterValueSet
(IZ)V

reinit
throwIfMissingParms

getResultSetFactory
6()Lorg/apache/derby/iapi/sql/execute/ResultSetFactory;

e0
()Ljava/lang/Object;
getExecutionFactory
6()Lorg/apache/derby/iapi/sql/execute/ExecutionFactory;

2org/apache/derby/iapi/sql/execute/ExecutionFactory!
getIndexableRow
3(I)Lorg/apache/derby/iapi/sql/execute/ExecIndexRow;#$"%
0Lorg/apache/derby/iapi/sql/execute/ExecIndexRow;'	(
e1
-Lorg/apache/derby/iapi/types/StringDataValue;*+	,
getParameter
4(I)Lorg/apache/derby/iapi/types/DataValueDescriptor;./
0
+org/apache/derby/iapi/types/StringDataValue2
/org/apache/derby/iapi/types/DataValueDescriptor4
	getObject657
java/lang/String9
getDataValueFactory
0()Lorg/apache/derby/iapi/types/DataValueFactory;;<
=
,org/apache/derby/iapi/types/DataValueFactory?
getDataValue
](ILorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue;AB@C
g0
0(Lorg/apache/derby/iapi/types/NumberDataValue;)I
intG
nullToPrimitiveTest
F(Lorg/apache/derby/iapi/types/DataValueDescriptor;Ljava/lang/String;)VIJ
K
getInt
()IMN5O
-org/apache/derby/iapi/error/StandardExceptionQ

ExceptionsEF
T
 org/apache/derby/iapi/types/LikeV
greaterEqualStringFromParameter
'(Ljava/lang/String;I)Ljava/lang/String;XY
WZ
getVarcharDataValue
n(Ljava/lang/String;Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue;\]@^
e2`+	a
getNullVarchar
\(Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/SH<���su

	

O�tringDataValue;cd@e
setValue
4(Lorg/apache/derby/iapi/types/DataValueDescriptor;)Vgh5i
1org/apache/derby/iapi/types/VariableSizeDataValuek
setWidth
(IIZ)Vmnlo
org/apache/derby/iapi/sql/Rowq
	setColumn
5(ILorg/apache/derby/iapi/types/DataValueDescriptor;)Vstru
7org/apache/derby/iapi/services/loader/GeneratedByteCodex
	getMethod
K(Ljava/lang/String;)Lorg/apache/derby/iapi/services/loader/GeneratedMethod;z{y|
e3~'	
e4�+	�
g1�F
�
lessThanStringFromParameter�Y
W�
e5�+	�*

SYSSCHEMAS�
4{ index=SYSSCHEMAS_INDEX1, joinStrategy=NESTEDLOOP }�
SYSSCHEMAS_INDEX1�?ٙ�����@��p:�~
2org/apache/derby/iapi/sql/execute/ResultSetFactory�
getTableScanResultSet

?(Lorg/apache/derby/iapi/sql/Activation;JIIILorg/apache/derby/iapi/services/loader/GeneratedMethod;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IZ[[Lorg/apache/derby/iapi/store/access/Qualifier;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZIIIZIZDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;����
getIndexRowToBaseRowResultSet
�(JILorg/apache/derby/iapi/sql/execute/NoPutResultSet;IILjava/lang/String;IIIILorg/apache/derby/iapi/services/loader/GeneratedMethod;ZDDI)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;����
getColumnFromRow
5(II)Lorg/apache/derby/iapi/types/DataValueDescriptor;��
�
like
a(Lorg/apache/derby/iapi/types/DataValueDescriptor;)Lorg/apache/derby/iapi/types/BooleanDataValue;��3�
java/lang/Exception�`
e6
+Lorg/apache/derby/iapi/sql/execute/ExecRow;��	�
getValueRow
.(I)Lorg/apache/derby/iapi/sql/execute/ExecRow;��"�~
_(ZLorg/apache/derby/iapi/types/BooleanDataValue;)Lorg/apache/derby/iapi/types/BooleanDataValue;A�@�
,org/apache/derby/iapi/types/BooleanDataValue�
equals
(Z)Z����
getImmutable
0()Lorg/apache/derby/iapi/types/BooleanDataValue;����
	isNotNull��5�
or
^(Lorg/apache/derby/iapi/types/BooleanDataValue;)Lorg/apache/derby/iapi/types/BooleanDataValue;�����
NULL�
getProjectRestrictResultSet

%(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IIZZZLjava/lang/String;DD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;����
e7�'	�
.org/apache/derby/iapi/sql/execute/ExecIndexRow�
orderedNulls
(I)V�����
	SYSTABLES�
{ index=SYSTABLES_INDEX1 }�
SYSTABLES_INDEX1�?��B����@�!-w1
getNestedLoopJoinResultSet
�(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;ILorg/apache/derby/iapi/sql/execute/NoPutResultSet;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IZZDDLjava/lang/String;)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;����
e8�'	��
SYSCONSTRAINTS�
8{ index=SYSCONSTRAINTS_INDEX3, joinStrategy=NESTEDLOOP }�
SYSCONSTRAINTS_INDEX3�@(�\*@1pO�4@+�Ǹ�զ
{ joinOrder=FIXED }�
e9�'	��
SYSFOREIGNKEYS�
8{ index=SYSFOREIGNKEYS_INDEX1, joinStrategy=NESTEDLOOP }


SYSFOREIGNKEYS_INDEX1
@!1�\лp@6�7��ȋ
e10
	'	

�
SYSCONGLOMERATES


:{ index=SYSCONGLOMERATES_INDEX1, joinStrategy=NESTEDLOOP }

SYSCONGLOMERATES_INDEX1
@H1&�x�@f��vF�<@ic�g��M
e11
'	
�

SYSCOLUMNS

4{ index=SYSCOLUMNS_INDEX1, joinStrategy=NESTEDLOOP }

SYSCOLUMNS_INDEX1
!@"�,��@�MMɷn�
)org/apache/derby/iapi/types/UserDataValue
'
e12
*Lorg/apache/derby/catalog/IndexDescriptor;
)
*	
+
(org/apache/derby/catalog/IndexDescriptor
-
e13
-Lorg/apache/derby/iapi/types/NumberDataValue;
/
0	
1
getNullInteger
\(Lorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue;
3
4@
5
e14
7
0	
8
+org/apache/derby/iapi/types/NumberDataValue
:
g2
<F

=
getKeyColumnPosition
(I)I
?
@
.
A
	notEquals
�(Lorg/apacI<��RyFu

	

O�he/derby/iapi/types/DataValueDescriptor;Lorg/apache/derby/iapi/types/DataValueDescriptor;)Lorg/apache/derby/iapi/types/BooleanDataValue;
C
D5
E
	
e15
H�	
I
@�m,�T�
e16
N�	
O
e17
Q
*	
R
e18
T
0	
U
e19
W
0	
X
g3
ZF

[
)
e20
^'	
_
/
8{ index=SYSCONSTRAINTS_INDEX1, joinStrategy=NESTEDLOOP }
b
SYSCONSTRAINTS_INDEX1
d@�z5>G��@���|�A
e21
j'	
k
7
3{ index=SYSTABLES_INDEX2, joinStrategy=NESTEDLOOP }
n
SYSTABLES_INDEX2
p@���ڒ�@���s*��
e22
v'	
w
H
4{ index=SYSSCHEMAS_INDEX2, joinStrategy=NESTEDLOOP }
z
SYSSCHEMAS_INDEX2
|@���x���@�d�׶��
e23
�'	
�
N
e24
0[[Lorg/apache/derby/iapi/store/access/Qualifier;
�
�	
�
reinitializeQualifiers
3([[Lorg/apache/derby/iapi/store/access/Qualifier;)V
�
�

�
/[Lorg/apache/derby/iapi/store/access/Qualifier;
�
allocateQualArray
5([[Lorg/apache/derby/iapi/store/access/Qualifier;II)V
�
�

�
Q
getQualifier
�(IILorg/apache/derby/iapi/services/loader/GeneratedMethod;Lorg/apache/derby/iapi/sql/Activation;ZZZI)Lorg/apache/derby/iapi/store/access/Qualifier;
�
�"
�
setQualifier
c([[Lorg/apache/derby/iapi/store/access/Qualifier;Lorg/apache/derby/iapi/store/access/Qualifier;II)V
�
�

�
SYSKEYS
�
1{ index=SYSKEYS_INDEX1, joinStrategy=NESTEDLOOP }
�
SYSKEYS_INDEX1
�@�LDT��@��.bN(�
e25
�'	
�
T@®Z��@�m��<O
getBulkTableScanResultSet

A(Lorg/apache/derby/iapi/sql/Activation;JIIILorg/apache/derby/iapi/services/loader/GeneratedMethod;ILorg/apache/derby/iapi/services/loader/GeneratedMethod;IZ[[Lorg/apache/derby/iapi/store/access/Qualifier;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZIIIZIIZZDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;
�
��
��
D5
�
W@�i6PƆ
e26
�'	
�
^@�;���A)-@w�
j
e27
�
*	
�
e28
�
0	
�
e29
�
0	
�
g4
�F

�
e30
�
*	
�
e31
�
0	
�
e32
�
0	
�
g5
�F

�
and
���
�
v
e33
��	
�
�A*���ܚs
e34
��	
�

�
getCharDataValue
�]@
�
e35
�+	
�
e36
�+	
�
e37
�
*	
�
e38
�
0	
�
e39
�
0	
�
g6
�F

�
e40
�
0	
�
getNullShort
4@


S
e41
0	
java/sql/DatabaseMetaData
importedKeyRestrict

I
		

R
e42
0	
importedKeyNoAction		
e43
0	
e44
0	
e45
0	
e46
0	 

C"
e47$
0	%
importedKeyCascade'		(

U*
e48,
0	-
importedKeySetNull/		0
e492
0	3
e505
0	6

E8
e51:
0	;
importedKeyNotDeferrable=		>

i@
e52B
0	C
importedKeyInitiallyImmediateE		F
e53H
0	I
importedKeyInitiallyDeferredK		L
e54N
0	O
�
getSortResultSet
n(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;ZZIIIIDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;RS�T

getScrollable
()ZVW
X
getScrollInsensitiveResultSet
�(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Lorg/apache/derby/iapi/sql/Activation;IIZDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Z[�\
)org/apache/derby/iapi/sql/execute/ExecRow^
row
,[Lorg/apache/derby/iapi/sql/execute/ExecRow;`a	b17'*+`+~'�+�+���'�'�'
	'
'
)
*
/
0
7
0
H�
N�
Q
*
T
0
W
0
^'
j'
v'
�'
�
�
�'
�'
�
*
�
0
�
0
�
*
�
0
�
0
��
��
�+
�+
�
*
�
0
�
0
�
0
0
0
0
0
0
0$
0,
02
05
0:
0B
0H
0N
0$

	

*��

S
R	
�


�*�*� �&*_�)*�>
�f*_�b*� �&*_��*�>
�f*_��*� ��*_��*� �&*_��*� �&*_��*� �&*_��*� �&*_�
*� �&*_�
*� ��*_�
J*� 	��*_�
P*� �&*_�
`*� �&*_�
l*� �&*_�
x*� �&*_�
��
�*_�
�*�
��
�*�
�*� *
��}*�
�	�
J<����u

	

O��*� �&*_�
�*� �&*_�
�*� ��*_�
�*� ��*_�
�*�>
�f*_�
�*�>
�f*_�
�*�>
�*_�
�*�>
�*_�*�>
�*_�7*�>
�*_�P*+�_Z�cW�S
R	�2
�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*�*���*�*х
*w�}*��}
��������


����*��}*��}*ʹ}	�����*�`�*�*q�*ڹ}

�������
����
��
��


����*���*�*
!� *�}

�������!�
����

�����*��&*�*�('*��}




�
��)
"#$%
�
��
	�
���*� �.*�*1�0/*
�}






��1
*+,-


��


���
*�*���8*�*��:9*
�}



 
"
#
%��;
4567

#
%	��*
G�}*
K�}
23�
#
%��

#
L���
*
]�}
�
#
L��	*���@*�*

�BA*
a�}

�
c
e
#
f��C�<=>?

#
f��

#
h���*�`�H*�*��JI*
m�}

�
o
q
#
r��K�DEFG

#
r��

#
t���*���P*�*�RQ!*
y�}

�
{
}
#
~��S �LMNO

#
~��

#
����*�
0�X*�*
A�ZY#*
��}
*�
�
�
�
�
#
���["
�TUVW

#
���

#
����*� �`*�*1�ba%*
��}





�
��
�c$
\]^_*
��}
�
���

�
����*�*���j*�*��mk'*
��}



 
"l
�
��
�n&
fghi*
��}
�
�	��*
ܹ}*
�}(
de�
�
���

�
����
*Q�})
�
�
��o
*
�
�U**�Y
�
�]
�S
R	

*�*�
��
��
S
R	n
b*�)*�1�3�8
�:�*�>_
�D*_�U�[*�>_*�-�_Y*_�-*�b_�j*�bY��p�v*�)�EFS
R	
+YH�L�P
�
*S
R	n
b*��*�1�3�8
�:�*�>_
�D*_����*�>_*���_Y*_��*��_�j*��Y��p�v*����FS
R	
+YH�L�P
�
`SR�	$
*���3*�1�3���
~SR�	(
*��*���3�5�v*���
�SR�	c
W*�>_
��Y�����
�;*�1�3�5��
Y�����
�*�>_
�������
�S
R	A
5*��*�1�3�v*��*���3�v*����*�Ӱ
�S
R	/
#*��*���3�v*����*��
�S
R	/
#*��*���3�v*����*���
�S
R	/
#*�
*���3�v*�
��*�
�
�S
R	/
#*�
*���3�v*�
��*�
�

	SR�	�
�*�>_
�D�5Y*���
(�5��
���^*���
(�8
�
.Y*_�
,�*�
2*�>_�
6�/*�
,*���
;*_�
>�
B*�>_*�
9�DY*_�
9�*�>_
�D�5_�
F�
<FS
R	
+YH�L�P
�

SR�	(
*�
J*���3�5�v*�
J�

)SR�	x
l*�
P*���
(�8
�
.Y*_�
S�*�
V*�>_�
6�0*�
S*���
;*_�
\�
B*�>_*�
Y�DY*_�
Y�5�v*�
P�
ZFS
R	
+YH�L�P
�

/S
R	/
#*�
`*���3�v*�
`��*�
`�

7S
R	/
#*�
l*���3�v*�
l��*�
l�

HS
R	/
#*�
x*���3�v*�
x��*�
x�

NS
R	/
#*�
�*���3�v*�
���*�
��

QSR�	
*���3�

TS
R	/
#*�
�*"���3�v*�
���*�
��

WSR�	.
"*$���3�5Y*"���3�5_�
��

^S
R	/
#*�
�*���3�K<�:P{u




F�v*�
���*�
��

jSR�	.
"*&���3�5Y*���3�5_�
��

vSR�	
Q

E*�>_
�D�5Y*$���
(�5��
���^*$���
(�8
�
.Y*_�
��*�
�*�>_�
6�/*�
�*&���
;*_�
̹
B*�>_*�
ɹDY*_�
ɧ*�>_
�D�5_�
FY�����
��*$���
(�8
�
.Y*_�
��*�
�*�>_�
6�/*�
�*&���
;*_�
ع
B*�>_*�
չDY*_�
��5Y*���
;�5_�
�Y�����
�*�>_
���
��
��
�FS
R	
+YH�L�P
�
�FS
R	
+YH�L�P
�

�SR�	(
*�
�*&���3�5�v*�
߰

�SR�	�
�*�
�
�*�>_
�
�*�
�_�j*�
�Y��p�5�v*�
�
�*�>_
�
�*�
�_�j*�
�Y��p�5�v*�
�	*���
(�8
�
.Y*_�
��*�
�*�>_�
6�/*�
�*���
;*_�
��
B*�>_*�
��DY*_�
�*�
�_�j*�
��5�v*�
�
*�>_
�
��5Y*���3�5_�
�����
*�>_*��DY*_��b*�>_
�
��5Y*���3�5_�
�����*�>_*��DY*_���*�>_*��DY*_�*�_�j*��5�v*�
�*�>_
�
��5Y*	���3�5_�
�����
*�>_*��DY*_���*�>_
�
��5Y*	���3�5_�
�����*�>_*�!�DY*_�!��#*�>_
�
��5Y*	���3�5_�
�����)*�>_*�&�DY*_�&�b+*�>_
�
��5Y*	���3�5_�
�����1*�>_*�.�DY*_�.��*�>_*�4�DY*_�4*�7_�j*�7�5�v*�
�9*�>_
�
��5Y*���3�5_�
�����?*�>_*�<�DY*_�<�bA*�>_
�
��5Y*���3�5_�
�����G*�>_*�D�DY*_�D��M*�>_*�J�DY*_�J*�P_�j*�P�5�v*�
�
�FS
R	
+YH�L�P
�<�����u
g��u
g��