Filter
Top Products
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