Add a global temporary table to the database. A global temporary table definition is kept in the database permanently. (The data disappears when you close the connection.)
Database Version | Table Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | Global temporary table to be owned by self – you must have RESOURCE
authority with CREATE permission on the main store dbspace in which the
table is created. Global temporary table to be owned by any user – you must have DBA authority. |
SAP Sybase IQ 16.0 | Global temporary table to be owned by self – you must have the CREATE
TABLE system privilege. Global temporary table to be
owned by any user – you must have one of:
|
In a multiplex configuration, the coordinator node is running.
For large tables, modifying an existing table or creating a new table can be a time-consuming operation. The internal CREATE TABLE statement delays execution of other processes until the statement completes. Although you modify tables while other connections are active, you cannot execute them while any other connection uses the table to be altered. Modifying a table excludes other requests referencing the table being offered while the internal ALTER TABLE statement processes.