Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Data Dictionary - AS/400

RSS
Modified on Tue, Feb 20, 2024, 12:19 PM by Administrator Categorized as 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'

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.