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.
- 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.
- If the target table contains no LOB column, do not specify the lobmid statement.
- 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
- Do not specify this information for a HiRDB/Single Server.
- HiRDB/Parallel Server
- 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
- 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
- Do not specify this information for a HiRDB/Parallel Server.
(c) LOB-middle-filename
<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-filename
<pathname>
Specifies the absolute pathname of the file to which error information is to be output.
This file must be located at the server machine or server where the LOB middle files are located.
If omitted, the database load utility creates a file with a unique name in the /tmp directory. For details about the error information file, see 5.6 Error information file.