IBM DB2 See Properties of Table

$ db2 "SELECT COLNO, COLNAME, TYPENAME, \"LENGTH\", \"SCALE\", \"NULLS\", \"DEFAULT\", KEYSEQ, \"IDENTITY\" FROM SYSCAT.COLUMNS WHERE UPPER(TABNAME) = UPPER('TABLE_NAME') AND UPPER(TABSCHEMA) = UPPER('APPCORE') ORDER BY COLNO ASC;"