The
ANURDFLN table is used for Oracle nested tables and is populated during the
Distributed loader phase. The following table describes the columns in the
ANURDFLN table:
| Column
|
Type
|
Length
|
Decimal
|
Domain
|
| MCRECID
|
SMALLINT
|
2
|
0
|
machine/company ID
|
| FILRECID
|
INTEGER
|
4
|
0
|
file ID
|
| FLDRECID
|
INTEGER
|
4
|
0
|
field ID
|
| FLDRECIDN
|
INTEGER
|
4
|
0
|
field ID for nested
|
| FLDNAME
|
CHAR
|
128
|
0
|
field name
|
| TYPNAME
|
CHAR
|
128
|
0
|
ODBC Data Type Name
|
| FLDLEN
|
INTEGER
|
4
|
0
|
field length
|
| FLDINT
|
SMALLINT
|
2
|
0
|
field integer
|
| FLDDEC
|
SMALLINT
|
2
|
0
|
field decimal
|
| FLDSIGN
|
CHAR
|
1
|
0
|
field sign
|
| FLDTYPE
|
CHAR
|
1
|
0
|
field type
|
| FLDNAT
|
CHAR
|
1
|
0
|
field nature
|
| FLJUSTIFY
|
CHAR
|
1
|
0
|
Justify flag
|
| NULLCAP
|
CHAR
|
1
|
0
|
Null capable field
|