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