Selecting text and image data

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

Table 1-17: text and image global variables




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.


ID of the column referenced by @@textptr.


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


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


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).


Text timestamp of the column referenced by @@textptr.