This shows you the differences between two versions of the page.
declare-temporary-table [2015/09/23 20:27] 127.0.0.1 external edit |
declare-temporary-table [2016/04/20 07:37] (current) dmtolpeko |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== DECLARE TEMPORARY TABLE - PL/HQL ====== | + | ====== DECLARE TEMPORARY TABLE ====== |
DECLARE TEMPORARY TABLE statement allows you to define a temporary table for the current session. | DECLARE TEMPORARY TABLE statement allows you to define a temporary table for the current session. | ||
Line 27: | Line 27: | ||
</code> | </code> | ||
- | For more details how temporary table support is implemented in PL/HQL, see [[temporary-tables|Native and Managed Temporary Tables]]. | + | For more details how temporary table support is implemented in HPL/SQL, see [[temporary-tables|Native and Managed Temporary Tables]]. |
**Example**: | **Example**: | ||
Line 34: | Line 34: | ||
<code language=sql> | <code language=sql> | ||
- | SET plhql.temp.tables = managed; | + | SET hplsql.temp.tables = managed; |
DECLARE TEMPORARY TABLE temp1 | DECLARE TEMPORARY TABLE temp1 | ||
Line 49: | Line 49: | ||
**Compatibility:** IBM DB2 | **Compatibility:** IBM DB2 | ||
- | **Version**: PL/HQL 0.03 | + | **Version**: HPL/SQL 0.03 |
See also: | See also: |