- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Purpose and table creation syntax of “Created temporary table”
The Created temporary tables are non-permanent DB2 tables that exist as long as the process using this table is active. For example any batch program. The created temporary tables are best suited for the sequential access and hence system performance is not a concern over here.
The created temporary tables can be created using the DDL statement CREATE GLOBAL TEMPORARY TABLE followed by the name of the temporary table. This statement makes the entry of the new table in DB2 system table SYSIBM.SYSTABLES with type column as ‘G’.
The created temporary table should always be created using the above DDL statement before it can be accessed by any program. In addition to this the indexes and constraints cannot be defined on them.
- Related Articles
- Purpose and table creation syntax of “Declared temporary table”
- How to get the creation time of recently created table in MySQL?
- How can I delete MySQL temporary table?
- Deleting from temporary table in SAP HANA
- Create a temporary table similar to a regular table with MySQL LIKE
- How to get the creation date of a MySQL table?
- Create a MySQL table from already created table selecting specific rows?
- Create a temporary table in a MySQL procedure?
- How to list temporary table columns in MySQL?
- Create a temporary table with dates in MySQL
- How do I get the creation date of a MySQL table?
- Executing a table creation using UI in SAP HANA Studio
- How to create a temporary MySQL table in a SELECT statement without a separate CREATE TABLE?
- How to store time created in a MySQL table?
- PHP and MYSQL database connection and table creation only once if it does not already exist?
Advertisements