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

Table Definitions - AS/400

RSS
Modified on Wed, Mar 13, 2024, 6:21 AM by Administrator Categorized as 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

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