Large Object Data Load Example

Create and load a table with LONG BINARY data.

CREATE TABLE ltab (c1 INT, filename CHAR(64),
	ext CHAR(6), lobcol LONG BINARY NULL);
LOAD TABLE ltab (
	c1,
	filename,
	ext NULL(‘NULL’),
	lobcol BINARY FILE (‘,’) NULL(‘NULL’)
)
FROM ‘abc.inp’
QUOTES OFF ESCAPES OFF;

The primary file abc.inp contains this data: 

1,boston,jpg,/s1/loads/lobs/boston.jpg,
2,map_of_concord,bmp,/s1/loads/maprs/concord.bmp,
3,zero length test,NULL,,
4,null test,NULL,NULL,

After the LONG BINARY data is loaded into table tab, the first and second rows for column lobcol contain the contents of files boston.jpg and concord.bmp, respectively. The third and fourth rows contain a zero-length value and NULL, respectively.

Parent topic: Large Object Data Loads