ASA SQL Reference
  SQL Statements

WRITETEXT statement [T-SQL]

Description 

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

Syntax 

WRITETEXT table-name.column-name
text_pointer [ WITH LOG ] data

Usage 

Updates an existing text or image value. The update is not recorded in the transaction log, unless the WITH LOG option is supplied. You cannot carry out WRITETEXT operations on views.

Permissions 

None.

Side effects 

WRITETEXT does not fire triggers, and by default WRITETEXT operations are not recorded in the transaction log.

See also 

READTEXT statement [T-SQL]

TEXTPTR function [Text and image]

Standards and compatibility 

• SQL/92    Transact-SQL extension.

• SQL/99    Transact-SQL extension.

• Sybase    Supported by Adaptive Server Enterprise.

Example 

The following code fragment illustrates the use of the WRITETEXT statement. The SELECT statement in this example returns a single row. The example replaces the contents of the column_name column on the specified row with the value newdata.

EXEC SQL create variable textpointer binary(16);
EXEC SQL set textpointer =
   (  SELECT textptr(column_name)
      FROM table_name WHERE id = 5 );
EXEC SQL writetext table_name.column_name
   textpointer 'newdata';