Selecting text and image data

The following global variables return information on text and image data:

Table 1-18: text and image global variables

Variable

Explanation

@@textptr

The text pointer of the last text or image column inserted or updated by a process. Do not confuse this global variable with the textptr function.

@@textcolid

ID of the column referenced by @@textptr.

@@textdbid

ID of a database containing the object with the column referenced by @@textptr.

@@textobjid

ID of the object containing the column referenced by @@textptr.

@@textsize

Current value of the set textsize option, which specifies the maximum length, in bytes, of text or image data to be returned with a select statement. It defaults to 32K. The maximum size for @@textsize is 231 - 1 (that is, 2,147,483,647).

@@textts

Text timestamp of the column referenced by @@textptr.