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.
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: "_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) ,... TYPE_NAME" , "MINIMUM_SCALE", "MAXIMUM_SCALE", "SQL_TYPE_NAME",
"FS_ DATA_TYPE" , "NUM_PREC_RADIX……)
SELECT ...
FROM TRAFODION.
,(
) dt(……"LOCAL_
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.