v#Pt ?x '"0#((Dm;u )0 NUNNMN M &$c065801d-0114-21b2-f1c4-000000156b98 getUDTs&$8000000d-00d0-fd77-3ed8-000a0a0b1900SAUSSELECT '' AS TYPE_CAT, '' AS TYPE_SCHEM, ALIAS AS TYPE_NAME, JAVACLASSNAME AS CLASS_NAME, CAST (? AS INT) AS DATA_TYPE, '' AS REMARKS, CAST (NULL AS SMALLINT) AS BASE_TYPE FROM SYS.SYSALIASES WHERE ((1=1) OR ? IS NOT NULL) AND ((1=1) OR ? IS NOT NULL) AND ALIAS LIKE ? AND ?<>0 AND ALIASTYPE = 'C' ORDER BY DATA_TYPE, TYPE_SCHEM, TYPE_NAME&$8000000d-00d0-fd77-3ed8-000a0a0b1900 &$286cc01e-0114-21b2-f1c4-000000156b98getTablePrivileges&$8000000d-00d0-fd77-3ed8-000a0a0b1900SHSELECT 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-000a0a0b1900W Fk</vb\u &$6074401f-0114-21b2-f1c4-000000156b98odbc_getIndexInfo&$8000000d-00d0-fd77-3ed8-000a0a0b1900SGMKSELECT JDBC_SUBQUERY.TABLE_CAT AS TABLE_CAT, JDBC_SUBQUERY.TABLE_SCHEM AS TABLE_SCHEM, JDBC_SUBQUERY.TABLE_NAME AS TABLE_NAME, CAST (JDBC_SUBQUERY.NON_UNIQUE 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() 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 INT) AS CARDINALITY, CAST(NULL AS INT) 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() 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<2u  &$787c0020-0114-21b2-f1c4-000000156b98odbc_getColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900S&$8000000d-00d0-fd77-3ed8-000a0a0b1900 &$80840021-0114-21b2-f1c4-000000156b98&$getBestRowIdentifierUniqueKeyColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900SExvSELECT 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 &$40a68025-0114-21b2-f1c4-000000156b98getProcedureColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900SEqoSELECT 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 &$e8afc026-0114-21b2-f1c4-000000156b98&$getBestRowIdentifierUniqueConstraint&$8000000d-00d0-fd77-3ed8-000a0a0b1900SB SELECT CONS.CONSTRAINTID, IDX.DESCRIPTOR.numberOfOrderedColumns() AS NUMCOLS 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&$8000000d-00d0-fd77-3ed8-000a0a0b1900  ,<8QuOSELECT 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_CATLOG AS SCOPE_CATLOG, 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 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 ' || (CAST (RTRIM(CAST(AUTOINCREMENTSTART AS CHAR(12))) AS VARCHAR(12))) || ' increment ' || (CAST (RTRIM(CAST(AUTOINCREMENTINC AS CHAR(12))) AS VARCHAR(12))) END ) ELSE CAST (COLUMNDEFAULT AS VARCHAR(254)) END AS COLUMN_DEF, CAST( NULL AS INT) AS SQL_DATA<uDo_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_CATLOG, 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, 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<u..u  &$888c4022-0114-21b2-f1c4-000000156b98odbc_getTypeInfo&$8000000d-00d0-fd77-3ed8-000a0a0b1900S&$8000000d-00d0-fd77-3ed8-000a0a0b1900 &$a094c023-0114-21b2-f1c4-000000156b98%#odbc_getBestRowIdentifierAllColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900SFywSELECT 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 &$d89d8024-0114-21b2-f1c4-000000156b98getProcedures40&$8000000d-00d0-fd77-3ed8-000a0a0b1900SBSELECT 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 $,<3*DtuOSELECT 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 (JDBC_SUBQUERY.CASE_SENSITIVE AS SMALLINT) AS CASE_SENSITIVE, JDBC_SUBQUERY.SEARCHABLE AS SEARCHABLE, CAST (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 CAST (NULL AS SMALLINT) END AS SMALLINT) AS UNSIGNED_ATTRIBUTE, CAST (JDBC_SUBQUERY.FIXED_PREC_SCALE AS SMALLINT) AS FIXED_PREC_SCALE, CAST (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 CAST (NULL AS SMALLINT) 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,'''','''','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 (N< FjHuGULL 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)), ('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,26,'TIMESTAMP''','''',CAST (NULL AS CHAR), 1,FALSE,2,TRUE,FALSE,FALSE,0,6,10),('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) ) JDBC_SUBQUERY< :=u &$e0b94027-0114-21b2-f1c4-000000156b98getColumnPrivileges_10_1&$8000000d-00d0-fd77-3ed8-000a0a0b1900SBSELECT 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<֮u &$38c30028-0114-21b2-f1c4-000000156b98 getTypeInfo&$8000000d-00d0-fd77-3ed8-000a0a0b1900SM 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)), ('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,26,'TIMESTAMP''','''',CAST (NULL AS CHAR), 1,FALSE,2,TRUE,FALSE,FALSE,0,6,10),('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)&$8000000d-00d0-fd77-3ed8-000a0a0b1900<tu &$00cd0029-0114-21b2-f1c4-000000156b98getTablePrivileges_10_1&$8000000d-00d0-fd77-3ed8-000a0a0b1900SASELECT 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 &$48d7402a-0114-21b2-f1c4-000000156b98getSuperTables&$8000000d-00d0-fd77-3ed8-000a0a0b1900S@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 &$98ec802c-0114-21b2-f1c4-000000156b98getVersionColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900SASELECT 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 &$c0f7802d-0114-21b2-f1c4-000000156b98odbc_getProcedures&$8000000d-00d0-fd77-3ed8-000a0a0b1900SBPNSELECT 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 &$a902c02e-0114-21b2-f1c4-000000156b98 getSchemas&$8000000d-00d0-fd77-3ed8-000a0a0b1900S@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 &$f91a0030-0114-21b2-f1c4-000000156b98odbc_getVersionColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900SCSELECT 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 &$aaeec04e-0114-21b2-f1c4-000000156b98 GETCATALOGS&$c013800d-00f8-5b53-28a9-00000019ed88S86CALL SYSIBM.SQLTABLES('', '', '', '', 'GETCATALOGS=1')&$c013800d-00f8-5b53-28a9-00000019ed88a  cGq98f<lu &$20e1c02b-0114-21b2-f1c4-000000156b98getCrossReference&$8000000d-00d0-fd77-3ed8-000a0a0b1900SNSELECT 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 (java.sql.DatabaseMetaData::importedKeyNotDeferrable 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&$8000000d-00d0-fd77-3ed8-000a0a0b1900<yЋu &$610e402f-0114-21b2-f1c4-000000156b98odbc_getCrossReference&$8000000d-00d0-fd77-3ed8-000a0a0b1900SNSELECT 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 (java.sql.DatabaseMetaData::importedKeyNotDeferrable 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&$8000000d-00d0-fd77-3ed8-000a0a0b1900<;u  &$81260031-0114-21b2-f1c4-000000156b98getFunctionColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900SG~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, CAST((V."PARAMETER_ID" + 1) AS INT) 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 ? OR V."COLUMN_NAME" = ?) ORDER BY FUNCTION_SCHEM, FUNCTION_NAME, SPECIFIC_NAME, ORDINAL_POSITION&$8000000d-00d0-fd77-3ed8-000a0a0b1900 &$09324032-0114-21b2-f1c4-000000156b98 getAttributes&$8000000d-00d0-fd77-3ed8-000a0a0b1900SCdbSELECT 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 &$a13ec033-0114-21b2-f1c4-000000156b98 getFunctions&$8000000d-00d0-fd77-3ed8-000a0a0b1900SBDBSELECT 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, 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 `_<#u  &$594b8034-0114-21b2-f1c4-000000156b98 getTables&$8000000d-00d0-fd77-3ed8-000a0a0b1900SC,*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&$8000000d-00d0-fd77-3ed8-000a0a0b1900 &$41588035-0114-21b2-f1c4-000000156b98getClientInfoProperties&$8000000d-00d0-fd77-3ed8-000a0a0b1900S@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 &$6965c036-0114-21b2-f1c4-000000156b98 getBestRowIdentifierAllColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900SDJHSELECT 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-000a0a0b1900rp<u  &$e1734037-0114-21b2-f1c4-000000156b98getProcedureColumns40&$8000000d-00d0-fd77-3ed8-000a0a0b1900SHMKSELECT 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 &$b9810038-0114-21b2-f1c4-000000156b98getBestRowIdentifierEmpty&$8000000d-00d0-fd77-3ed8-000a0a0b1900SASELECT 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 &$018f0039-0114-21b2-f1c4-000000156b98 getBestRowIdentifierPrimaryKey&$8000000d-00d0-fd77-3ed8-000a0a0b1900SAPNSELECT 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 ` /1<u  &$c99d403a-0114-21b2-f1c4-000000156b98-+odbc_getBestRowIdentifierUniqueIndexColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900SFSELECT 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 &$21abc03b-0114-21b2-f1c4-000000156b98getColumnPrivileges&$8000000d-00d0-fd77-3ed8-000a0a0b1900SDSELECT 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 &$19ba803c-0114-21b2-f1c4-000000156b98 getTableTypes&$8000000d-00d0-fd77-3ed8-000a0a0b1900S@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 H?y</au &$c1c9803d-0114-21b2-f1c4-000000156b98getPrimaryKeys&$8000000d-00d0-fd77-3ed8-000a0a0b1900SESELECT 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<"+ȑu &$29d8c03e-0114-21b2-f1c4-000000156b98 getColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900SL; 9SELECT 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 ' || (CAST (RTRIM(CAST(AUTOINCREMENTSTART AS CHAR(12))) AS VARCHAR(12))) || ' increment ' || (CAST (RTRIM(CAST(AUTOINCREMENTINC AS CHAR(12))) AS VARCHAR(12))) 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_CATLOG, 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 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&$8000000d-00d0-fd77-3ed8-000a0a0b1900< @u  &$61e8403f-0114-21b2-f1c4-000000156b98 getIndexInfo&$8000000d-00d0-fd77-3ed8-000a0a0b1900SDSELECT CAST ('' AS VARCHAR(128)) AS TABLE_CAT, S.SCHEMANAME AS TABLE_SCHEM, T.TABLENAME AS TABLE_NAME, (CASE WHEN CONGLOMS.DESCRIPTOR.isUnique() 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 INT) AS CARDINALITY, CAST(NULL AS INT) 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() ELSE (1=1) END) AND ((1=1) OR ?<>0) ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION&$8000000d-00d0-fd77-3ed8-000a0a0b1900 &$79f80040-0114-21b2-f1c4-000000156b98,*odbc_getBestRowIdentifierPrimaryKeyColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900SGtrSELECT 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 &$82080041-0114-21b2-f1c4-000000156b98 getSuperTypes&$8000000d-00d0-fd77-3ed8-000a0a0b1900SA 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 .<u  &$8a184042-0114-21b2-f1c4-000000156b98+)odbc_getBestRowIdentifierUniqueKeyColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900SGSELECT 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 &$a228c043-0114-21b2-f1c4-000000156b98'%getBestRowIdentifierPrimaryKeyColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900SEECSELECT 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<ag+u  &$da398044-0114-21b2-f1c4-000000156b98 getProcedures&$8000000d-00d0-fd77-3ed8-000a0a0b1900SB;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 &$424a8045-0114-21b2-f1c4-000000156b98 getCatalogs&$8000000d-00d0-fd77-3ed8-000a0a0b1900S@JHSELECT TABLE_CAT FROM ( VALUES ('') ) AS CATALOGS(TABLE_CAT) WHERE (1=0)&$8000000d-00d0-fd77-3ed8-000a0a0b1900<Qu &$ea5bc046-0114-21b2-f1c4-000000156b98getImportedKeys&$8000000d-00d0-fd77-3ed8-000a0a0b1900SNSELECT 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 (java.sql.DatabaseMetaData::importedKeyNotDeferrable 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, 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, 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 PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, PK_NAME, KEY_SEQ&$8000000d-00d0-fd77-3ed8-000a0a0b1900<sѣu  &$e26d4047-0114-21b2-f1c4-000000156b98!getBestRowIdentifierUniqueIndex&$8000000d-00d0-fd77-3ed8-000a0a0b1900SASELECT 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() END) AND ((1=1) OR ? IS NOT NULL) AND (SCHEMAS.SCHEMANAME LIKE ?) AND (TABS.TABLENAME=?) ORDER BY NUMCOLS&$8000000d-00d0-fd77-3ed8-000a0a0b1900 &$3a7f0048-0114-21b2-f1c4-000000156b98(&getBestRowIdentifierUniqueIndexColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900SDSELECT 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^<h Ou  &$02910049-0114-21b2-f1c4-000000156b98odbc_getProcedureColumns&$8000000d-00d0-fd77-3ed8-000a0a0b1900SM 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 &$4aa3404a-0114-21b2-f1c4-000000156b98 SQLUDTS&$c013800d-00f8-5b53-28a9-00000019ed88S$"CALL SYSIBM.SQLUDTS(?, ?, ?, ?, ?)&$c013800d-00f8-5b53-28a9-00000019ed88 < e u  &$22b5c04b-0114-21b2-f1c4-000000156b98 METADATA&$c013800d-00f8-5b53-28a9-00000019ed88SM 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 &$9ac8804c-0114-21b2-f1c4-000000156b98 SQLSTATISTICS&$c013800d-00f8-5b53-28a9-00000019ed88S-+CALL SYSIBM.SQLSTATISTICS(?, ?, ?, ?, ?, ?)&$c013800d-00f8-5b53-28a9-00000019ed88 &$c2db804d-0114-21b2-f1c4-000000156b98 SQLCOLUMNS&$c013800d-00f8-5b53-28a9-00000019ed88S'%CALL SYSIBM.SQLCOLUMNS(?, ?, ?, ?, ?)&$c013800d-00f8-5b53-28a9-00000019ed88 < u  &$6302404f-0114-21b2-f1c4-000000156b98 SQLPROCEDURES&$c013800d-00f8-5b53-28a9-00000019ed88S'%CALL SYSIBM.SQLPROCEDURES(?, ?, ?, ?)&$c013800d-00f8-5b53-28a9-00000019ed88 &$fb160050-0114-21b2-f1c4-000000156b98 SQLTABLES&$c013800d-00f8-5b53-28a9-00000019ed88S&$CALL SYSIBM.SQLTABLES(?, ?, ?, ?, ?)&$c013800d-00f8-5b53-28a9-00000019ed88 &$832a0051-0114-21b2-f1c4-000000156b98SQLCOLPRIVILEGES&$c013800d-00f8-5b53-28a9-00000019ed88S-+CALL SYSIBM.SQLCOLPRIVILEGES(?, ?, ?, ?, ?)&$c013800d-00f8-5b53-28a9-00000019ed88 &$0b3e4052-0114-21b2-f1c4-000000156b98 GETSCHEMAS&$c013800d-00f8-5b53-28a9-00000019ed88S75CALL SYSIBM.SQLTABLES('', '', '', '', 'GETSCHEMAS=1')&$c013800d-00f8-5b53-28a9-00000019ed88 &$a352c053-0114-21b2-f1c4-000000156b98SQLFOREIGNKEYS&$c013800d-00f8-5b53-28a9-00000019ed88S1/CALL SYSIBM.SQLFOREIGNKEYS(?, ?, ?, ?, ?, ?, ?)&$c013800d-00f8-5b53-28a9-00000019ed88 &$5b678054-0114-21b2-f1c4-000000156b98SQLPROCEDURECOLS&$c013800d-00f8-5b53-28a9-00000019ed88S-+CALL SYSIBM.SQLPROCEDURECOLS(?, ?, ?, ?, ?)&$c013800d-00f8-5b53-28a9-00000019ed88 &$437c8055-0114-21b2-f1c4-000000156b98SQLSPECIALCOLUMNS&$c013800d-00f8-5b53-28a9-00000019ed88S42CALL SYSIBM.SQLSPECIALCOLUMNS(?, ?, ?, ?, ?, ?, ?)&$c013800d-00f8-5b53-28a9-00000019ed88 &$6b91c056-0114-21b2-f1c4-000000156b98 GETTABLETYPES&$c013800d-00f8-5b53-28a9-00000019ed88S:8CALL SYSIBM.SQLTABLES('', '', '', '', 'GETTABLETYPES=1')&$c013800d-00f8-5b53-28a9-00000019ed88 &$e3a74057-0114-21b2-f1c4-000000156b98SQLGETTYPEINFO&$c013800d-00f8-5b53-28a9-00000019ed88S" CALL SYSIBM.SQLGETTYPEINFO(?, ?)&$c013800d-00f8-5b53-28a9-00000019ed88 &$bbbd0058-0114-21b2-f1c4-000000156b98SQLTABLEPRIVILEGES&$c013800d-00f8-5b53-28a9-00000019ed88S,*CALL SYSIBM.SQLTABLEPRIVILEGES(?, ?, ?, ?)&$c013800d-00f8-5b53-28a9-00000019ed88 &$03d30059-0114-21b2-f1c4-000000156b98SQLPRIMARYKEYS&$c013800d-00f8-5b53-28a9-00000019ed88S(&CALL SYSIBM.SQLPRIMARYKEYS(?, ?, ?, ?)&$c013800d-00f8-5b53-28a9-00000019ed88*](Z<I;u &$74d240cf-0114-21b2-f1c4-000000156b98@WUTRIGGERACTN_bc9ec0ce-0114-21b2-f1c4-000000156b98_ce8780ad-0114-21b2-f1c4-000000156b98&$80000000-00d2-b38f-4cda-000a0a412c00TDmkINSERT INTO FLIGHTS_HISTORY VALUES (CAST (org.apache.derby.iapi.db.Factory::getTriggerExecutionContext().getOldRow().getObject(1) AS CHAR(6)) , CAST (org.apache.derby.iapi.db.Factory::getTriggerExecutionContext().getOldRow().getObject(2) AS INTEGER) , CAST (org.apache.derby.iapi.db.Factory::getTriggerExecutionContext().getOldRow().getObject(3) AS CHAR(3)) ,CAST (org.apache.derby.iapi.db.Factory::getTriggerExecutionContext().getOldRow().getObject(4) AS TIME) , CAST (org.apache.derby.iapi.db.Factory::getTriggerExecutionContext().getOldRow().getObject(5) AS CHAR(3)) ,CAST (org.apache.derby.iapi.db.Factory::getTriggerExecutionContext().getOldRow().getObject(6) AS TIME) ,CAST (org.apache.derby.iapi.db.Factory::getTriggerExecutionContext().getOldRow().getObject(7) AS CHAR(1)) , CAST (org.apache.derby.iapi.db.Factory::getTriggerExecutionContext().getOldRow().getObject(8) AS DOUBLE) , CAST (org.apache.derby.iapi.db.Factory::getTriggerExecutionContext().getOldRow().getObject(9) AS INTEGER) , CAST (org.apache.derby.iapi.db.Factory::getTriggerExecutionContext().getOldRow().getObject(10) AS VARCHAR(6)) ,'INSERTED FROM TRIG1') 4:c&$80000000-00d2-b38f-4cda-000a0a412c00<e5BuO)& NPN+N+NOPUUk![@ APPFLIGHTS_HISTORY  FLIGHT_IDSEGMENT_NUMBER ORIG_AIRPORT DEPART_TIME DEST_AIRPORT ARRIVE_TIMEMEAL FLYING_TIMEMILESAIRCRAFTSTATUSINSERT 9nameSTATUStype VARCHARVARCHAR columnPos/ isAutoincrement/updatableByCursor/9nameAIRCRAFTtype VARCHARVARCHAR columnPos/ isAutoincrement/updatableByCursor/9nameMILEStypeINTEGERINTEGER  columnPos/ isAutoincrement/updatableByCursor/9name FLYING_TIMEtypeDOUBLEDOUBLE4 columnPos/isAutoincrement/updatableByCursor/9nameMEALtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/9name ARRIVE_TIMEtype#!TIME!TIME columnPos/isAutoincrement/updatableByCursor/9name DEST_AIRPORTtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/9name DEPART_TIMEtype#!TIME!TIME columnPos/isAutoincrement/updatableByCursor/9name ORIG_AIRPORTtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/9nameSEGMENT_NUMBERtypeINTEGERINTEGER  columnPos/isAutoincrement/updatableByCursor/9name FLIGHT_IDtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/ 9nameSTATUStype VARCHARVARCHAR columnPos/ isAutoincrement/updatableByCursor/9nameAIRCRAFTtype VARCHARVARCHAR columnPos/ isAutoincrement/updatableByCursor/9nameMILEStypeINTEGERINTEGER  columnPos/ isAutoincrement/updatableByCursor/9name FLYING_TIMEtypeDOUBLEDOUBLE4 columnPos/isAutoincrement/updatableByCursor/9nameMEALtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/9name ARRIVE_TIMEtype#!TIME!TIME columnPos/isAutoincrement/updatableByCursor/9name DEST_AIRPORTtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/9name DEPART_TIMEtype#!TIME!TIME columnPos/isAutoincrement/updatableByCursor/9name ORIG_AIRPORTtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/9nameSEGMENT_NUMBERtypeINTEGERINTEGER  columnPos/isAutoincrement/updatableByCursor/9name FLIGHT_IDtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/()V  CodepostConstructorexecute'()Lorg/apache/derby/iapi/sql/ResultSet;  throwIfClosed(Ljava/lang/String;)V  startExecution   fillResultSetget<-tuOResultSetFactory6()Lorg/apache/derby/iapi/sql/execute/ResultSetFactory;  e0()Ljava/lang/Object;+Lorg/apache/derby/iapi/sql/execute/ExecRow;  getExecutionFactory6()Lorg/apache/derby/iapi/sql/execute/ExecutionFactory;  !2org/apache/derby/iapi/sql/execute/ExecutionFactory# getValueRow.(I)Lorg/apache/derby/iapi/sql/execute/ExecRow; %& $'e1Ljava/sql/ResultSet; )* +e22Lorg/apache/derby/iapi/db/TriggerExecutionContext; -. / org/apache/derby/iapi/db/Factory1getTriggerExecutionContext4()Lorg/apache/derby/iapi/db/TriggerExecutionContext; 34 250org/apache/derby/iapi/db/TriggerExecutionContext7 getOldRow()Ljava/sql/ResultSet; 9: 8;e3+Lorg/apache/derby/iapi/types/UserDataValue; => ?getDataValueFactory0()Lorg/apache/derby/iapi/types/DataValueFactory; AB C,org/apache/derby/iapi/types/DataValueFactoryE getNullObjectX(Lorg/apache/derby/iapi/types/UserDataValue;)Lorg/apache/derby/iapi/types/UserDataValue; GH FIe4 K> L getDataValue](ILorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue; NO FPg00(Lorg/apache/derby/iapi/types/NumberDataValue;)IintTnullToPrimitiveTestF(Lorg/apache/derby/iapi/types/DataValueDescriptor;Ljava/lang/String;)V VW X/org/apache/derby/iapi/types/DataValueDescriptorZgetInt()I \] [^-org/apache/derby/iapi/error/StandardException` Exceptions RS cjava/sql/ResultSete getObject(I)Ljava/lang/Object; gh fij(Ljava/lang/Object;Lorg/apache/derby/iapi/types/UserDataValue;)Lorg/apache/derby/iapi/types/UserDataValue; Nk Fle5-Lorg/apache/derby/iapi/types/StringDataValue; no p getNullChar\(Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue; rs Ft g [vjava/lang/Stringxjava.lang.StringzsetObjectForCast((Ljava/lang/Object;ZLjava/lang/String;)V |} [~1org/apache/derby/iapi/types/VariableSizeDataValuesetWidth(IIZ)V org/apache/derby/iapi/sql/Row setColumn5(ILorg/apache/derby/iapi/types/DataValueDescriptor;)V e6 * e7 . e8 > e9 > g1 S e10-Lorg/apache/derby/iapi/types/NumberDataValue; getNullInteger\(Lorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue; Fjava/lang/Integerjava.lang.Integere11 * e12 . e13 > e14 > g2 S e15 o e16 * e17 . e18 > e19 > g3 S e20/Lorg/apache/derby/iapi/types/DateTimeDataValue;  getNullTime`(Lorg/apache/derby/iapi/types/DateTimeDataValue;)Lorg/apache/derby/iapi/types/DateTimeDataValue; F java/sql/Time java.sql.Timee21 * e22 . e23 > e24 > g4 S e25 o e26 * e27 . e28 > e29 > g5 S e30 e31 * e32 . e33 > e34 > g6 S e35 o e36  *  e37  . e38 > e39 > g7 S e40   getNullDouble  Fjava/lang/Doublejava.lang.Double!e41 #* $e42 &. 'e43 )> *e44 ,> -g8 /S 0e45 2 3e46 5* 6e47 8. 9e48 ;> <e49 >> ?g9 AS Be50 Do EgetNullVarchar Gs FHINSERTED FROM TRIG1JgetVarcharDataValuen(Ljava/lang/String;Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue; LM FNjava/lang/ExceptionP7org/apache/derby/iapi/services/loader/GeneratedByteCodeS getMethodK(Ljava/lang/String;)Lorg/apache/derby/iapi/services/loader/GeneratedMethod; UV TW?2org/apache/derby/iapi/sql/execute/ResultSetFactory[getRowResult<5suOUSet(Lorg/apache/derby/iapi/sql/Activation;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;ZIDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet; ]^ \_getNormalizeResultSetk(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;IIDDZ)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet; ab \cgetInsertResultSet(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;)Lorg/apache/derby/iapi/sql/ResultSet; ef \g resultSet%Lorg/apache/derby/iapi/sql/ResultSet; ij k  mgetExecutionCountI op qsetExecutionCount(I)VgetRowCountCheckVectorLjava/util/Vector; uv w()Ljava/util/Vector;setRowCountCheckVector(Ljava/util/Vector;)VgetStalePlanCheckInterval |p }setStalePlanCheckInterval)org/apache/derby/iapi/sql/execute/ExecRowrow,[Lorg/apache/derby/iapi/sql/execute/ExecRow;  16)*-.=>K>no*.>>*.>>o*.>>*.>>o*.>>*.>>o * .>>#*&.)>,>25*8.;>>>Do op uv |p * ba *" (*_*Du*_q*D*_*Du*_*D*_*Du*_*D*_*Du*_ *D*_*D*_4*DI*_F* K*D_O[*ZW ba /#* **l*n*_Zl*l ba @ 4*****RXY` Yd hbaQ *6Y*_0 *0<Y*_,*@*D_J1*,*D_Q*_dj*D_*MmY*_Mw*q_Yy{*qY[*6Y*_ *<Y*_**D_J1**D_Q*_j*D_*mY*_w*_Y*[*6Y*_ *<Y*_**D_J1**D_Q*_j*D_*mY*_w*_Yy{*Y[*6Y*_ *<Y*_**D_J1**D_Q*_ǹj*D_*ĹmY*_Ĺw*_Yӹ*[*6Y*_ *ٹ<Y*_**D_J1**D_Q*_j*D_*߹mY*_߹w*_Yy{*Y[*6Y*_ *<Y*_**D_J2**D_Q*_j*D_*mY*_w*_Yӹ*[*6Y*_ *<Y*_**D_J2**D_Q*_j*D_*mY*_w* _Yy{* Y[*6Y*_ *<Y*_ **D_J2* *D_Q*_j*D_*mY*_w*_Y "*[* 6Y*_( *(<Y*_%*+*D_J2*% *D_Q*_1j*D_*.mY*_.w*4_Y*4[* 6Y*_: *:<Y*_7*=*D_J2*7 *D_Q*_Cj*D_*@mY*_@w*F_Yy{*FY[*RSba  +YUY_Sba  +YUY_Sba  +YUY_Sba  +YUY_Sba  +YUY_Sba  +YUY_Sba  +YUY_Sba  +YUY_/Sba  +YUY_ASba  +YUY_o] rst ruy xz{ +x|] ~t ~<[~u &$560c80d5-0114-21b2-f1c4-000000156b98@WUTRIGGERACTN_6dd780d4-0114-21b2-f1c4-000000156b98_ce8780ad-0114-21b2-f1c4-000000156b98&$80000000-00d2-b38f-4cda-000a0a412c00T@ECINSERT INTO FLIGHTS_HISTORY (STATUS) VALUES ('INSERTED FROM TRIG2') 4&$80000000-00d2-b38f-4cda-000a0a412c00!<=,x5uO)& NPN+N+NOPUUk![@ APPFLIGHTS_HISTORY  FLIGHT_IDSEGMENT_NUMBER ORIG_AIRPORT DEPART_TIME DEST_AIRPORT ARRIVE_TIMEMEAL FLYING_TIMEMILESAIRCRAFTSTATUSINSERT 9nameSTATUStype VARCHARVARCHAR columnPos/ isAutoincrement/updatableByCursor/9nameAIRCRAFTtype VARCHARVARCHAR columnPos/ isAutoincrement/updatableByCursor/9nameMILEStypeINTEGERINTEGER  columnPos/ isAutoincrement/updatableByCursor/9name FLYING_TIMEtypeDOUBLEDOUBLE4 columnPos/isAutoincrement/updatableByCursor/9nameMEALtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/9name ARRIVE_TIMEtype#!TIME!TIME columnPos/isAutoincrement/updatableByCursor/9name DEST_AIRPORTtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/9name DEPART_TIMEtype#!TIME!TIME columnPos/isAutoincrement/updatableByCursor/9name ORIG_AIRPORTtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/9nameSEGMENT_NUMBERtypeINTEGERINTEGER  columnPos/isAutoincrement/updatableByCursor/9name FLIGHT_IDtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/ 9nameSTATUStype VARCHARVARCHAR columnPos/ isAutoincrement/updatableByCursor/9nameAIRCRAFTtype VARCHARVARCHAR columnPos/ isAutoincrement/updatableByCursor/9nameMILEStypeINTEGERINTEGER  columnPos/ isAutoincrement/updatableByCursor/9name FLYING_TIMEtypeDOUBLEDOUBLE4 columnPos/isAutoincrement/updatableByCursor/9nameMEALtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/9name ARRIVE_TIMEtype#!TIME!TIME columnPos/isAutoincrement/updatableByCursor/9name DEST_AIRPORTtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/9name DEPART_TIMEtype#!TIME!TIME columnPos/isAutoincrement/updatableByCursor/9name ORIG_AIRPORTtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/9nameSEGMENT_NUMBERtypeINTEGERINTEGER  columnPos/isAutoincrement/updatableByCursor/9name FLIGHT_IDtypeCHARCHAR columnPos/isAutoincrement/updatableByCursor/()V  CodepostConstructorexecute'()Lorg/apache/derby/iapi/sql/ResultSet;  throwIfClosed(Ljava/lang/String;)V  startExecution   fillResultSetget"<MfuNaResultSetFactory6()Lorg/apache/derby/iapi/sql/execute/ResultSetFactory;  e0()Ljava/lang/Object;+Lorg/apache/derby/iapi/sql/execute/ExecRow;  getExecutionFactory6()Lorg/apache/derby/iapi/sql/execute/ExecutionFactory;  !2org/apache/derby/iapi/sql/execute/ExecutionFactory# getValueRow.(I)Lorg/apache/derby/iapi/sql/execute/ExecRow; %& $'org/apache/derby/iapi/sql/Row) getColumn4(I)Lorg/apache/derby/iapi/types/DataValueDescriptor; +, *-getDataValueFactory0()Lorg/apache/derby/iapi/types/DataValueFactory; /0 1+org/apache/derby/iapi/types/StringDataValue3,org/apache/derby/iapi/types/DataValueFactory5 getNullChar\(Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue; 78 69/org/apache/derby/iapi/types/DataValueDescriptor; setColumn5(ILorg/apache/derby/iapi/types/DataValueDescriptor;)V => *?+org/apache/derby/iapi/types/NumberDataValueAgetNullInteger\(Lorg/apache/derby/iapi/types/NumberDataValue;)Lorg/apache/derby/iapi/types/NumberDataValue; CD 6E-org/apache/derby/iapi/types/DateTimeDataValueG getNullTime`(Lorg/apache/derby/iapi/types/DateTimeDataValue;)Lorg/apache/derby/iapi/types/DateTimeDataValue; IJ 6K getNullDouble MD 6NgetNullVarchar P8 6QINSERTED FROM TRIG2SgetVarcharDataValuen(Ljava/lang/String;Lorg/apache/derby/iapi/types/StringDataValue;)Lorg/apache/derby/iapi/types/StringDataValue; UV 6W-org/apache/derby/iapi/error/StandardExceptionYjava/lang/Exception[ Exceptions7org/apache/derby/iapi/services/loader/GeneratedByteCode_ getMethodK(Ljava/lang/String;)Lorg/apache/derby/iapi/services/loader/GeneratedMethod; ab `c?2org/apache/derby/iapi/sql/execute/ResultSetFactoryggetRowResultSet(Lorg/apache/derby/iapi/sql/Activation;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;ZIDD)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet; ij hkgetNormalizeResultSetk(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;IIDDZ)Lorg/apache/derby/iapi/sql/execute/NoPutResultSet; mn hogetInsertResultSet(Lorg/apache/derby/iapi/sql/execute/NoPutResultSet;Lorg/apache/derby/iapi/services/loader/GeneratedMethod;)Lorg/apache/derby/iapi/sql/ResultSet; qr hs resultSet%Lorg/apache/derby/iapi/sql/ResultSet; uv w  ygetExecutionCountI {| }()IsetExecutionCount(I)VgetRowCountCheckVectorLjava/util/Vector; ()Ljava/util/Vector;setRowCountCheckVector(Ljava/util/Vector;)VgetStalePlanCheckInterval | setStalePlanCheckInterval)org/apache/derby/iapi/sql/execute/ExecRowrow,[Lorg/apache/derby/iapi/sql/execute/ExecRow; 1 {| |  * ]Z B6*" (*_* T*2_X<@*ZW ]Z /#* **x*z*_Zx*x ]Z ? 3*****^del ep t]Z\ w**.*2_4:<@**.*2_BF<@**.*2_4:<@**.*2_HL<@**.*2_4:<@**.*2_HL<@**.*2_4:<@**.*2_BO<@* * .*2_BF<@* * .*2_4R<@*{ ~ ~  +  <gw-ug