HP NEOVIEW 544530-001 manual SET Param Command, Examples

Examples

•This SET LIST_COUNT command specifies that the number of rows to be displayed by SELECT statements is five:

SQL>set list_count 5

SQL>select empnum, first_name, last_name from persnl.employee

order by empnum;

EMPNUM	FIRST_NAME	LAST_NAME
------	---------------	--------------------
1	ROGER	GREEN
23	JERRY	HOWARD
29	JANE	RAYMOND
32	THOMAS	RUDLOFF
39	KLAUS	SAFFERT

--- 5 row(s) selected. LIST_COUNT was reached.

SQL>

•This SET LIST_COUNT command resets the number of displayed rows to all rows:

SQL>set list_count 0

SQL>select empnum, first_name, last_name +>from persnl.employee

+>order by empnum;

EMPNUM	FIRST_NAME	LAST_NAME
------	---------------	--------------------
1	ROGER	GREEN
23	JERRY	HOWARD
29	JANE	RAYMOND
32	THOMAS	RUDLOFF
39	KLAUS	SAFFERT
43	PAUL	WINTER
65	RACHEL	MCKAY
...
995	Walt	Farley

---62 row(s) selected.

SQL>

SET PARAM Command

The SET PARAM command associates a parameter name with a parameter value in the current session. The parameter name and value are associated with one of these parameter types:

•Named parameter (represented by ?param-name) in a DML statement or in a prepared SQL statement

•Unnamed parameter (represented by ?) in a prepared SQL statement only

A prepared statement is one that you SQL compile by using the PREPARE statement. For more information about PREPARE, see the Neoview SQL Reference Manual.

After running SET PARAM commands in the session:

•You can specify named parameters (?param-name) in a DML statement.

•You can execute a prepared statement with named parameters by using the EXECUTE statement without a USING clause.

•You can execute a prepared statement with unnamed parameters by using the EXECUTE statement with a USING clause that contains literal values and/or a list of the named parameters set by SET PARAM.

SET PARAM Command 107