The following global variables return information on text, unitext, and image data:
Variable |
Explanation |
---|---|
@@textptr |
The text pointer of the last text, unitext, 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, unitext, 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. |
Copyright © 2005. Sybase Inc. All rights reserved. |