Neoview SQL Reference Manual (R2.5)

32000.00
33000.50
40000.00
32000.00
45000.00
--- 5 row(s) selected.
SQL>
• Prepare a SELECT statement with a named parameter (?param-name) and later run
EXECUTE on it:
SQL>prepare findsal from
+>select salary from persnl.employee
+>where jobcode = ?job;
--- SQL command prepared.
SQL>set param ?job 450
SQL>execute findsal;
SALARY
----------
32000.00
33000.50
40000.00
32000.00
45000.00
--- 5 row(s) selected.
SQL>
For more information, see the “EXECUTE Statement” (page 121).
PREPARE Statement 155