ASA SQL Reference
  SQL Statements

READTEXT statement [T-SQL]

Description 

Use this statement to read text and image values from the database, starting from a specified offset and reading a specified number of bytes.

Syntax 

READTEXT table-name.column-name
text-pointer offset size
[HOLDLOCK]

Usage 

READTEXT is used to read image and text values from the database. You cannot perform READTEXT operations on views.

Permissions 

SELECT permissions on the table.

Side effects 

None.

See also 

WRITETEXT statement [T-SQL]

GET DATA statement [ESQL]

TEXTPTR function [Text and image]

Standards and compatibility 

• SQL/92    Transact-SQL extension.

• SQL/99    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.