END-EXEC Statement Terminator | Teradata Vantage - END-EXEC Statement Terminator - 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ā„¢

Terminates an SQL statement in an embedded SQL client COBOL application program.

ANSI Compliance

END-EXEC is ANSI/ISO SQL:2011-compliant.

Required Privileges

None.

Invocation

Nonexecutable preprocessor declaration.

Embedded SQL only.

Syntax

END-EXEC [.]

Usage Notes

  • END-EXEC is mandatory for all SQL statements embedded in a client COBOL application program.

    The statement terminator for SQL embedded within C and PL/I applications is the SEMICOLON character.

  • You cannot use END-EXEC with interactive SQL statements.

Related Information