Finding Information - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide

Product

Teradata Preprocessor2

Release Number

17.00

Published

June 2020

Language

English (United States)

Last Update

2020-06-19

dita:mapPath

whb1544831946911.ditamap

dita:ditavalPath

obe1474387269547.ditaval

dita:id

B035-2446

lifecycle

Product Category

Teradata Tools and Utilities

The following table provides pointers to the Teradata Vantage SQL Reference book set, which provides detailed information on programming with SQL:

Topic	Section	Document
Session management	SQL Data Handling	Teradata Vantage™ - SQL Fundamentals, B035-1141
Return codes
Statement responses
Introduction to Embedded SQL	SQL Data Definition, Control, and Manipulation
Host structures	Embedded SQL	Teradata Vantage™ - SQL Stored Procedures and Embedded SQL , B035-1148
Host variables
Input host variables
Output host variables
SQL character strings as host variables
Multistatement requests with embedded SQL
SQL statements for miscellaneous embedded SQL activities BEGIN DECLARE SECTION COMMENT (returning form) DATABASE DECLARE TABLE DELETE (positioned form) END DECLARE SECTION END-EXEC EXEC EXEC SQL INCLUDE INCLUDE SQLCA INCLUDE SQLDA SELECT … INTO SELECT AND CONSUME…INTO PP2 does not support SELECT AND CONSUME within cursors UPDATE (positioned form) WHENEVER	Static Embedded SQL Statements
Dynamic SQL statement syntax EXECUTE EXECUTE IMMEDIATE PREPARE	Dynamic Embedded SQL Statements
SQL statements for client-server connectivity CONNECT GET CRASH LOGOFF LOGON SET BUFFERSIZE SET CHARSET SET CONNECTION SET CRASH SET ENCRYPTION	Client-Server Connectivity Statements
SQL statements for multisession programming ASYNC TEST WAIT	Multisession Asynchronous Programming with Embedded SQL
SQL statements for cursor declaration and manipulation CLOSE DECLARE CURSOR FETCH FETCH (for scrollable cursor) OPEN POSITION REWIND	SQL Cursor Control and DML Statements
SQLSTATE variable	Result Code Variables
SQLCODE variable
ACTIVITY_COUNT variable
SQL Descriptor Area (SQLDA)	SQL Descriptor Area (SQLDA)
SQL Communications Area (SQLCA)	SQL Communications Area (SQLCA)

Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100 provides information on the LOGDATA and LOGMECH commands.