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;

 

EMPNUMEMPNAME

REGNUMBRANCHNUMJOB

--------------------

------

-----------------

1ROGER

GREEN

99

1MANAGER

23JERRY

HOWARD

2

1MANAGER

29JACK RAYMOND

1

1MANAGER

32THOMAS RUDLOFF

5

3MANAGER

39KLAUS

SAFFERT

5

2MANAGER

--- 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 [ALLDEFAULT]

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