15.10 - Finding Information - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

prodname
Preprocessor2 for Embedded SQL
vrm_release
15.10
category
Programming Reference
featnum
B035-2446-035K

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

 

Table 8: Finding information in the Teradata Database SQL Reference book set 

Topic

Chapter or Appendix

Book

Session management

SQL Data Handling

SQL Fundamentals (B035‑1141)

Return codes

Statement responses

Introduction to Embedded SQL

SQL Data Definition, Control, and Manipulation

Host structures

Embedded SQL

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
  • Note: 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)

    Security Administration (B035‑1100) provides information on the LOGDATA and LOGMECH commands.