Neoview Command Interface (NCI) Guide (R2.5)

SET COLSEP Command
The SET COLSEP command sets the column separator and allows you to control the formatting
of the result displayed for SQL queries. The SET COLSEP command specifies a delimiter value
to use for separating columns in each row of the results. The default delimiter is “ ”(white
space).
Syntax
SET COLSEP [separator]
Considerations
• You must enter the command on one line.
• The SET COLSEP command has no effect if the markup is set to HTML, XML, or CSV.
Examples
• This 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 CONNECTOPT ROLE Command
The SET CONNECTOPT ROLE command changes the role during an NCI session.
Syntax
SET CONNECTOPT ROLE role-name
role-name
is a Neoview role, including the prefix “ROLE.”
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• You can execute this command in any NCI mode.
• After specifying the role by using the SET CONNECTOPT ROLE command, use the
CONNECT command to log on as the role.
NOTE: If you change the role while running NCI within an HPDM session, the new role applies
only to the NCI session. Your role for the HPDM session remains what it was when you launched
NCI.
SET COLSEP Command 109