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.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
xqq1557098602407.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1148
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

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

Invocation

Nonexecutable preprocessor declaration.

Embedded SQL only.

Syntax

END-EXEC [.]

ANSI Compliance

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

Authorization

None.

Rules for Using END-EXEC

  • 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 Topics

For more information about END-EXEC, see EXEC SQL Statement Prefix.