When loading data to a table containing LOB columns, you can use the lomid statement to specify information about the LOB middle files.
During the creation of a LOB column structure base table, the system outputs information needed for data loading to LOB columns to LOB middle files.
- Criteria
- When loading data to a table with LOB columns, if you specify the -k d option, be sure to specify the lobmid statement. However, the lobmid statement, if specified, is ignored for a LOB input parameter to a constructor function that generates values to be stored in the columns of abstract data type.
- Rules
- Specify the lobmid statement if you also specify the -k f, -k c, or -k v option.
- The contents of a LOB middle file depend on the specification of the -k option. If you are creating a LOB column structure base table separately from LOB data, you must specify the same -k option.
- If data is to be loaded into a LOB column structure base table and the lobmid statement is omitted, the utility creates a LOB middle file with a unique file name in the format shown below at the server machine where the input data file is located:
/directory-name/LOBMID-xxxxxxxxx |
directory-name: Directory shown in Table 5-58 Directories to which pdload outputs files
LOBMID-: Prefix for a LOB middle file
xxxxxxxx: Value obtained by converting the file creation time and process ID to a character string
- When creating the LOB column structure base table and LOB columns at the same time, the source statement has precedence; therefore, there is no need to specify the server name, host name, or error information file name. If specified, they are ignored.
- Organization of this subsection
- (1) Format
- (2) Explanation
- (3) Notes about the LOB middle files
(a) RDAREA-name
~<identifier> ((1-30))
Specifies the name of the user LOB RDAREA.
If you omit this operand, the system loads the entire contents of the specified LOB middle files.
If you are specifying a replica RDAREA, specify the original RDAREA name for RDAREA-name and the target generation number in the -q option.
The system treats an RDAREA name in double quotation marks as case sensitive; otherwise, the system treats it as all uppercase letters. Enclose an RDAREA name in double quotation marks if it contains a space.
(b) [server-name|host-name]
Specifies the name of the server or host where the LOB middle files are located.
- server-name ~<identifier> ((1-8))
- HiRDB single server configuration
- Do not specify this information for a HiRDB single server configuration.
- HiRDB parallel server configuration
- Specify the name of the front-end server or back-end server where the specified LOB middle files are located.
- If you specified an RDAREA name, you can omit this operand (be sure to specify either the RDAREA name or the server name).
- If the server name is omitted, the system assumes the name of the server where the specified RDAREA is located.
- host-name ~<identifier> ((1-32))
- HiRDB single server configuration
- Specify the name of the host where the specified LOB middle files are located.
- This must be the host name of the single server or the utility special unit.
- You can omit this operand whether or not you specified an RDAREA name. If omitted, the system assumes the name of the host where the database load utility (pdload command) is executed.
- HiRDB parallel server configuration
- Do not specify this information for a HiRDB parallel server configuration.
(c) LOB-middle-file-name
~<pathname>
Specifies the absolute pathname of a LOB middle file.
During the creation of a LOB column structure base table, the system outputs the information required for loading LOB column data to this LOB middle file. During the data loading to LOB columns, the system retrieves necessary information from this LOB middle file.
(d) error=error-information-file-name
~<pathname>
Specifies the absolute pathname of the file to which error information is to be output.
You must specify the name of a file on the unit where the LOB middle file is located. If the specified file dos not exist, the utility creates a file with the specified file name. For this reason, there is no need to create a file in advance. If you omit the error operand, the utility creates a file with a unique name in the following format:
/directory-name/ERROR-xxxxxxxxx |
- directory-name: Directory shown in Table 5-58 Directories to which pdload outputs files
- ERROR-: Prefix for an error information file
- xxxxxxxx: Value obtained by converting the file creation time and process ID to a character string