This information describes how to create server and client applications using SQL to manipulate data.
Stored procedures and embedded SQL support similar functionality, such as cursors and dynamic SQL.
Wherever possible, this document presents functionally similar statements in sections that cover both stored procedures and embedded SQL.
More information about developing applications using embedded SQL is found in Teradata® Preprocessor2 for Embedded SQL Programmer Guide, B035-2446.
- Stored Procedure and Embedded SQL Overview
- SQL Cursors
- SQL Cursor Control and DML Statements
- Result Code Variables
- SQL Stored Procedures
- Condition Handling
- Host Variables and Multiple-Statement Requests
- SQL Control Statements
- Static Embedded SQL Statements
- Dynamic Embedded SQL Statements
- Client-Server Connectivity Statements
- Multisession Asynchronous Programming with Embedded SQL
- SQL Descriptor Area (SQLDA)
- SQL Communications Area (SQLCA)
- SQLSTATE Mappings
- SQL Stored Procedure Command Function Codes
- Performance Considerations