Sybase Adaptive Server Anywhere - READTEXT Statement [T-SQL]

Chapter 9 SQL Statements
587
READTEXT statement [T-SQL]
Use this statement to read text and image values from the database, starting
from a specified offset and reading a specified number of bytes.
READTEXT table-name.column-name
… text-pointer offset size
… [HOLDLOCK]
SELECT permissions on the table.
None.
"WRITETEXT statement" on page 648
"GET DATA statement" on page 535
"TEXTPTR function" on page 371
READTEXT is used to read image and text values from the database. You
cannot perform READTEXT operations on views.
♦
SQL/92 Transact-SQL extension.
♦
Sybase Supported by Adaptive Server Enterprise.
Adaptive Server Enterprise supports the following clause, which is not
supported by Adaptive Server Anywhere:
USING { BYTES | CHARS | CHARACTERS }
These options are identical for all single-byte character sets. Adaptive
Server Anywhere uses bytes only, which is the Adaptive Server
Enterprise default setting.
Adaptive Server Enterprise also provides isolation level control in the
READTEXT statement. This is not supported in Adaptive Server
Anywhere.
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility