SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-35
Example—SET LAYOUT
You cannot specify the same option more than once in a single SET LAYOUT
command.
For more information about a specific option, see the entry for that option.
Example—SET LAYOUT
This example sets the left margin for reports at byte position eight and also sets double
spacing:
>> SET LAYOUT LEFT_MARGIN 8, LINE_SPACING 2;
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 before 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 difference otherwise. For example, this
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 handled as a single
quote. For example, this SET PARAM commands are equivalent:
SET PARAM ?QUOTE " "" ";
SET PARAM ?QUOTE ' " ';
CURRENT_TIMESTAMP
is the Julian timestamp for the current date and time.
SET [ PARAM ] ?param value [ , ?param value ]... ;
value is:
{ literal }
{ CURRENT_TIMESTAMP }
{ COMPUTE_TIMESTAMP (date) }