readtext

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}]

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

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

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
```