Non in-row storage

An opaque data type can use the following types of non in-row storage:
  • Smart large object (BLOB and CLOB)
  • Files
  • A non in-row storage type that is dependent on the local computer

    For example, this storage type might be a reference to a tape storage system.

  • A non in-row storage type that is not dependent on the database server

    For example, this storage type might be a file reference that includes the location of the computer where the user of the reference goes directly to the designated computer, bypassing the database server where the reference is stored.

The routines that support the opaque data type should do the following:
  • Include room in the storage handle for location information

    The location information should include the database server name, and, if the data type is dependent on a particular database, the database name.

  • Provide routines to set and get the location information from the storage handle to include in the server-send support functions
  • Provide support for remote data in the access routines

    For example, the open routine must recognize a reference to a remote database server and access it appropriately.