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 Tue, Nov 14, 2023, 6:46 AM by Administrator Categorized as AS/400
select 
     ordinal_position as Seq
    ,column_name as Col
    ,data_type as DataType
    ,character_maximum_length as MaxLen
    ,numeric_precision as Prec
    ,numeric_scale as Scale 
from 
    INFORMATION_SCHEMA.COLUMNS 
where 1=1
    and table_schema = 'MVXBDTA002' 
    and table_name = 'OINACC'
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.