hi all,

when i look at snapshot for all i see very large sql statemensts like this part of a statement ... what will tell us statements like this one?

is this type conversion?




Statement text = WITH TYPEINTS ( TYPEINT, COLTYPE ) AS ( VALUES ( SMALLINT(1 ), CHAR( 'INTEGER', 8) ), ( SMALLINT(2 ), CHAR( 'SMALLINT', 8) ), ( SMALLINT(3 ), CHAR( 'BIGINT', 8) ), ( SMALLINT(4 ), CHAR( 'REAL', 8) ), ( SMALLINT(5 ), CHAR( 'DOUBLE', 8) ), ( SMALLINT(6 ), CHAR( 'CHAR', 8) ), ( SMALLINT(7 ), CHAR( 'VARCHAR', 8) ), ( SMALLINT(8 ), CHAR( 'LONGVAR', 8) ), ( SMALLINT(9 ), CHAR( 'DECIMAL', 8) ), ( SMALLINT(10), CHAR( 'GRAPHIC', 8) ), ( SMALLINT(11), CHAR( 'VARGRAPH', 8) ), ( SMALLINT(12), CHAR( 'LONGVARG', 8) ), ( SMALLINT(13), CHAR( 'BLOB', 8) ), ( SMALLINT(14), CHAR( 'CLOB', 8) ), ( SMALLINT(15), CHAR( 'DBCLOB', 8) ), ( SMALLINT(16), CHAR( 'DATE', 8) ), ( SMALLINT(17), CHAR( 'TIME', 8) ), ( SMALLINT(18), CHAR( 'TIMESTMP', 8) ), ( SMALLINT(19), CHAR( 'DATALINK', 8) ), ( SMALLINT(20), CHAR( 'STRUCT', 8) ), ( SMALLINT(21), CHAR( 'DISTINCT', 8) ), ( SMALLINT(22), CHAR( 'REF', 8) ) ), SYSIBM.SQLCOLS ( TABLE_CAT, TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, COLUMN_SIZE, BUFFER_LENGTH, DECIMAL_DIGITS, NUM_PREC_RADIX, NULLABLE, REMARKS, COLUMN_DEF, SQL_DATA_TYPE, SQL_DATETIME_SUB, CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE, JDBC_DATA_TYPE, SCOPE_CATLOG, SCOPE_SCHEMA, SCOPE_TABLE, SOURCE_DATA_TYPE, DBNAME, PSEUDO_COLUMN ) AS ( SELECT CAST( NULL AS VARCHAR(128) ), RTRIM(T.CREATOR), T.NAME, C.NAME, SMALLINT( CASE WHEN I.TYPEINT=1 THEN 4 WHEN I.TYPEINT=2 THEN 5 WHEN I.TYPEINT=3 THEN -5 WHEN I.TYPEINT=4 THEN 7 WHEN I.TYPEINT=5 THEN 8 WHEN I.TYPEINT=6 AND C.CODEPAGE <> 0 then 1 WHEN I.TYPEINT=6 AND C.CODEPAGE = 0 then -2 WHEN I.TYPEINT=7 AND C.CODEPAGE <> 0 THEN 12 WHEN I.TYPEINT=7 AND C.CODEPAGE = 0 THEN -3 WHEN I.TYPEINT=8 AND C.CODEPAGE <> 0 THEN -1 WHEN I.TYPEINT=8 AND C.CODEPAGE = 0 THEN


......................... and so on ...



thanks
bab