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 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.