SQL Programming Manual for TAL

Program Compilation and Execution
HP NonStop SQL Programming Manual for TAL—527887-001
5-16
Running the SQL Compiler
Figure 5-3. Sample SQL Compiler Listing (page1of2)
*************************************************************
SQL - Source File = $VOL1.SQLTAL.PROG
ROLLBACK WORK
222
COMMIT WORK
187
*** Statistics: Estimated cost: 1
INSERT INTO =PARTLOC
145
VALUES ( :PARTLOC^REC.LOC^CODE,
146
:PARTLOC^REC.PARTNUM,
147
:PARTLOC^REC.QTY^ON^HAND )
148
*** Statistics: Estimated cost: 2
INSERT INTO =PARTS170
VALUES ( :PARTS^REC.PARTNUM,171
:PARTS^REC.PARTDESC,172
SETSCALE (:PARTS^REC.PRICE, 2),173
:PARTS^REC.QTY^AVAILABLE)174
BEGIN WORK101
*** Statistics: Estimated cost: 1
DECLARE GET_SUPPLIER_CURSOR CURSOR FOR48
SELECT SUPPNUM,49
SUPPNAME,
50
STREET,
51
CITY,
52
STATE,
53
POSTCODE
54
FROM =SUPPLIER
55
WHERE SUPPNUM = :SUPPLIER^OF^PARTS
56
REPEATABLE ACCESS
57
SQL - PROGRAM FILE = \SYS1.$VOL1.SQLTAL.PROGOBJ
SQL - PROGRAM CATALOG = \SYS1.$VOL1.DBI
SQL - DEFAULT CATALOG = \SYS1.$VOL1.DBI
SQL Compiler - T9095C30 - (01NOV91)
COPYRIGHT TANDEM COMPUTERS INCORPORATED 1987, 1988, 1989, 1990, 1991
DATE - TIME : 11/15/91 - 10:08:10
Options : NOFORCE, OBJECT, CURRENTDEFINES, RECOMPILE, RECOMPILEALL, NOEXPLAIN
VST0503.vsd