The EXECUTE statement substitutes parameter values for the parameters in the prepared statement. For more information about EXECUTE, see the Neoview SQL Reference Manual.
Syntax
SET PARAM
If
Considerations
•In the Neoview Script interface, you must enter the command on one line. The command does not require an SQL terminator.
•You can execute this command only in SQL mode.
•Use separate SET PARAM commands to name and assign values to each unique parameter in a prepared SQL statement before running the EXECUTE statement.
•Parameter names are
•The name of a named parameter
Examples
•This command sets a value for the ?sal (salary) parameter:
SQL>set param ?sal 40000.00
•This command sets a character string value, GREEN, for the ?lastname parameter:
SQL>set param ?lastname GREEN
•These commands set values for named parameters in a subsequent SELECT statement:
SQL>set param ?sal 80000.00 SQL>set param ?job 100
SQL>select * from persnl.employee where salary = ?sal
and jobcode = ?job;
EMPNUM | FIRST_NAME | LAST_NAME | DEPTNUM | JOBCODE | SALARY |
72 | GLENN | THOMAS | 3300 | 100 | 80000.00 |
---1 row(s) selected.
SQL>
108 Neoview Script Interface Commands