General Rules - Advanced SQL Engine - Teradata Database
SQL Stored Procedures and Embedded SQL
- Product
- Advanced SQL Engine
- Teradata Database
- Release Number
- 17.10
- Published
- July 2021
- Language
- English (United States)
- Last Update
- 2021-07-28
- dita:mapPath
- vqj1592443206677.ditamap
- dita:ditavalPath
- vqj1592443206677.ditaval
- dita:id
- B035-1148
- lifecycle
- previous
- Product Category
- Teradata Vantage™
- Use of the CONNECT statement is optional. If the application program executes any SQL statement which requires access to Vantage and the program is not currently connected to Vantage, an implicit connection is attempted.
- If the application program executes a CONNECT statement while already connected to Vantage, the previous connection is dropped.
- Both user_id-variable and password_variable must be host variables defined as fixed length character strings of eight characters. (If the user ID or password is less than eight characters long, use pad characters to extend the user ID or password to eight characters).
- CONNECT cannot be executed as a dynamic statement.
- The application program is connected to Vantage using the specified user ID and password.