Temporary Tables in Db2 SQL. Using for Effective SQL!
Presented by: Brian Laube, Manulife Financial
In this video you’ll learn:
-DGTT: Declared Global Temporary Table
-CGTT: Created Global Temporary Table
-A real life example of miss use of DGTT vs. CGTT
-Use cases for DGTT vs. CGTT
-A simple example with sample code of using DGTT vs. CGTT
-Other temporary concepts in Db2 SQL: common table expressions (CTE), derived tables—named tables, table function
Comments are closed.