SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
E-8
EXECUTE Statement

Unnamed parameter values are substituted for parameters in the SQL
statement by position. The i-th value in the USING clause or in the SQLDA is
the value for the i-th formal parameter.

Any parameter values you specify in the USING clause override values you
previously specified in SET PARAM commands, but only for this execution of
the statement.
param
(used in SQLCI) is the name of a parameter to be assigned the value that
immediately follows. If you specify the same parameter-value pair more than once,
SQL uses the last specification.
To assign values to unnamed parameters, omit ?param= and specify the values in
the same order that the unnamed parameters appear in the prepared command.
value
(used in SQLCI) is a value for a parameter. A value can be one of:

A numeric or string literal, optionally enclosed in quotation marks

CURRENT_TIMESTAMP—an SQLCI function that returns a Julian timestamp
for the current date and time as a value of data type NUMERIC 18 or
LARGEINT.
SQL evaluates CURRENT_TIMESTAMP when the statement in which it
appears executes. As a result, CURRENT_TIMESTAMP in an EXECUTE
statement returns the time that the EXECUTE executes; but
CURRENT_TIMESTAMP in a SET PARAM returns the time that the SET
PARAM executes, not the time that an EXECUTE that uses the parameter
executes.

COMPUTE_TIMESTAMP (date)—an SQLCI function that returns a Julian
timestamp for the date and time you specify in date as a value of data type
NUMERIC 18 or LARGEINT.
For more information about the functions, see CURRENT_TIMESTAMP Function
on page C-174 or COMPUTE_TIMESTAMP Function
on page C-62. For examples
of their use with EXECUTE, see the examples later in this entry.
:variable
(used in programs) is a host variable that contains a value for a parameter in the
statement.
:in-sqlda
(used in programs) is an SQLDA filled by DESCRIBE INPUT that points to values
for parameters in the statement.