15.10 - STARTUP - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
English (United States)
Last Update

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 SQL Data Definition Language Detailed Topics for more information about this.
The startup string is performed either when you log on to Teradata Database 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 Teradata Database returns it to them.