Manualshelf

SQL Programming Manual for TAL

ManualsBrandsHP ManualsServerHP NonStop G-Series
261262263264265266267268269270
Examples of Dynamic NonStop SQL Programs
HP NonStop SQL Programming Manual for TAL—527887-001
C-11
Detailed Dynamic SQL Program
Figure C-2. Output for the Detailed Dynamic SQL Program
200320
21
ORDERS.ORDERNUM
ORDERS.CUSTNUM
300350
543
ORDERS.ORDERNUM
ORDERS.CUSTNUM
800660
3210
ORDERS.ORDERNUM
ORDERS.CUSTNUM
ORDERS.ORDERNUM
ORDERS.CUSTNUM
400410
7654
End of current session
11>
- - - 4 row(s) selected.
Enter SQL statement or SAME to reuse last statement or END:
>>end;
10> RUN TALDYNO
This is DYNAMIC SQL test.
Enter SQL statement or SAME to reuse last statement or END:
>>select ordernum, custnum
from =orders where ordernum in
(select ordernum from =odetail where partnum = 6400);
VSTC02.vsd