SELECT * 
FROM QSYS2.SYSCOLUMNS 
WHERE TABLE_NAME = 'HRJPOS7'

SELECT COLUMN_NAME, COLUMN_HEADING, COLUMN_TEXT, DATA_TYPE, LENGTH
FROM QSYS2.SYSCOLUMNS 
WHERE TABLE_NAME = 'PPPDEPT'
AND TABLE_SCHEMA = 'PP#FILE'