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.