Table Definitions - AS/400

select 
     c.ordinal_position as Seq
    ,c.column_name as Col
    ,c.data_type as DataType
    ,c.character_maximum_length as MaxLen
    ,c.numeric_precision as Prec
    ,c.numeric_scale as Scale 
    ,q.column_text as Description
from 
    INFORMATION_SCHEMA.COLUMNS c
    left join QSYS2.SYSCOLUMNS q
        on c.table_schema = q.table_schema
        and c.table_name = q.table_name
        and c.column_name = q.column_name
where 1=1
    and c.table_schema = 'MVXBDTA002' 
    and c.table_name = 'OOHEAD'
order by
    Seq