Filter
Top Products
to use for separating columns in each row of the results. The default delimiter is “ ”(white
space).
Syntax
SET COLSEP [separator]
Considerations
In the Neoview Script interface, you must enter the command on one line. The SET COLSEP
command can be executed only in SQL mode.
The SET COLSEP command has no effect if the markup is set to HTML, XML, or CSV.
Examples
• This SET COLSEP command specifies the separator as a “|”(pipe):
SQL>set colsep |
SQL>show colsep
COLSEP "|"
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 SET HISTOPT 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;
102 Neoview Script Interface Commands