ALLBASE/SQL Reference Manual (36216-90216)

618 AppendixA
SQL Syntax Summary
TERMINATE USER
TERMINATE USER { DBEUserID
SessionID
CID ConnectionID }
TRANSFER OWNERSHIP
TRANSFER OWNERSHIP OF {[TABLE][ Owner. ] TableName
[VIEW][ Owner. ] ViewName
PROCEDURE [ Owner. ] ProcedureName
GROUP GroupName } TO NewOwnerName
TRUNCATE TABLE
TRUNCATE TABLE [ Owner .] TableName
UPDATE
UPDATE {[ Owner. ] TableName
[ Owner. ] ViewName }
SET { ColumnName = { Expression
‘LongColumnIOString’
NULL } } [,...]
[WHERE SearchCondition ]
LongColumnIOString
{ [<{[ PathName /] FileName
%SharedMemoryAddress }]
[{>
>>
>!}[ PathName /]{ FileName
CharString$
CharString$ CharString }
>% { SharedMemoryAddress
$ } ] } |...|
UPDATE STATISTICS
UPDATE STATISTICS FOR TABLE {[ Owner. ] TableName
SYSTEM. SystemViewName }
UPDATE WHERE CURRENT
UPDATE {[ Owner. ] TableName
[ Owner. ] ViewName }
SET { ColumnName = { Expression
‘LongColumnIOString’
NULL }}[,...]
WHERE CURRENT OF CursorName