readtext

Description

Reads text and image values, starting from a specified offset and reading a specified number of bytes or characters.

Syntax

readtext [[database.]owner.]table_name.column_name
text_pointer offset size 
[holdlock | noholdlock] [readpast]
[using {bytes | chars | characters}]
[at isolation {
	[ read uncommitted | 0 ] | 
	[ read committed | 1 ] |
	[ repeatable read | 2 ]| 
	[ serializable | 3 ] } ]]

Usage

Component Integration Services processes the readtext command when the table on which it operates has been created as a proxy table. Component Integration Services forwards the entire request (or part of it) to the server that owns the actual object.
When Component Integration Services forwards the readtext command to a remote server, the table name used is the remote table name, and the column names used are the remote column names. These names may not be the same as the local proxy table names.
The using bytes and at isolation clauses are ignored.
The holdlock, noholdlock and readpast options are ignored.

Server Class ASEnterprise

Component Integration Services forwards the following syntax to the remote server when the underlying table is a proxy table:
```
readtext [[database.]owner.]table_name.column_name
 text_pointer offset size
[using {chars | characters}]
```

Server Class ASAnywhere

Handling of the readtext statement is the same as for ASEnterprise.

Server Class ASIQ

Handling of the readtext statement is the same as for ASEnterprise.

Server Class sql_server

Handling of the readtext statement is the same as for ASEnterprise.

Server Class direct_connect

If the DirectConnect does not support text pointers, readtext cannot be sent and its use results in errors.
If the DirectConnect does support text pointers, Component Integration Services forwards the following syntax to the remote server:
```
readtext
 [[database.]owner.]table_name.column_name
text_pointer offset size 
 [using {chars | characters}]
```
readtext is issued anytime text or image data must be read. readtext is called when a select command refers to a text or image column in the select list, or when a where clause refers to a text or image column.

For example, you have a proxy table books that is mapped to the books table on the remote server foo. The columns are id, name, and the text column blurb. When the following statement is issued:
```
select * from books
```
Component Integration Services sends the following syntax to the remote server:
```
select id, name, textptr(blurb) from foo_books 
```
```
readtext foo_books.blurb @p1 0 0 using chars
```

Server Class db2

readtext is not supported since text and image datatypes are not supported for servers in class db2.

readtext

Description

Syntax

Usage

Server Class ASEnterprise

Server Class ASAnywhere

Server Class ASIQ

Server Class sql_server

Server Class direct_connect

Server Class db2

See also