ALLBASE/SQL Reference Manual (36216-90216)

664 AppendixC
Sample DBEnvironment
Sample Program Files
Sample Program Files
The following table contains a list of sample program files located in the
/usr/lib/allbase/hpsql/programs directory.
All programs
except those marked with an asterisk (*) are fully discussed in the
ALLBASE/SQL application programming guides.
Table C-1. Sample Programs in /usr/lib/allbase/hpsql/programs
C COBOL FORTRAN Pascal Description
cex2 cobex2 forex2 pasex2 Single-row SELECT into host
variables from PurchDB.Parts
cex5 cobex5 forex5 pasex5 Single-row SELECT into host
variables from PurchDB.Parts with
implicit and explicit error handling,
including recovery from deadlock
cex7 cobex7 forex7 pasex7 Single-row SELECT, INSERT,
UPDATE, and DELETE operations on
the PurchDB.Vendors table
cex8 cobex8 forex8 pasex8 Cursor manipulations on the
PurchDB.OrderItems table
cex8a* cobex8a* forex8a* pasex8a* DATE/TIME data types and join
operations on the TestData and
SupplyBatches tables.
cex9 cobex9 pasex9 BULK operations on the
PurchDB.Orders and
PurchDB.OrderItems tables
cobex10a forex9a Dynamic non-query commands
using EXECUTE IMMEDIATE
cobex10b forex9b Dynamic non-query commands
using PREPARE and EXECUTE
cex10a pasex10a Dynamic query commands with
unknown Format
cex10b pasex10b Dynamic query commands with
known Format
cex12* cobex12* forex12* pasex12* Using long fields in the
PurchDB.Reports table