How You Can Create a Bitmap Storage Table
To store bitmaps in a database, use OpenROAD to add them to a table. OpenROAD automatically creates a special bitmap storage table, called ii_stored_bitmaps. You can also create your own storage table.
If you create your own bitmap storage table, it must be owned by someone with authority to grant user permissions to use it, and it must have the following columns and data types:
picture_id
Data Type: i4 not null
Specifies the ID of the bitmap in the table. This value is a sequential number, starting from 1, that is established when the bitmap is inserted into the database. In the DBHandle for this bitmap, this ID appears in textual form after the table name.
row_sequence
Data Type: i4 not null
Specifies the sequence number for bitmap in picture_id. It is numbered starting from 1.
text_total
Data Type: i4 not null
Specifies the total number of bytes in the full encoding of the image
text_value
Data Type: varchar(1786) not null
Specifies one 1786-byte piece of encoding string
Create this table as a B-tree structure (compressed or not), with the unique key values on picture_id and row_sequence. Be sure to grant the correct permissions.