SQL Programming Manual for TAL

Introduction
HP NonStop SQL Programming Manual for TAL—527887-001
1-4
Using Static SQL Statements
that you can include in your program. This example shows a call to the
SQLCADISPLAY procedure using all default parameters.
?SOURCE $SYSTEM.SYSTEM.EXTDECS (SQLCADISPLAY)
...
CALL SQLCADISPLAY (SQLCA);
! Process errors or statistics from the SQLCA structure
...
For more information, see Section 4, System Procedures.
Using Static SQL Statements
You can embed static SQL statements in both TAL data declarations and TAL
executable statements. Figure 1-1 on page 1-5 shows an example of static SQL
statements embedded in a TAL program. In this example, the program inserts a row in
the PARTS table, which has the columns PARTNUM, PRICE, and PARTDESC. This
example also declares data items as host variables so that they can contain input
values for the columns of the row.