HPlogo ALLBASE/SQL Reference Manual > Appendix C Sample DBEnvironment

Sample Program Files

MPE documents

Complete PDF
Table of Contents
Index

E0300 Edition 9 ♥
E0399 Edition 8
E0897 Edition 7

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
cex2cobex2forex2pasex2 Single-row SELECT into host variables from PurchDB.Parts
cex5cobex5forex5pasex5 Single-row SELECT into host variables from PurchDB.Parts with implicit and explicit error handling, including recovery from deadlock
cex7cobex7forex7pasex7 Single-row SELECT, INSERT, UPDATE, and DELETE operations on the PurchDB.Vendors table
cex8cobex8forex8pasex8 Cursor manipulations on the PurchDB.OrderItems table
cex8a*cobex8a*forex8a*pasex8a* DATE/TIME data types and join operations on the TestData and SupplyBatches tables.
cex9cobex9pasex9 BULK operations on the PurchDB.Orders and PurchDB.OrderItems tables
cobex10aforex9a Dynamic non-query commands using EXECUTE IMMEDIATE
cobex10bforex9b Dynamic non-query commands using PREPARE and EXECUTE
cex10apasex10a Dynamic query commands with unknown Format
cex10bpasex10b Dynamic query commands with known Format
cex12*cobex12*forex12*pasex12* Using long fields in the PurchDB.Reports table



RecDB.Members Table

Appendix D Standards Flagging Support