Application Development Guide

Example: Inserting Data Into a CLOB Column

In the path description of the following C program segment:

• userid represents the directory for one of your users.
• dirname represents a subdirectory name of "userid".
• filnam.1 can become the name of one of your documents that you wish to insert into the table.
• clobtab is the name of the table with the CLOB data type.

The following example shows how to insert data from a regular file referenced by :hv_text_file into a CLOB column (note that the path names used in the example are for UNIX-based systems):

     strcpy(hv_text_file.name, "/u/userid/dirname/filnam.1"); 
     hv_text_file.name_length = strlen("/u/userid/dirname/filnam.1"); 
     hv_text_file.file_options = SQL_FILE_READ; /* this is a 'regular' file */ 
  
     EXEC SQL INSERT INTO CLOBTAB 
       VALUES(:hv_text_file);