15.10 - Multi-Session Programming - 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

This program demonstrates PP2’s facilities for multi-session programming. Specifically, it tests the asynchronous processing of SQL requests useful when multiple DBS sessions are being used.

The syntax for the asynchronous processing PP2 statement types (that is, ASYNC, TEST and WAIT) used in this program is:

ASYNC (<async statement identifier>)

TEST <async statement identifier> COMPLETION

WAIT <async statement list> COMPLETION

WAIT ALL COMPLETION