MX Release 3.1 (H06.23+, J06.12+)

SQL> history;

1> show histopt

2> obey /usr/home/scripts/nobey/insert2.sql

3> history;

4> set histopt all

5> set schema cat1.sch;

6> INSERT INTO COURSE1 VALUES

('C11','INTRO TO CS','FOR ROOKIES',3, 100, 'CIS');

7> INSERT INTO COURSE1 VALUES

('C55','COMPUTER ARCH.','VON NEUMANN''S MACH.',3,100,'CIS');

SET IDLETIMEOUT command

The set idletimeout command sets the idle timeout value for the current session. The idle

timeout value of a session determines when the session expires after a period of inactivity. The

default is thirty minutes.

Syntax

SET IDLETIMEOUT value

value

is an integer representing the idle timeout value in minutes. Zero represents an infinite amount

of time, meaning that the session never expires.

Considerations

• You must enter the command in one line.

• If you run this command in a script file, it affects the session in which the script file runs. You

can specify this command in prun script files. However, running this command from a prun

script file does not affect the idle timeout value for the current session.

• To reset the default timeout value, enter this command:

set idletimeout 30

Examples

• The following command sets the idle timeout value to four hours:

SQL>set idletimeout 240

• The following command sets the idle timeout value to an infinite amount of time so that the

session never expires:

SQL>set idletimeout 0

• To reset the idle timeout to the default, enter the following command:

SQL>set idletimeout 30

SQL>

For more information, see “Setting and showing the idletimeout value for the session” (page 35).

SET LIST_COUNT command

The set list_count command sets the maximum number of rows to be returned by SELECT

statements that are run after this command. The default is zero, which means that all rows are

returned.

SET IDLETIMEOUT command 87