17.05 - STARTUP - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

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

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.