STARTUP - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

One or more optional SQL requests, separated by SEMICOLON characters, that are performed to establish the session environment when the user logs on.

string
Strings can be up to 255 characters, must be terminated by a SEMICOLON character, and must be enclosed by APOSTROPHE characters. The default is null, meaning no startup string.
A startup string can perform a macro. However, the USING request modifier is not supported in a startup string. If a string includes a DDL statement, no other statement is allowed in the string.
You can also include a SET SESSION CALENDAR request in a startup string to set the calendar for a user to something other than the default Teradata calendar. The other available system-defined calendars are named ISO and COMPATIBLE. See SET SESSION CALENDAR in Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 for more information about this.
The startup string is performed either when you log on to Vantage through BTEQ or when you establish a JDBC connection using the Teradata JDBC driver and have specified the connection parameter RUNSTARTUP=ON. BTEQ and JDBC are the only client applications that support startup strings.
All other Teradata client APIs ignore the string when Vantage returns it to them.