DB2查看表的结构
SELECT
TBCREATOR AS schema,
TBNAME AS 表名,
COLNO AS 序号,
NAME AS 字段名,
REMARKS AS 字段中文名,
COLTYPE AS 字段类型,
LENGTH AS 字段长度,
SCALE AS 精度,
NULLS AS 是否为空
FROM "SYSIBM".syscolumns
WHERE TBNAME = 'HGCDM01' AND TBCREATOR = 'WHH1M1'
?
SELECT
TBCREATOR AS TBDATA,
TBNAME as TBNAME,
TRIM(NAME) as TBCOLUMN,
UPPER(TRIM(NAME)) as TBCONDITION,
CASE
WHEN POSSTR(TRIM(COLTYPE),'CHAR')>0 THEN LOWER(TRIM(COLTYPE))||'('||LENGTH||')'
WHEN LOCATE(TRIM(COLTYPE),'DECIMAL')>0 THEN LOWER(TRIM(COLTYPE))||'('||LENGTH||','||SCALE||')'
ELSE LOWER(TRIM(COLTYPE))
END AS TBTYPE,
CASE WHEN LENGTH(REMARKS)>0 THEN REMARKS ELSE '' END AS TBMARK,
CASE WHEN LENGTH("DEFAULT")>0 THEN "DEFAULT" ELSE '' END AS TBDEFAULT
FROM "SYSIBM".syscolumns
WHERE TBNAME = 'TQMTQA2' AND TBCREATOR = 'WHH1M1'