Comment 5 for bug 1420523

Revision history for this message
xiu-zhu.zhang (xiu-zhu-zhang) wrote :

The SQLColumns data based on field 'FS_DATA_TYPE' belonging to ..."_MD_".columns table.

Here is the Statement which is be used to query the SQLColumns info:
SELECT ...
FROM TRAFODION."_MD_".objects ob
                ,TRAFODION."_MD_".columns co
                ,TRAFODION."_MD_".columns co1
                ,(
                                VALUES ('DATE',91,10,'{d ''','''}',NULL,1,0,2,NULL,0,NULL,'DATE',NULL,NULL,'DATE',192,NULL,10,6,9,1,NULL,1,3,3,0),...
                ) dt(……"LOCAL_TYPE_NAME", "MINIMUM_SCALE", "MAXIMUM_SCALE", "SQL_TYPE_NAME",
                                "FS_DATA_TYPE", "NUM_PREC_RADIX……)
WHERE ob.OBJECT_UID = co.OBJECT_UID
                AND dt.FS_DATA_TYPE = co.FS_DATA_TYPE
                AND co.OBJECT_UID = co1.OBJECT_UID
                AND co1.COLUMN_NUMBER = 0...;

The 'FS_DATA_TYPE' has missed currently in ..."_MD_".Columns for several data type so can't get correct result.