The
HSURDFIN table is used for Oracle nested tables and is populated during the
Distributed loader phase. The following table describes the columns in the
HSURDFIN table:
| Column
|
Type
|
Length
|
Decimal
|
Domain
|
| MCRECID
|
BINARY
|
4
|
0
|
machine/company ID
|
| FILLIB
|
CHARACTER
|
128
|
0
|
file library
|
| FILTYPE
|
CHARACTER
|
4
|
0
|
file type
|
| FILNAME
|
CHARACTER
|
128
|
0
|
file name
|
| FILRECID
|
BINARY
|
9
|
0
|
file ID
|
| FILRECIDN
|
BINARY
|
9
|
0
|
file ID for nested
|
| COLNAME
|
CHARACTER
|
128
|
0
|
column name
|
| UNLFILTYP
|
CHARACTER
|
4
|
0
|
unload file type
|
| UNLFILNAM
|
CHARACTER
|
128
|
0
|
unload file name
|
| TYPNAME
|
CHAR
|
128
|
0
|
ODBC Data Type Name
|