Table and Field Definitions in XA [DB2]


33
views
1
3 months ago by
What are the table and field definitions in XA / DB2 iSeries.  Is there a cross reference to the table and field names and what each means?

Here is an example of a DDL that needs explanation:

create table amflib.momast (
ACREC varchar(1),
ORDNO varchar(7),
OSNOA varchar(7),
CUROP varchar(4),
NOMIS numeric,
NOOPS numeric,
ORQTY numeric,
QTDEV numeric,
OSTAT varchar(2),
ORLCD numeric,
JOBNO varchar(12),
REFNO varchar(10),
SSTDT numeric,
SSTTM numeric,
NCOPS numeric,
QCPRV numeric,
QCCUR numeric,
QTYRC numeric,
LATDT numeric,
HRREM numeric,
ASTDT numeric,
OCODT numeric,
ODUDT numeric,
ODUTM numeric,
Community: Zimmer Biomet

1 Answer


3
3 months ago by
The XA field information is available in the DB2 table QSYS.QADBIFLD.  Most users do not have access to this table.  Users with admin rights in the Query Tool Application can run queries against this table.

A copy of this data is also available in the Postgres meta schema.  

SELECT 
table_schema,
table_name, 
column_name,
column_text,
data_type,
length

FROM meta.as400_columns
where
table_schema = 'AMFLIB' and table_name = 'MOMAST'
order by ordinal_position​
Please login to add an answer/comment or follow this question.

Similar posts:
Search »