Smart LOB 데이터 UNLOAD/LOAD시 파일형식

Question

The SQL UNLOAD TO statement places a reference to the Smart Large Object (BLOB or CLOB) into the UNLOAD TO file and the BLOB or CLOB data into a separate Smart Large Object file. What is the format of the reference in the UNLOAD TO/LOAD FROM file and the format of the name assigned to the BLOB or CLOB file?

Answer

The Smart Large Object file has a name in one of these formats:

For a BLOB value: blob#####.###
For a CLOB value: clob#####.###

예) 파일내용. 오프셋은 16진수로 표현한다

|100,200,/usr/apps/clob9ce7.318|

######.###
The digits of the unique hexadecimal smart-large-object identifier. Automatically assigned to the file when it is created.

In an UNLOAD TO/LOAD FROM file, a BLOB or CLOB column value appears as follows:

start_offset,length,location_path

start_offset
The starting offset (bytes, in hexadecimal) of the smart large object value within the blob/clob file.

length 
The length (bytes, in hexadecimal) of the BLOB or CLOB value.

location_path
The full pathname to the location where the blob/clob file is stored. If a full path is not specified the current directory will be used.

Note: No blank spaces can appear between these values. 

http://www-01.ibm.com/support/docview.wss?rs=0&uid=swg21197723