Neoview SQL Reference Manual (R2.2)

--- 1 row(s) selected.
SQL>execute findemp using 20000.00, 300;
EMPNUM FIRST_NAME LAST_NAME DEPTNUM JOBCODE SALARY
------ --------------- -------------- ------- ------- --------
75 TIM WALKER 3000 300 32000.00
89 PETER SMITH 3300 300 37000.40
...
--- 13 row(s) selected.
• Use SET PARAM to assign a value to a parameter name and specify both the parameter
name and a literal value in the EXECUTE USING clause:
SQL>prepare findemp from
+>select * from persnl.employee
+>where salary > ? and jobcode = ?;
--- SQL command prepared.
SQL>set param ?Salary 40000.00
SQL>execute findemp using ?Salary, 450;
EMPNUM FIRST_NAME LAST_NAME DEPTNUM JOBCODE SALARY
------ --------------- -------------- ------- ------- --------
232 THOMAS SPINNER 4000 450 45000.00
EXECUTE Statement 103