writetext

Description

Permits non-logged, interactive updating of an existing text or image column.

Syntax

writetext [[database.]owner.]table_name.column_name
 text_pointer [with log] data

Usage

Component Integration Services processes the writetext command when the table on which it operates has been created as a proxy table.
If the remote server referenced by the proxy table does not support text pointers, writetext is not supported.

To process the writetext command, Component Integration Services issues the following Client Library commands using the connection established to the remote server:

ct_command(command, CS_SEND_DATA_CMD, NULL,
 CS_UNUSED, CS_COLUMN_DATA);

ct_data_info(command, CS_SET, CS_UNUSED, iodesc)

ct_send_data(command, (CS_VOID *) start, length)

Server Class ASEnterprise

The writetext command is processed using a separate connection to the remote server.

Server Class ASAnywhere

The writetext command is processed using a separate connection to the remote server.

Server Class ASIQ

The writetext command is processed using a separate connection to the remote server.

Server Class sql_server

The writetext command is processed using a separate connection to the remote server.

Server Class direct_connect

If the DirectConnect supports text pointers, Component Integration Services treats the DirectConnect as if it were a server in class sql_server.

Server Class db2

writetext is not supported for tables owned by servers in this class.