Reads text and image values, starting from a specified offset and reading a specified number of bytes or characters.
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 ] } ]]
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.
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
readtext is not supported since text and image datatypes are not supported for servers in class db2.
readtext in the Reference Manual
