General Rules - Teradata Vantage - Analytics Database
SQL Stored Procedures and Embedded SQL
- Deployment
- VantageCloud
- VantageCore
- Edition
- VMware
- Enterprise
- IntelliFlex
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 17.20
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2023-10-30
- dita:mapPath
- frc1628111662093.ditamap
- dita:ditavalPath
- qkf1628213546010.ditaval
- dita:id
- rjx1472253414573
- lifecycle
- latest
- 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.