Stored Procedure Support

Learn about stored procedure support for the LONG BINARY (BLOB) and LONG VARCHAR (CLOB) data type columns and full text searching.

• Term Management in a TEXT Index
  You can use stored procedures to break strings into terms, to discover how many terms are in the TEXT index and their position, and to display statistical information about the TEXT indexes.
• External Library Identification
  The sa_list_external_library stored procedure lists the libraries that are currently loaded in the server. Once identified, use sa_external_library_unload to unload the library from the server.
• Large Object Data Compression
  The sp_iqsetcompression stored procedure controls the compression of large object columns.
• Information About Large Object Columns
  The stored procedure sp_iqindexsize displays the size of an individual LONG BINARY and LONG VARCHAR column.