HP 3000 Manuals HP 3000 Manuals
Sample Program Files
The following table contains a list of sample program files located in
SAMPLEDB.SYS.
All programs except those marked with an asterisk (*) are fully discussed
in the ALLBASE/SQL application programming guides.
Table C-1. Sample Programs in SAMPLEDB.SYS
------------------------------------------------------------------------------------------
| | | | | |
| 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 |
| | | | | |
------------------------------------------------------------------------------------------