-- Table info
SELECT s.SYSTEM_TABLE_SCHEMA, s.SYSTEM_TABLE_NAME, s.TABLE_TYPE, s.TABLE_NAME, s.TABLE_TEXT FROM QSYS2.SYSTABLES s 
where s.TABLE_SCHEMA = 'MYSCHEMA' -- OR: CURRENT_SCHEMA
ORDER BY s.TABLE_NAME 


-- Table + Column info
select sc.TABLE_NAME, s.TABLE_TEXT, sc.COLUMN_NAME, sc.COLUMN_TEXT, sc.DATA_TYPE --, sc.LENGTH, sc.IS_NULLABLE
from QSYS2.SYSCOLUMNS sc
JOIN QSYS2.SYSTABLES s ON s.TABLE_NAME = sc.TABLE_NAME AND s.TABLE_SCHEMA = sc.TABLE_SCHEMA 
where sc.TABLE_SCHEMA = 'MYSCHEMA' -- OR: CURRENT_SCHEMA
ORDER BY sc.TABLE_NAME, sc.COLUMN_NAME