Data Dictionary - AS/400

select 
     ordinal_position as Seq
    ,column_name as Name
    ,column_text as Desc
    ,data_type as DataType
from 
    QSYS2.SYSCOLUMNS
where 1=1
    and table_schema = 'MVXBDTA002' 
    and table_name = 'OOHEAD'

select 
     TABLE_NAME
    ,TABLE_TEXT
from 
    QSYS2.SYSTABLES
where 1=1
    and table_name in ('OOHEAD')
    and table_schema = 'MVXBDTA002'