NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-36
SET PARAM Command
SET PARAM Command
SET PARAM is an SQLCI command that sets values for parameters in your SQLCI
session. SET PARAM overrides parameter values you set prior to entering SQLCI, but
only for the duration of the SQLCI session.
?param
is the name of the parameter to receive a value. An SQL parameter name is an SQL
identifier preceded by a question mark.
literal
is a numeric or string literal, optionally enclosed in single or double quotation
marks. Enclosing quotation marks are required only for string literals that include
blank or comma characters; they make no different otherwise. For example, the
following SET PARAM commands are equivalent:
SET PARAM ?NUM 9001, ?STR string;
SET PARAM ?NUM "9001", ?STR "string";
Within enclosing quotes of the same type, two quotes are treated as a single quote.
For example, the following SET PARAM commands are equivalent:
SET PARAM ?QUOTE " "" ";
SET PARAM ?QUOTE ' " ';
CURRENT_TIMESTAMP
is the Julian timestamp for the current date and time.
COMPUTE_TIMESTAMP (date)
is the Julian timestamp for the date and time you specify in date in the following
form:
{mm/dd/yyyy }
{mm/dd/yyyy hh:nn:ss:mss:uss}
SET [ PARAM ] ?param value [ , ?param value ]... ;
value is:
{ literal }
{ CURRENT_TIMESTAMP }
{ COMPUTE_TIMESTAMP (date) }
yyyy Year, from 1 through 3999, 1 to 4 digits
mm Month, from 1 through 12, 1 to 2 digits
dd Day, from 1 through 31, 1 to 2 digits