Embedded SQL Applications - Teradata Vantage - Analytics Database

Database Introduction

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-09-27
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
Product Category
Teradata Vantageā„¢

Applications written in the programming languages in Supported Languages and Platforms can include embedded SQL.

Because these programming languages do not have facilities for dealing with result sets, embedded SQL extends executable SQL to include declarations.

Embedded SQL declarations include the following:
  • Code to encapsulate the SQL from the application language
  • Cursor definition and manipulation

A cursor is a pointer you use to read a result table one record/row at a time. For more information about cursors, see Cursors.