BEGIN DECLARE SECTION | Teradata Vantage - BEGIN DECLARE SECTION - 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ā„¢

Identifies the start of an embedded SQL declare section for an application written in C.

ANSI Compliance

BEGIN DECLARE SECTION is ANSI/ISO SQL:2011-compliant.

Required Privileges

None.

Invocation

Nonexecutable preprocessor declaration.

Embedded SQL only.

Syntax

BEGIN DECLARE SECTION

Usage Notes

The BEGIN DECLARE SECTION and the END DECLARE SECTION statements are mandatory for applications written in C.

Preprocessor2 issues a warning if it finds either statement in a COBOL or PL/I application.

All host variables must be defined within the declare section.

You must specify the complete BEGIN DECLARE SECTION statement, including the SQL prefix and terminator, on a single line. Only a pad character can separate the words of the statement.

Related Information

END DECLARE SECTION.