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.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

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

Invocation

Nonexecutable preprocessor declaration.

Embedded SQL only.

Syntax

BEGIN DECLARE SECTION

ANSI Compliance

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

Authorization

None.

Usage

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 Topics

For more information about BEGIN DECLARE SECTION and the END DECLARE SECTION statements, see END DECLARE SECTION.