15.10 - About the Examples - 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 examples, called LABs, are a series of nine programs that use a new EMPLOYEE table to load on the database. The examples start with simple syntax statements and progress through more complex operations.

Note: See “EMPLOYEE Table” on page 229 for sample data from the EMPLOYEE table.

 

LAB

Examples in LAB

LAB1

LOGON and LOGOFF statements

LAB2

Static SELECT statement

LAB3

Static SELECT, INSERT, UPDATE and DELETE statements

LAB4

Multiple row return SELECT statement using cursors

LAB5

Multiple statement request using cursors

LAB6

Static EXEC for a macro

This example produces results similar to LAB2, employing a macro.

LAB7

The use of a cursor for a macro.

This example produces the same result as LAB5.

LAB8

The use of dynamic SQL with PREPARE, DESCRIBE, and EXECUTE.

This run is the dynamic equivalent of LAB2.

LAB9

The use of dynamic SQL, especially the EXECUTE IMMEDIATE construct.

This run is the dynamic equivalent of LAB3.