Sybase Adaptive Server Anywhere - WRITETEXT Statement [T-SQL]

WRITETEXT statement [T-SQL]
648
WRITETEXT statement [T-SQL]
Permits non-logged, interactive updating of an existing text or image
column.
WRITETEXT table-name . column-name
… text_pointer [ WITH LOG ] data
None.
WRITETEXT does not fire triggers, and by default WRITETEXT operations
are not recorded in the transaction log.
"READTEXT statement" on page 587
"TEXTPTR function" on page 371
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.
♦
SQL/92 Transact-SQL extension.
♦
Sybase Supported by Adaptive Server Enterprise.
♦ 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’;
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
Example