|
QADBIFLD - Fields Reference |
|
| |
|
Columns Listing
|
|
QSYS/QADBIFLD
|
|
Name
|
|
Type
|
Len
|
Prec
|
Scale
|
Nulls?
|
Description
|
|
DBILIB
|
|
Char
|
10
|
|
|
N
|
Library
name
|
|
DBIFIL
|
|
Char
|
10
|
|
|
N
|
File name
|
|
DBIFMT
|
|
Char
|
10
|
|
|
N
|
Format
name
|
|
DBIFLD
|
|
Char
|
10
|
|
|
N
|
Field
name
|
|
DBIATR
|
|
Char
|
2
|
|
|
N
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
DBIREL
|
|
Char
|
1
|
|
|
N
|
Relational
file: Y=Yes,N=No
|
|
DBILFI
|
|
Char
|
128
|
|
|
N
|
Long file
name
|
|
DBIOWN
|
|
Char
|
10
|
|
|
N
|
User
profile name of owner
|
|
DBILFL
|
|
Char
|
128
|
|
|
N
|
Long
field name
|
|
DBILFQ
|
|
Char
|
1
|
|
|
N
|
Long
field name is quoted
|
|
DBIINT
|
|
Char
|
10
|
|
|
N
|
Internal
field name
|
|
DBIILN
|
|
Integer
|
|
10
|
|
N
|
Internal
length in bytes
|
|
DBIITP
|
|
Char
|
1
|
|
|
N
|
Internal
data type
|
|
DBITYP
|
|
Char
|
8
|
|
|
N
|
Data type
|
|
DBIPOS
|
|
Small
Integer
|
5
|
|
N
|
Field
position within format
|
|
DBIFLN
|
|
Integer
|
|
10
|
|
N
|
SQL
length of field
|
|
DBICLN
|
|
Integer
|
|
10
|
|
Y
|
Character
field length
|
|
DBICNC
|
|
Integer
|
|
10
|
|
Y
|
Character
field number of characters
|
|
DBICCC
|
|
Integer
|
|
10
|
|
Y
|
Character
field CCSID
|
|
DBINLN
|
|
Small
Integer
|
5
|
|
Y
|
Numeric
field precision
|
|
DBINSC
|
|
Small
Integer
|
5
|
|
Y
|
Numeric
field scale
|
|
DBIRDX
|
|
Small
Integer
|
5
|
|
Y
|
Precision:
2=Binary, 10=Decimal
|
|
DBIDLN
|
|
Small
Integer
|
5
|
|
Y
|
Date/Time
field precision
|
|
DBITXT
|
|
Char
|
50
|
|
|
Y
|
Field
text
|
|
DBIHDG
|
|
Char
|
60
|
|
|
Y
|
Field
headings
|
|
DBINUL
|
|
Char
|
1
|
|
|
N
|
Allow
NULL value: Y-Yes,N-No
|
|
DBIUPD
|
|
Char
|
1
|
|
|
N
|
Allow
UPDATE: Y-Yes,N-No
|
|
DBIREM
|
|
Char
|
###
|
|
|
Y
|
Long
field description
|
|
DBIDFI
|
|
Char
|
1
|
|
|
N
|
Default
indicator: Y-Yes,N-No
|
|
DBIDFT
|
|
Char
|
###
|
|
|
Y
|
Field
default value
|
|
DBIFMP
|
|
Small
Integer
|
5
|
|
N
|
Position
of format in file
|
|
DBILB2
|
|
Char
|
128
|
|
|
N
|
Library
name
|
|
DBITLN
|
|
Char
|
128
|
|
|
N
|
UDT Long
Name
|
|
DBITLB
|
|
Char
|
128
|
|
|
N
|
UDT Library
Name
|
|
Available Indexes
|
|
QSYS/QADBIFLD
|
|
Index
Name
|
Unique?
|
SortSeq
|
ColName
|
Description
|
|
QADBIFLD
|
TRUE
|
Asc
|
DBILIB
|
Library
name
|
|
|
|
Asc
|
DBIFIL
|
File name
|
|
|
|
Asc
|
DBIFMP
|
Position
of format in file
|
|
|
|
Asc
|
DBIFMT
|
Format
name
|
|
|
|
Asc
|
DBIPOS
|
Field
position within format
|
|
|
|
|
|
|
|
QADBIATR
|
FALSE
|
Asc
|
DBIATR
|
PF-physical,LF-logical,TB-table,VW-view,IX-index
|
|
|
|
Asc
|
DBILIB
|
Library
name
|
|
|
|
Asc
|
DBIFIL
|
File name
|
|
|
|
Asc
|
DBIFMP
|
Position
of format in file
|
|
|
|
Asc
|
DBIFMT
|
Format
name
|
|
|
|
Asc
|
DBIFLD
|
Field
name
|
|
|
|
|
|
|
|
QADBILFI
|
FALSE
|
Asc
|
DBILIB
|
Library
name
|
|
|
|
Asc
|
DBILFI
|
Long file
name
|
|
|
|
Asc
|
DBIFMP
|
Position
of format in file
|
|
|
|
Asc
|
DBIFMT
|
Format
name
|
|
|
|
Asc
|
DBILFL
|
Long
field name
|
|
|
|
|
|
|
|
QADBILLB
|
FALSE
|
Asc
|
DBILB2
|
Library
name
|
|
|
|
Asc
|
DBILFI
|
Long file
name
|
|
|
|
|
|
|
|
QADBIUDT
|
FALSE
|
Asc
|
DBITLB
|
UDT
Library Name
|
|
|
|
|
|
|
|
QAZDCOLM
|
FALSE
|
Asc
|
DBILIB
|
Library
name
|
|
|
|
Asc
|
DBILFI
|
Long file
name
|
|
|
|
|
|
|
|
QAZDGCOL
|
FALSE
|
Asc
|
DBILFL
|
Long
field name
|
|
|
|
Asc
|
DBILIB
|
Library
name
|
|
|
|
Asc
|
DBILFI
|
Long file
name
|
|
|
|