public static final java.lang.String |
fk_text_casemode_0 |
"select name_part (PK_TABLE, 0) as PKTABLE_CAT varchar (128), name_part (PK_TABLE, 1) as PKTABLE_SCHEM varchar (128), name_part (PK_TABLE, 2) as PKTABLE_NAME varchar (128), PKCOLUMN_NAME, name_part (FK_TABLE, 0) as FKTABLE_CAT varchar (128), name_part (FK_TABLE, 1) as FKTABLE_SCHEM varchar (128), name_part (FK_TABLE, 2) as FKTABLE_NAME varchar (128), FKCOLUMN_NAME, (KEY_SEQ + 1) as KEY_SEQ SMALLINT, (case UPDATE_RULE when 0 then 3 when 1 then 0 when 3 then 4 end) as UPDATE_RULE smallint, (case DELETE_RULE when 0 then 3 when 1 then 0 when 3 then 4 end) as DELETE_RULE smallint, FK_NAME, PK_NAME, NULL as DEFERRABILITY from DB.DBA.SYS_FOREIGN_KEYS SYS_FOREIGN_KEYS where name_part (PK_TABLE, 0) like ? and name_part (PK_TABLE, 1) like ? and name_part (PK_TABLE, 2) like ? and name_part (FK_TABLE, 0) like ? and name_part (FK_TABLE, 1) like ? and name_part (FK_TABLE, 2) like ? order by 1, 2, 3, 5, 6, 7, 9" |
public static final java.lang.String |
fk_text_casemode_2 |
"select name_part (PK_TABLE, 0) as PKTABLE_CAT varchar (128), name_part (PK_TABLE, 1) as PKTABLE_SCHEM varchar (128), name_part (PK_TABLE, 2) as PKTABLE_NAME varchar (128), PKCOLUMN_NAME, name_part (FK_TABLE, 0) as FKTABLE_CAT varchar (128), name_part (FK_TABLE, 1) as FKTABLE_SCHEM varchar (128), name_part (FK_TABLE, 2) as FKTABLE_NAME varchar (128), FKCOLUMN_NAME, (KEY_SEQ + 1) as KEY_SEQ SMALLINT, (case UPDATE_RULE when 0 then 3 when 1 then 0 when 3 then 4 end) as UPDATE_RULE smallint, (case DELETE_RULE when 0 then 3 when 1 then 0 when 3 then 4 end) as DELETE_RULE smallint, FK_NAME, PK_NAME, NULL as DEFERRABILITY from DB.DBA.SYS_FOREIGN_KEYS SYS_FOREIGN_KEYS where upper (name_part (PK_TABLE, 0)) like upper (?) and upper (name_part (PK_TABLE, 1)) like upper (?) and upper (name_part (PK_TABLE, 2)) like upper (?) and upper (name_part (FK_TABLE, 0)) like upper (?) and upper (name_part (FK_TABLE, 1)) like upper (?) and upper (name_part (FK_TABLE, 2)) like upper (?) order by 1, 2, 3, 5, 6, 7, 9" |
public static final java.lang.String |
fk_textw_casemode_0 |
"select charset_recode (name_part (PK_TABLE, 0), \'UTF-8\', \'_WIDE_\') as PKTABLE_CAT nvarchar (128), charset_recode (name_part (PK_TABLE, 1), \'UTF-8\', \'_WIDE_\') as PKTABLE_SCHEM nvarchar (128), charset_recode (name_part (PK_TABLE, 2), \'UTF-8\', \'_WIDE_\') as PKTABLE_NAME nvarchar (128), charset_recode (PKCOLUMN_NAME, \'UTF-8\', \'_WIDE_\') as PKCOLUMN_NAME nvarchar (128), charset_recode (name_part (FK_TABLE, 0), \'UTF-8\', \'_WIDE_\') as FKTABLE_CAT nvarchar (128), charset_recode (name_part (FK_TABLE, 1), \'UTF-8\', \'_WIDE_\') as FKTABLE_SCHEM nvarchar (128), charset_recode (name_part (FK_TABLE, 2), \'UTF-8\', \'_WIDE_\') as FKTABLE_NAME nvarchar (128), charset_recode (FKCOLUMN_NAME, \'UTF-8\', \'_WIDE_\') as FKCOLUMN_NAME nvarchar (128), (KEY_SEQ + 1) as KEY_SEQ SMALLINT, (case UPDATE_RULE when 0 then 3 when 1 then 0 when 3 then 4 end) as UPDATE_RULE smallint, (case DELETE_RULE when 0 then 3 when 1 then 0 when 3 then 4 end) as DELETE_RULE smallint, charset_recode (FK_NAME, \'UTF-8\', \'_WIDE_\') as FK_NAME nvarchar (128), charset_recode (PK_NAME, \'UTF-8\', \'_WIDE_\') as PK_NAME nvarchar (128), NULL as DEFERRABILITY from DB.DBA.SYS_FOREIGN_KEYS SYS_FOREIGN_KEYS where name_part (PK_TABLE, 0) like ? and name_part (PK_TABLE, 1) like ? and name_part (PK_TABLE, 2) like ? and name_part (FK_TABLE, 0) like ? and name_part (FK_TABLE, 1) like ? and name_part (FK_TABLE, 2) like ? order by 1, 2, 3, 5, 6, 7, 9" |
public static final java.lang.String |
fk_textw_casemode_2 |
"select charset_recode (name_part (PK_TABLE, 0), \'UTF-8\', \'_WIDE_\') as PKTABLE_CAT nvarchar (128), charset_recode (name_part (PK_TABLE, 1), \'UTF-8\', \'_WIDE_\') as PKTABLE_SCHEM nvarchar (128), charset_recode (name_part (PK_TABLE, 2), \'UTF-8\', \'_WIDE_\') as PKTABLE_NAME nvarchar (128), charset_recode (PKCOLUMN_NAME, \'UTF-8\', \'_WIDE_\') as PKCOLUMN_NAME nvarchar (128), charset_recode (name_part (FK_TABLE, 0), \'UTF-8\', \'_WIDE_\') as FKTABLE_CAT nvarchar (128), charset_recode (name_part (FK_TABLE, 1), \'UTF-8\', \'_WIDE_\') as FKTABLE_SCHEM nvarchar (128), charset_recode (name_part (FK_TABLE, 2), \'UTF-8\', \'_WIDE_\') as FKTABLE_NAME nvarchar (128), charset_recode (FKCOLUMN_NAME, \'UTF-8\', \'_WIDE_\') as FKCOLUMN_NAME nvarchar (128), (KEY_SEQ + 1) as KEY_SEQ SMALLINT, (case UPDATE_RULE when 0 then 3 when 1 then 0 when 3 then 4 end) as UPDATE_RULE smallint, (case DELETE_RULE when 0 then 3 when 1 then 0 when 3 then 4 end) as DELETE_RULE smallint, charset_recode (FK_NAME, \'UTF-8\', \'_WIDE_\') as FK_NAME nvarchar (128), charset_recode (PK_NAME, \'UTF-8\', \'_WIDE_\') as PK_NAME nvarchar (128), NULL as DEFERRABILITY from DB.DBA.SYS_FOREIGN_KEYS SYS_FOREIGN_KEYS where charset_recode (upper (charset_recode (name_part (PK_TABLE, 0), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') like charset_recode (upper (charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') and charset_recode (upper (charset_recode (name_part (PK_TABLE, 1), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') like charset_recode (upper (charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') and charset_recode (upper (charset_recode (name_part (PK_TABLE, 2), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') like charset_recode (upper (charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') and charset_recode (upper (charset_recode (name_part (FK_TABLE, 0), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') like charset_recode (upper (charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') and charset_recode (upper (charset_recode (name_part (FK_TABLE, 1), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') like charset_recode (upper (charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') and charset_recode (upper (charset_recode (name_part (FK_TABLE, 2), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') like charset_recode (upper (charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') order by 1, 2, 3, 5, 6, 7, 9" |
public static final java.lang.String |
getBestRowIdText_case0 |
"select 0 AS \\SCOPE SMALLINT, SYS_COLS.\\COLUMN AS COLUMN_NAME VARCHAR(128), dv_to_sql_type(SYS_COLS.COL_DTP) AS DATA_TYPE SMALLINT, dv_type_title(SYS_COLS.COL_DTP) AS TYPE_NAME VARCHAR(128), case SYS_COLS.COL_PREC when 0 then 4080 else SYS_COLS.COL_PREC end AS COLUMN_SIZE INTEGER,\n SYS_COLS.COL_PREC AS BUFFER_LENGTH INTEGER, SYS_COLS.COL_SCALE AS DECIMAL_DIGITS SMALLINT, 1 AS PSEUDO_COLUMN SMALLINT from DB.DBA.SYS_KEYS SYS_KEYS, DB.DBA.SYS_KEY_PARTS SYS_KEY_PARTS, DB.DBA.SYS_COLS SYS_COLS where name_part(SYS_KEYS.KEY_TABLE,0) like ? and __any_grants (KEY_TABLE) and name_part(SYS_KEYS.KEY_TABLE,1) like ? and name_part(SYS_KEYS.KEY_TABLE,2) like ? and SYS_KEYS.KEY_IS_MAIN = 1 and SYS_KEYS.KEY_MIGRATE_TO is NULL and SYS_KEY_PARTS.KP_KEY_ID = SYS_KEYS.KEY_ID and SYS_KEY_PARTS.KP_NTH < SYS_KEYS.KEY_DECL_PARTS and SYS_COLS.COL_ID = SYS_KEY_PARTS.KP_COL order by SYS_KEYS.KEY_TABLE, SYS_KEY_PARTS.KP_NTH" |
public static final java.lang.String |
getBestRowIdText_case2 |
"select 0 AS \\SCOPE SMALLINT, SYS_COLS.\\COLUMN AS COLUMN_NAME VARCHAR(128), dv_to_sql_type(SYS_COLS.COL_DTP) AS DATA_TYPE SMALLINT, dv_type_title(SYS_COLS.COL_DTP) AS TYPE_NAME VARCHAR(128), case SYS_COLS.COL_PREC when 0 then 4080 else SYS_COLS.COL_PREC end AS COLUMN_SIZE INTEGER,\n SYS_COLS.COL_PREC AS BUFFER_LENGTH INTEGER, SYS_COLS.COL_SCALE AS DECIMAL_DIGITS SMALLINT, 1 AS PSEUDO_COLUMN SMALLINT from DB.DBA.SYS_KEYS SYS_KEYS, DB.DBA.SYS_KEY_PARTS SYS_KEY_PARTS, DB.DBA.SYS_COLS SYS_COLS where upper(name_part(SYS_KEYS.KEY_TABLE,0)) like upper(?) and __any_grants (KEY_TABLE) and upper(name_part(SYS_KEYS.KEY_TABLE,1)) like upper(?) and upper(name_part(SYS_KEYS.KEY_TABLE,2)) like upper(?) and SYS_KEYS.KEY_IS_MAIN = 1 and SYS_KEYS.KEY_MIGRATE_TO is NULL and SYS_KEY_PARTS.KP_KEY_ID = SYS_KEYS.KEY_ID and SYS_KEY_PARTS.KP_NTH < SYS_KEYS.KEY_DECL_PARTS and SYS_COLS.COL_ID = SYS_KEY_PARTS.KP_COL order by SYS_KEYS.KEY_TABLE, SYS_KEY_PARTS.KP_NTH" |
public static final java.lang.String |
getBestVersionColsText_case0 |
"select null as \\SCOPE smallint, \\COLUMN as COLUMN_NAME varchar(128), dv_to_sql_type(COL_DTP) as DATA_TYPE smallint, dv_type_title(COL_DTP) as TYPE_NAME varchar(128), case COL_PREC when 0 then 4080 else COL_PREC end AS COLUMN_SIZE INTEGER,\n COL_PREC as BUFFER_LENGTH integer, COL_SCALE as DECIMAL_DIGITS smallint, 1 as PSEUDO_COLUMN smallint from DB.DBA.SYS_COLS where \\COL_DTP = 128 and name_part(\\TABLE,0) like ? and name_part(\\TABLE,1) like ? and name_part(\\TABLE,2) like ? order by \\TABLE, \\COL_ID" |
public static final java.lang.String |
getBestVersionColsText_case2 |
"select null as \\SCOPE smallint, \\COLUMN as COLUMN_NAME varchar(128), dv_to_sql_type(COL_DTP) as DATA_TYPE smallint, dv_type_title(COL_DTP) as TYPE_NAME varchar(128), case COL_PREC when 0 then 4080 else COL_PREC end AS COLUMN_SIZE INTEGER,\n COL_PREC as BUFFER_LENGTH integer, COL_SCALE as DECIMAL_DIGITS smallint, 1 as PSEUDO_COLUMN smallint from DB.DBA.SYS_COLS where \\COL_DTP = 128 and upper(name_part(\\TABLE,0)) like upper(?) and upper(name_part(\\TABLE,1)) like upper(?) and upper(name_part(\\TABLE,2)) like upper(?) order by \\TABLE, \\COL_ID" |
public static final java.lang.String |
getWideBestRowIdText_case0 |
"select 0 AS \\SCOPE SMALLINT, charset_recode (SYS_COLS.\\COLUMN, \'UTF-8\', \'_WIDE_\') AS COLUMN_NAME NVARCHAR(128), dv_to_sql_type(SYS_COLS.COL_DTP) AS DATA_TYPE SMALLINT, dv_type_title(SYS_COLS.COL_DTP) AS TYPE_NAME VARCHAR(128), case SYS_COLS.COL_PREC when 0 then 4080 else SYS_COLS.COL_PREC end AS COLUMN_SIZE INTEGER,\n SYS_COLS.COL_PREC AS BUFFER_LENGTH INTEGER, SYS_COLS.COL_SCALE AS DECIMAL_DIGITS SMALLINT, 1 AS PSEUDO_COLUMN SMALLINT from DB.DBA.SYS_KEYS SYS_KEYS, DB.DBA.SYS_KEY_PARTS SYS_KEY_PARTS, DB.DBA.SYS_COLS SYS_COLS where name_part(SYS_KEYS.KEY_TABLE,0) like ? and __any_grants (KEY_TABLE) and name_part(SYS_KEYS.KEY_TABLE,1) like ? and name_part(SYS_KEYS.KEY_TABLE,2) like ? and SYS_KEYS.KEY_IS_MAIN = 1 and SYS_KEYS.KEY_MIGRATE_TO is NULL and SYS_KEY_PARTS.KP_KEY_ID = SYS_KEYS.KEY_ID and SYS_KEY_PARTS.KP_NTH < SYS_KEYS.KEY_DECL_PARTS and SYS_COLS.COL_ID = SYS_KEY_PARTS.KP_COL order by SYS_KEYS.KEY_TABLE, SYS_KEY_PARTS.KP_NTH" |
public static final java.lang.String |
getWideBestRowIdText_case2 |
"select 0 AS \\SCOPE SMALLINT, charset_recode (SYS_COLS.\\COLUMN, \'UTF-8\', \'_WIDE_\') AS COLUMN_NAME NVARCHAR(128), dv_to_sql_type(SYS_COLS.COL_DTP) AS DATA_TYPE SMALLINT, dv_type_title(SYS_COLS.COL_DTP) AS TYPE_NAME VARCHAR(128), case SYS_COLS.COL_PREC when 0 then 4080 else SYS_COLS.COL_PREC end AS COLUMN_SIZE INTEGER,\n SYS_COLS.COL_PREC AS BUFFER_LENGTH INTEGER, SYS_COLS.COL_SCALE AS DECIMAL_DIGITS SMALLINT, 1 AS PSEUDO_COLUMN SMALLINT from DB.DBA.SYS_KEYS SYS_KEYS, DB.DBA.SYS_KEY_PARTS SYS_KEY_PARTS, DB.DBA.SYS_COLS SYS_COLS where charset_recode (upper(charset_recode (name_part(SYS_KEYS.KEY_TABLE,0), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8 \') like charset_recode (upper(charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') and __any_grants (KEY_TABLE) and charset_recode (upper(charset_recode (name_part(SYS_KEYS.KEY_TABLE,1), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\' ) like charset_recode (upper(charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') and charset_recode (upper(charset_recode (name_part(SYS_KEYS.KEY_TABLE,2), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\' ) like charset_recode (upper(charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') and SYS_KEYS.KEY_IS_MAIN = 1 and SYS_KEYS.KEY_MIGRATE_TO is NULL and SYS_KEY_PARTS.KP_KEY_ID = SYS_KEYS.KEY_ID and SYS_KEY_PARTS.KP_NTH < SYS_KEYS.KEY_DECL_PARTS and SYS_COLS.COL_ID = SYS_KEY_PARTS.KP_COL order by SYS_KEYS.KEY_TABLE, SYS_KEY_PARTS.KP_NTH" |
public static final java.lang.String |
getWideBestVersionColsText_case0 |
"select null as \\SCOPE smallint, charset_recode (\\COLUMN, \'UTF-8\', \'_WIDE_\') as COLUMN_NAME nvarchar(128), dv_to_sql_type(COL_DTP) as DATA_TYPE smallint, dv_type_title(COL_DTP) as TYPE_NAME varchar(128), case COL_PREC when 0 then 4080 else COL_PREC end AS COLUMN_SIZE INTEGER,\n COL_PREC as BUFFER_LENGTH integer, COL_SCALE as DECIMAL_DIGITS smallint, 1 as PSEUDO_COLUMN smallint from DB.DBA.SYS_COLS where \\COL_DTP = 128 and name_part(\\TABLE,0) like ? and name_part(\\TABLE,1) like ? and name_part(\\TABLE,2) like ? order by \\TABLE, \\COL_ID" |
public static final java.lang.String |
getWideBestVersionColsText_case2 |
"select NULL as \\SCOPE smallint, charset_recode (\\COLUMN, \'UTF-8\', \'_WIDE_\') as COLUMN_NAME nvarchar(128), dv_to_sql_type(COL_DTP) as DATA_TYPE smallint, dv_type_title(COL_DTP) as TYPE_NAME varchar(128), case COL_PREC when 0 then 4080 else COL_PREC end AS COLUMN_SIZE INTEGER,\n COL_PREC as BUFFER_LENGTH integer, COL_SCALE as DECIMAL_DIGITS smallint, 1 as PSEUDO_COLUMN smallint from DB.DBA.SYS_COLS where \\COL_DTP = 128 and charset_recode (upper(charset_recode (name_part(\\TABLE,0), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') lik e charset_recode (upper(charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') and charset_recode (upper(charset_recode (name_part(\\TABLE,1), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') lik e charset_recode (upper(charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') and charset_recode (upper(charset_recode (name_part(\\TABLE,2), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') lik e charset_recode (upper(charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') order by \\TABLE, \\COL_ID" |
public static final java.lang.String |
sql_statistics_text_casemode_0 |
"select name_part(SYS_KEYS.KEY_TABLE,0) AS \\TABLE_CAT VARCHAR(128), name_part(SYS_KEYS.KEY_TABLE,1) AS \\TABLE_SCHEM VARCHAR(128), name_part(SYS_KEYS.KEY_TABLE,2) AS \\TABLE_NAME VARCHAR(128), iszero(SYS_KEYS.KEY_IS_UNIQUE) AS \\NON_UNIQUE SMALLINT, name_part (SYS_KEYS.KEY_TABLE, 0) AS \\INDEX_QUALIFIER VARCHAR(128), name_part (SYS_KEYS.KEY_NAME, 2) AS \\INDEX_NAME VARCHAR(128), ((SYS_KEYS.KEY_IS_OBJECT_ID*8) + (3-(2*iszero(SYS_KEYS.KEY_CLUSTER_ON_ID)))) AS \\TYPE SMALLINT, (SYS_KEY_PARTS.KP_NTH+1) AS \\ORDINAL_POSITION SMALLINT, SYS_COLS.\\COLUMN AS \\COLUMN_NAME VARCHAR(128), NULL AS \\ASC_OR_DESC CHAR(1), NULL AS \\CARDINALITY INTEGER, NULL AS \\PAGES INTEGER, NULL AS \\FILTER_CONDITION VARCHAR(128) from DB.DBA.SYS_KEYS SYS_KEYS, DB.DBA.SYS_KEY_PARTS SYS_KEY_PARTS, DB.DBA.SYS_COLS SYS_COLS where name_part(SYS_KEYS.KEY_TABLE,0) like ? and __any_grants (SYS_KEYS.KEY_TABLE) and name_part(SYS_KEYS.KEY_TABLE,1) like ? and name_part(SYS_KEYS.KEY_TABLE,2) like ? and SYS_KEYS.KEY_IS_UNIQUE >= ? and SYS_KEYS.KEY_MIGRATE_TO is NULL and SYS_KEY_PARTS.KP_KEY_ID = SYS_KEYS.KEY_ID and SYS_KEY_PARTS.KP_NTH < SYS_KEYS.KEY_DECL_PARTS and SYS_COLS.COL_ID = SYS_KEY_PARTS.KP_COL and SYS_COLS.\\COLUMN <> \'_IDN\' order by SYS_KEYS.KEY_TABLE, SYS_KEYS.KEY_NAME, SYS_KEY_PARTS.KP_NTH" |
public static final java.lang.String |
sql_statistics_text_casemode_2 |
"select name_part(SYS_KEYS.KEY_TABLE,0) AS \\TABLE_CAT VARCHAR(128), name_part(SYS_KEYS.KEY_TABLE,1) AS \\TABLE_SCHEM VARCHAR(128), name_part(SYS_KEYS.KEY_TABLE,2) AS \\TABLE_NAME VARCHAR(128), iszero(SYS_KEYS.KEY_IS_UNIQUE) AS \\NON_UNIQUE SMALLINT, name_part (SYS_KEYS.KEY_TABLE, 0) AS \\INDEX_QUALIFIER VARCHAR(128), name_part (SYS_KEYS.KEY_NAME, 2) AS \\INDEX_NAME VARCHAR(128), ((SYS_KEYS.KEY_IS_OBJECT_ID*8) + (3-(2*iszero(SYS_KEYS.KEY_CLUSTER_ON_ID)))) AS \\TYPE SMALLINT, (SYS_KEY_PARTS.KP_NTH+1) AS \\ORDINAL_POSITION SMALLINT, SYS_COLS.\\COLUMN AS \\COLUMN_NAME VARCHAR(128), NULL AS \\ASC_OR_DESC CHAR(1), NULL AS \\CARDINALITY INTEGER, NULL AS \\PAGES INTEGER, NULL AS \\FILTER_CONDITION VARCHAR(128) from DB.DBA.SYS_KEYS SYS_KEYS, DB.DBA.SYS_KEY_PARTS SYS_KEY_PARTS, DB.DBA.SYS_COLS SYS_COLS where upper(name_part(SYS_KEYS.KEY_TABLE,0)) like upper(?) and __any_grants (SYS_KEYS.KEY_TABLE) and upper(name_part(SYS_KEYS.KEY_TABLE,1)) like upper(?) and upper(name_part(SYS_KEYS.KEY_TABLE,2)) like upper(?) and SYS_KEYS.KEY_IS_UNIQUE >= ? and SYS_KEYS.KEY_MIGRATE_TO is NULL and SYS_KEY_PARTS.KP_KEY_ID = SYS_KEYS.KEY_ID and SYS_KEY_PARTS.KP_NTH < SYS_KEYS.KEY_DECL_PARTS and SYS_COLS.COL_ID = SYS_KEY_PARTS.KP_COL and SYS_COLS.\\COLUMN <> \'_IDN\' order by SYS_KEYS.KEY_TABLE, SYS_KEYS.KEY_NAME, SYS_KEY_PARTS.KP_NTH" |
public static final java.lang.String |
sql_statistics_textw_casemode_0 |
"select charset_recode (name_part(SYS_KEYS.KEY_TABLE,0), \'UTF-8\', \'_WIDE_\') AS \\TABLE_CAT NVARCHAR(128), charset_recode (name_part(SYS_KEYS.KEY_TABLE,1), \'UTF-8\', \'_WIDE_\') AS \\TABLE_SCHEM NVARCHAR(128), charset_recode (name_part(SYS_KEYS.KEY_TABLE,2), \'UTF-8\', \'_WIDE_\') AS \\TABLE_NAME NVARCHAR(128), iszero(SYS_KEYS.KEY_IS_UNIQUE) AS \\NON_UNIQUE SMALLINT, charset_recode (name_part (SYS_KEYS.KEY_TABLE, 0), \'UTF-8\', \'_WIDE_\') AS \\INDEX_QUALIFIER NVARCHAR(128), charset_recode (name_part (SYS_KEYS.KEY_NAME, 2), \'UTF-8\', \'_WIDE_\') AS \\INDEX_NAME NVARCHAR(128), ((SYS_KEYS.KEY_IS_OBJECT_ID*8) + (3-(2*iszero(SYS_KEYS.KEY_CLUSTER_ON_ID)))) AS \\TYPE SMALLINT, (SYS_KEY_PARTS.KP_NTH+1) AS \\ORDINAL_POSITION SMALLINT, charset_recode (SYS_COLS.\\COLUMN, \'UTF-8\', \'_WIDE_\') AS \\COLUMN_NAME NVARCHAR(128), NULL AS \\ASC_OR_DESC CHAR(1), NULL AS \\CARDINALITY INTEGER, NULL AS \\PAGES INTEGER, NULL AS \\FILTER_CONDITION VARCHAR(128) from DB.DBA.SYS_KEYS SYS_KEYS, DB.DBA.SYS_KEY_PARTS SYS_KEY_PARTS, DB.DBA.SYS_COLS SYS_COLS where name_part(SYS_KEYS.KEY_TABLE,0) like ? and __any_grants (SYS_KEYS.KEY_TABLE) and name_part(SYS_KEYS.KEY_TABLE,1) like ? and name_part(SYS_KEYS.KEY_TABLE,2) like ? and SYS_KEYS.KEY_IS_UNIQUE >= ? and SYS_KEYS.KEY_MIGRATE_TO is NULL and SYS_KEY_PARTS.KP_KEY_ID = SYS_KEYS.KEY_ID and SYS_KEY_PARTS.KP_NTH < SYS_KEYS.KEY_DECL_PARTS and SYS_COLS.COL_ID = SYS_KEY_PARTS.KP_COL and SYS_COLS.\\COLUMN <> \'_IDN\' order by SYS_KEYS.KEY_TABLE, SYS_KEYS.KEY_NAME, SYS_KEY_PARTS.KP_NTH" |
public static final java.lang.String |
sql_statistics_textw_casemode_2 |
"select charset_recode (name_part(SYS_KEYS.KEY_TABLE,0), \'UTF-8\', \'_WIDE_\') AS TABLE_CAT NVARCHAR(128), charset_recode (name_part(SYS_KEYS.KEY_TABLE,1), \'UTF-8\', \'_WIDE_\') AS \\TABLE_SCHEM NVARCHAR(128), charset_recode (name_part(SYS_KEYS.KEY_TABLE,2), \'UTF-8\', \'_WIDE_\') AS \\TABLE_NAME NVARCHAR(128), iszero(SYS_KEYS.KEY_IS_UNIQUE) AS \\NON_UNIQUE SMALLINT, charset_recode (name_part (SYS_KEYS.KEY_TABLE, 0), \'UTF-8\', \'_WIDE_\') AS \\INDEX_QUALIFIER NVARCHAR(128), charset_recode (name_part (SYS_KEYS.KEY_NAME, 2), \'UTF-8\', \'_WIDE_\') AS \\INDEX_NAME NVARCHAR(128), ((SYS_KEYS.KEY_IS_OBJECT_ID*8) + (3-(2*iszero(SYS_KEYS.KEY_CLUSTER_ON_ID)))) AS \\TYPE SMALLINT, (SYS_KEY_PARTS.KP_NTH+1) AS \\ORDINAL_POSITION SMALLINT, charset_recode (SYS_COLS.\\COLUMN, \'UTF-8\', \'_WIDE_\') AS \\COLUMN_NAME NVARCHAR(128), NULL AS \\ASC_OR_DESC CHAR(1), NULL AS \\CARDINALITY INTEGER, NULL AS \\PAGES INTEGER, NULL AS \\FILTER_CONDITION VARCHAR(128) from DB.DBA.SYS_KEYS SYS_KEYS, DB.DBA.SYS_KEY_PARTS SYS_KEY_PARTS, DB.DBA.SYS_COLS SYS_COLS where charset_recode (upper(charset_recode (name_part(SYS_KEYS.KEY_TABLE,0), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') like charset_recode (upper(charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') and __any_grants (SYS_KEYS.KEY_TABLE) and charset_recode (upper(charset_recode (name_part(SYS_KEYS.KEY_TABLE,1), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') like charset_recode (upper(charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') and charset_recode (upper(charset_recode (name_part(SYS_KEYS.KEY_TABLE,2), \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') like charset_recode (upper(charset_recode (?, \'UTF-8\', \'_WIDE_\')), \'_WIDE_\', \'UTF-8\') and SYS_KEYS.KEY_IS_UNIQUE >= ? and SYS_KEYS.KEY_MIGRATE_TO is NULL and SYS_KEY_PARTS.KP_KEY_ID = SYS_KEYS.KEY_ID and SYS_KEY_PARTS.KP_NTH < SYS_KEYS.KEY_DECL_PARTS and SYS_COLS.COL_ID = SYS_KEY_PARTS.KP_COL and SYS_COLS.\\COLUMN <> \'_IDN\' order by SYS_KEYS.KEY_TABLE, SYS_KEYS.KEY_NAME, SYS_KEY_PARTS.KP_NTH" |
public static final int |
VARCHAR_UNSPEC_SIZE |
4080 |