Insert an lld_locator row into a table

The following example creates a table with an lld_locator row and shows how to insert a large object into the row.

Figure 1. Insert an lld_locator row into a table

--Create lobs table
create table lobs (key int primary key, lo lld_locator);

-- Create an lld_locator for an existing server file
insert into lobs
    values (1, "row('ifx_file',null,'/tmp/quote1.txt')");

The INSERT statement inserts an instance of an lld_locator row into the lobs table. The protocol in the first field, IFX_FILE, identifies the large object as a server file. The second field, lo_pointer, is used to point to a smart large object. Because the object is a server file, this field is NULL. The third field identifies the server file as quote1.txt.