How to see the schema of a db2 table (file)

db2fileschema

As in subject… is there a way of looking at an empty table schema without inserting any rows and issuing a SELECT?

Best Solution

SELECT *                
FROM SYSIBM.SYSCOLUMNS  
WHERE                   
TBNAME    = 'tablename';