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

SET HISTOPT command

The set histopt command sets the history option and controls how commands are added to

the history buffer. By default, commands within a script file are not added to history. If the history

option is set to ALL, all the commands in the script file are added to the history buffer. If no options

are specified, DEFAULT is used.

Syntax

SET HISTOPT [ALL|DEFAULT]

Considerations

You must enter the command in one line.

Examples

The following command shows only the obey command added to the history buffer.

SQL> show histopt

HISTOPT DEFAULT [No expansion of script files]

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

SQL> ?section insert

SQL> set schema cat1.sch;

--- SQL operation complete.

SQL> INSERT INTO COURSE1 VALUES

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

--- 1 row(s) inserted.

SQL> INSERT INTO COURSE1 VALUES

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

--- 1 row(s) inserted.

SQL> history;

1> show histopt

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

The following command shows all the commands added to the history buffer.

SQL> set histopt all

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

?section insert

SQL> set schema cat1.sch;

--- SQL operation complete.

SQL> INSERT INTO COURSE1 VALUES

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

---1 row(s) inserted.

SQL> INSERT INTO COURSE1 VALUES

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

---1 row(s) inserted.

86 RMXCI commands