| |
This file describes all
of the physical files, logical files, views and indexes on your AS/400. It does not describe objects created in the
QTEMP library.
|
Columns Listing
|
|
QSYS/QADBXREF
|
|
Name
|
|
Type
|
Len
|
Prec
|
Scale
|
Nulls?
|
Description
|
|
DBXFIL
|
|
Char
|
10
|
|
|
N
|
File name
|
|
DBXLIB
|
|
Char
|
10
|
|
|
N
|
Library
name
|
|
DBXDIC
|
|
Char
|
10
|
|
|
N
|
Dictionary
name
|
|
DBXOWN
|
|
Char
|
10
|
|
|
N
|
User
profile name of owner
|
|
DBXTXT
|
|
Char
|
50
|
|
|
N
|
File text
|
|
DBXATR
|
|
Char
|
2
|
|
|
N
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
DBXLNK
|
|
Char
|
1
|
|
|
N
|
E-ext
described, P-pgm described, Blank-no link
|
|
DBXSQL
|
|
Char
|
1
|
|
|
N
|
I-IDDU,S-SQL,C-CRTDTADCT,X-migration,Blank-no
link
|
|
DBXTYP
|
|
Char
|
1
|
|
|
N
|
D-data
file, S-source file
|
|
DBXNFL
|
|
Numeric
|
|
5
|
0
|
N
|
Maximum
number of fields
|
|
DBXNKF
|
|
Numeric
|
|
5
|
0
|
N
|
Maximum
number of key fields
|
|
DBXRDL
|
|
Numeric
|
|
11
|
0
|
N
|
Maximum
record length
|
|
DBXIDV
|
|
Numeric
|
|
11
|
0
|
N
|
Dictionary
internal file definition ID
|
|
DBXREL
|
|
Char
|
1
|
|
|
N
|
Relational
file: Y=Yes,N=No
|
|
DBXLFI
|
|
Char
|
128
|
|
|
N
|
Long file
name
|
|
DBXLFQ
|
|
Char
|
1
|
|
|
N
|
Long file
name is quoted
|
|
DBXWCO
|
|
Char
|
1
|
|
|
Y
|
C-CASCADED,
Y-Yes (local), N-No
|
|
DBXUPD
|
|
Char
|
1
|
|
|
N
|
Y-Yes,
N-No
|
|
DBXUNQ
|
|
Char
|
1
|
|
|
Y
|
D-No,
V-Yes (allow NULL duplicates), U-Yes
|
|
DBXREM
|
|
Char
|
###
|
|
|
Y
|
Long file
description
|
|
DBXDFN
|
|
Char
|
###
|
|
|
Y
|
SQL VIEW
definition
|
|
DBXATS
|
|
Timestamp
|
|
|
N
|
File
change timestamp
|
|
DBXLB2
|
|
Char
|
128
|
|
|
N
|
Library
name
|
|
DBXADB
|
|
Char
|
18
|
|
|
Y
|
Alias
Relational Database name
|
|
DBXALB
|
|
Char
|
128
|
|
|
Y
|
Alias
Library name
|
|
DBXAFL
|
|
Char
|
128
|
|
|
Y
|
Alias
File name
|
|
DBXAMB
|
|
Char
|
10
|
|
|
Y
|
Alias
Member name
|
|
Available Indexes
|
|
QSYS/QADBXREF
|
|
Index
Name
|
Unique?
|
SortSeq
|
ColName
|
Description
|
|
QADBXREF
|
FALSE
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXFIL
|
File name
|
|
|
|
|
|
|
|
QADBXATR
|
FALSE
|
Asc
|
DBXATR
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
|
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXFIL
|
File name
|
|
|
|
|
|
|
|
QADBXDIC
|
FALSE
|
Asc
|
DBXDIC
|
Dictionary
name
|
|
|
|
Asc
|
DBXIDV
|
Dictionary
internal file definition ID
|
|
|
|
|
|
|
|
QADBXFIL
|
FALSE
|
Asc
|
DBXFIL
|
File name
|
|
|
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
|
|
|
|
QADBXLFI
|
TRUE
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXLFI
|
Long file
name
|
|
|
|
|
|
|
|
QADBXLFN
|
FALSE
|
Asc
|
DBXLFI
|
Long file
name
|
|
|
|
|
|
|
|
QADBXLLB
|
FALSE
|
Asc
|
DBXLB2
|
Library
name
|
|
|
|
Asc
|
DBXLFI
|
Long file
name
|
|
|
|
|
|
|
|
VDI0001
|
FALSE
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXATR
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
|
|
|
|
|
|
QAZDGTB1
|
FALSE
|
Asc
|
DBXTYP
|
D-data
file, S-source file
|
|
|
|
Asc
|
DBXATR
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
|
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXLFI
|
Long file
name
|
|
|
|
|
|
|
|
QAZDGTB4
|
FALSE
|
Asc
|
DBXTYP
|
D-data
file, S-source file
|
|
|
|
Asc
|
DBXATR
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
|
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXLFI
|
Long file
name
|
|
|
|
|
|
|
|
QAZDGTB5
|
FALSE
|
Asc
|
DBXTYP
|
D-data
file, S-source file
|
|
|
|
Asc
|
DBXATR
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
|
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXLFI
|
Long file
name
|
|
|
|
|
|
|
|
QAZDGTB7
|
FALSE
|
Asc
|
DBXTYP
|
D-data
file, S-source file
|
|
|
|
Asc
|
DBXATR
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
|
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXLFI
|
Long file
name
|
|
|
|
|
|
|
|
QAZDTBL1
|
FALSE
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXTYP
|
D-data
file, S-source file
|
|
|
|
Asc
|
DBXATR
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
|
|
Asc
|
DBXLFI
|
Long file
name
|
|
|
|
|
|
|
|
QAZDTBL2
|
FALSE
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXTYP
|
D-data
file, S-source file
|
|
|
|
Asc
|
DBXATR
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
|
|
Asc
|
DBXLFI
|
Long file
name
|
|
|
|
|
|
|
|
QAZDTBL3
|
FALSE
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXTYP
|
D-data
file, S-source file
|
|
|
|
Asc
|
DBXATR
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
|
|
Asc
|
DBXLFI
|
Long file
name
|
|
|
|
|
|
|
|
QAZDTBL4
|
FALSE
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXTYP
|
D-data
file, S-source file
|
|
|
|
Asc
|
DBXATR
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
|
|
Asc
|
DBXLFI
|
Long file
name
|
|
|
|
|
|
|
|
QAZDTBL5
|
FALSE
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXTYP
|
D-data
file, S-source file
|
|
|
|
Asc
|
DBXATR
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
|
|
Asc
|
DBXLFI
|
Long file
name
|
|
|
|
|
|
|
|
QAZDTBL6
|
FALSE
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXTYP
|
D-data
file, S-source file
|
|
|
|
Asc
|
DBXATR
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
|
|
Asc
|
DBXLFI
|
Long file
name
|
|
|
|
|
|
|
|
QAZDTBL7
|
FALSE
|
Asc
|
DBXLIB
|
Library
name
|
|
|
|
Asc
|
DBXTYP
|
D-data
file, S-source file
|
|
|
|
Asc
|
DBXATR
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
|
|
Asc
|
DBXLFI
|
Long file
name
|
|
|