Page History: Data Dictionary - AS/400

Compare Page Revisions

2 1 0 Current 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Tue, Feb 20, 2024, 12:02 PM

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'