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.