Multi-Session Programming - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

Product
Preprocessor2 for Embedded SQL
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

Multi-Session Programming

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