A pointer in a text or image column is assigned when the column is initialized. Before you can enter text or image data into a column, the column must be initialized. This causes a 2K page to be allocated on the remote or Adaptive Server. To initialize text or image columns, use the update with a NULL or a non-null insert command.
Before you use writetext to enter text data or readtext to read it, the text column must be initialized. Use update or insert non-null data to initialize the text column, and then use writetext and readtext.
Using update to replace existing text and image data with NULL reclaims all of the allocated data pages, except the first page, in the remote server.
writetext, select into, DB-Library functions, or Client-Library functions must be used to enter text or image values that are larger than 16KB.
readtext is the most efficient way to access text and image data.
insert select and select into can be used to insert text and image data to proxy tables, but a unique index is required.
