declare-temporary-table
Differences
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] 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: | ||
Page Tools
