The operation command and the utilities listed below cannot be executed on temporary tables. For details, see the manual HiRDB Version 9 Command Reference.

• pdorbegin command
• Optimizing information collection utility (pdgetcst)
• Database load utility (pdload)
• Global buffer residence utility (pdpgbfon)
• Free page release utility (pdreclaim)
• Database reorganization utility (pdrorg)

Limitations (such as that temporary tables and temporary table indexes cannot be specified) apply to the SQL statements listed below. For details, see the manual HiRDB Version 9 SQL Reference.

• Definition SQL statements
  ALLOCATE MEMORY TABLE
  ALTER INDEX
  ALTER TABLE
  CREATE INDEX
  CREATE TABLE
  CREATE TRIGGER
  DROP INDEX
  DROP SCHEMA
  DROP TABLE
  GRANT
  REVOKE
  
• Data manipulation SQL statements
  ALLOCATE CURSOR statement
  ASSIGN LIST statement
  DECLARE CURSOR statement
  Dynamic SELECT statement
  SELECT statement (table reference, query expression format 2)
  DELETE statement
  UPDATE statement
  
• Control SQL statements
  COMMIT statement
  DISCONNECT statement
  ROLLBACK statement
  LOCK TABLE statement
  SET SESSION AUTHORIZATION statement