Finding Information - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide - 20.00
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Teradata Preprocessor2
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2023-11-20
dita:mapPath
nyr1691484085721.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
xfi1470440464166
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™ - Analytics Database Security Administration, B035-1100 provides information on the LOGDATA and LOGMECH commands.