Example: Using Constant Expression to Specify TEMPORARY Space for Profile - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

This is the original definition of the research_and_development.profile.

CREATE PROFILE research_and_development AS 
DEFAULT DATABASE = it_dev, 
PASSWORD = secret, 
TEMPORARY = 2000000*(HASHAMP()+1); 

The following statement changes the TEMPORARY space for the profile research_and_development to a size based on the constant expression 3,000,000 (HASHAMP()+1). The expression calculates the number of AMPs in the current system and scales the TEMPORARY space for the research_and_development profile to that size.

MODIFY PROFILE research_and_development AS 
DEFAULT DATABASE = it_dev, 
PASSWORD = secret, 
TEMPORARY = 3000000*(HASHAMP()+1);