Sybase Adaptive Server Anywhere - Page 389

Chapter 8 SQL Functions
371
TEXTPTR function [String]
Returns the 16-byte binary pointer to the first page of the specified text
column.
TEXTPTR ( column-name )
column-name The name of a text column.
Use TEXTPTR to locate the text column, copy, associated with au_id 486-
29-1786 in the author’s blurbs table.
The text pointer is put into a local variable @val and supplied as a parameter
to the readtext command, which returns 5 bytes, starting at the second byte
(offset of 1).
DECLARE @val VARBINARY(16)
SELECT @val = TEXTPTR(copy)
FROM blurbs
WHERE au_id = "486-29-1786"
READTEXT blurbs.copy @val 1 5
This function is included for Transact-SQL compatibility.
♦
SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
TODAY function [Date and time]
Returns the current date. This is the historical syntax for CURRENT DATE.
TODAY ( * )
The following statement returns the current day according to the system
clock.
SELECT TODAY( * )
♦ SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
TRACEBACK function [Miscellaneous]
Returns a string containing a traceback of the procedures and triggers that
were executing when the most recent exception (error) occurred.
TRACEBACK ( * )
Function
Syntax
Parameters
Example
Usage
Standards and
compatibility
Function
Syntax
Examples
Standards and
compatibility
Function
Syntax