Neoview Script Guide (R2.2)

SQL>select * from employee;
EMPNUM|EMPNAME |REGNUM|BRANCHNUM|JOB
------|--------------|------|---------|--------
1|ROGER GREEN | 99| 1|MANAGER
23|JERRY HOWARD | 2| 1|MANAGER
29|JACK RAYMOND | 1| 1|MANAGER
32|THOMAS RUDLOFF| 5| 3|MANAGER
39|KLAUS SAFFERT | 5| 2|MANAGER
--- 5 row(s) selected.
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
In the Neoview Script interface, you must enter the command on one line.
Examples
This command shows only the obey commands added to the history buffer.
SQL> show histopt
HISTOPT DEFAULT [No expansion of script files]
SQL> obey e:\scripts\nobey\insert2.sql
SQL> ?section insert
SQL> set schema neo.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 e:\scripts\nobey\insert2.sql
This command shows all the commands added to the history buffer.
SQL> set histopt all
SQL> obey e:\scripts\nobey\insert2.sql
?section insert
108 Neoview Script Interface Commands