-740 Connection not open - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 (SPP Prefix) Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Preprocessor2 for Embedded SQL
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2020
Language
English (United States)
Last Update
2023-11-20
lifecycle
Latest
Product Category
Teradata Tools and Utilities

-740 Connection not open

Possible Cause

  1. On workstation platforms, no current connection has been established before issuing an executable SQL request. For example, no successful connection was established via the LOGON or CONNECT or SET CONNECTION statements. On IBM mainframe platforms, a different CLI/DBS error is returned if an implicit logon fails.
  2. The connection name in a SET CONNECTION or LOGOFF statement does not exist.

Possible Solution

Ensure a session has been established and is currently active before issuing a request.