Progress
Embedded SQL-92
Guide and Reference


ESQL-92 Sample Programs

This appendix provides the complete code listings for sample programs that contain or process embedded SQL-92 statements. Table A–1 lists the sample program names and summarizes what element of Embedded SQL-92 programing each source program illustrates.

Table A–1: Sample Programs 
Program Name
Processing Element Illustrated
Static SQL-92 UPDATE (non-SELECT) statement
Static SQL-92 SELECT statement
Dynamic SQL-92 non-SELECT statement
Dynamic SQL-92 SELECT statement

These sample programs are provided with the installation media.

Each sample program is designed to access a copy of the SPORTS2000 sample database. As supplied, the static programs with SQL-92 statements already embedded access the PUB.InventoryTrans table. Descriptions of the steps in each program are in the source code. See "Compile, Link, and Run-time Requirements," for information on requirements for building these sample programs or any Embedded SQL-92 program.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095