Example: Extracting CLOB data to a file
Suppose that retrieve character large object (CLOB) elements from a table into an external file.
How the sample LOBFILE program works
- Declare host variables. The BEGIN DECLARE SECTION and END DECLARE SECTION statements delimit the host variable declarations. Host variables are prefixed with a colon (:) when referenced in an SQL statement. A CLOB FILE REFERENCE host variable is declared.
- CLOB FILE REFERENCE host variable is set up. The attributes of the FILE REFERENCE are set up. A file name without a fully declared path is, by default, placed in the user's current directory. If the path name does not begin with the forward slash (/) character, it is not qualified.
- Select into the CLOB FILE REFERENCE host variable. The data from the resume field is selected into the file name that is referenced by the host variable.
The CHECKERR macro/function is an error checking utility which is external to the program. The location of this error checking utility depends on the programming language used:
- C
- check_error is redefined as CHECKERR and is located in the util.c file.
- COBOL
- CHECKERR is an external program named checkerr.cbl.
- Example: LOBFILE.SQC in C
This example program, written in C, extracts CLOB data from a table to an external file.
- Example: LOBFILE.SQB in COBOL
This example program, written in COBOL, extracts CLOB data from a table to an external file.
Parent topic:
Large objects