HP 3000 Manuals

ALLBASE/SQL Reference Manual

SQL Syntax Summary (Continued) 

STOP DBE 

STOP DBE
[REV BEG]

TERMINATE QUERY 

TERMINATE QUERY FOR {CID ConnectionID }
                    {XID TransactionID}
[REV END][REV BEG]

TERMINATE TRANSACTION 

TERMINATE TRANSACTION FOR {CID ConnectionID }
                          {XID TransactionID}

TERMINATE USER 

               {DBEUserID       }
TERMINATE USER {SessionID       }
               {CID ConnectionID}
[REV END]

TRANSFER OWNERSHIP 

                      {[TABLE] [Owner.]TableName      }
TRANSFER OWNERSHIP OF {[VIEW] [Owner.]ViewName        } TO NewOwnerName 
                      {PROCEDURE [Owner.]ProcedureName}
                      {GROUP GroupName                }

TRUNCATE TABLE 

TRUNCATE TABLE [Owner.]TableName 

UPDATE 

                                {             {Expression          }}
UPDATE {[Owner.]TableName}  SET {ColumnName = {'LongColumnIOString'}}
       {[Owner.]ViewName }      {             {NULL                }}

[,...]  [WHERE SearchCondition]

LongColumnIOString.   

{[< {FileName[.Group[.Account]]}]   }
{[  {%HeapAddress:LengthofHeap }]   }
{                                   }
{[{> } {FileName[.Group[.Account]]}]} |...|
{[{>>} {CharString$               }]}
{[{>!} {CharString$CharString     }]}
{[                                 ]}
{[>%$                              ]}

UPDATE STATISTICS 

UPDATE STATISTICS FOR TABLE {[Owner.]TableName    }
                            {SYSTEM.SystemViewName}

UPDATE WHERE CURRENT 

                                {             {Expression          }}
UPDATE {[Owner.]TableName}  SET {ColumnName = {'LongColumnIOString'}}
       {[Owner.]ViewName }      {             {NULL                }}

[,...]  WHERE CURRENT OF CursorName 

LongColumnIOString.   

{[< {FileName[.Group[.Account]]}]   }
{[  {%HeapAddress:LengthofHeap }]   }
{                                   }
{[{> } {FileName[.Group[.Account]]}]} |...|
{[{>>} {CharString$               }]}
{[{>!} {CharString$CharString     }]}
{[                                 ]}
{[>%$                              ]}
[REV BEG]

VALIDATE 

VALIDATE [FORCE          ]
         [DROP SETOPTINFO]

{MODULE {{[Owner.]ModuleName}[,...]                         }      }
{       {{SECTION [Owner.]ModuleName (Section Number)}[,...]}      }
{                                                                  }
{PROCEDURE {{[Owner.]ProcedureName}[,...]                         }}
{          {{SECTION [Owner.]ProcedureName (Section Number)}[,...]}}
{                                                                  }
{ALL {MODULES   } [WITH AUTOCOMMIT]                                }
{    {PROCEDURES}                                                  }
[REV END]

WHENEVER 

         {SQLERROR  } {STOP           }
WHENEVER {SQLWARNING} {CONTINUE       }
         {NOT FOUND } {GOTO [:] Label }
                      {GO TO [:] Label}

WHILE 

WHILE Condition DO [Statement; [...]] ENDWHILE;

MPE/iX 5.5 Documentation