DB2 Table Description

db2_table_description.sql

SELECT * FROM OPENQUERY(DB2,'
		SELECT 
     COLUMN_NAME AS Name, 
     COLUMN_TEXT AS Description, 
     DATA_TYPE AS TYPE, 
     LENGTH AS Length, 
     NUMERIC_SCALE AS Scale, 
     NUMERIC_PRECISION AS PRECISION, 
     IS_NULLABLE AS Nullable 
FROM 
     QSYS2.SYSCOLUMNS 
WHERE 
     TABLE_SCHEMA = ''SOMESCHEMA'' AND 
     TABLE_NAME = ''SOMETABLE''')