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

SQL>
• This command resets the number of displayed rows to all rows:
SQL>set list_count 0
SQL>select empnum, first_name, last_name
+>from persnl.employee
+>order by empnum;
EMPNUM FIRST_NAME LAST_NAME
------ --------------- --------------------
1 ROGER GREEN
23 JERRY HOWARD
29 JANE RAYMOND
32 THOMAS RUDLOFF
39 KLAUS SAFFERT
43 PAUL WINTER
65 RACHEL MCKAY
...
995 Walt Farley
--- 62 row(s) selected.
SQL>
SET MARKUP Command
The SET MARKUP command sets the markup format and controls how results are displayed by
NCI.
Syntax
SET MARKUP [RAW|HTML|XML|CSV|COLSEP]
The supported options enable results to be displayed in XML, HTML, CSV (Comma Separated
Values), and COLSEP format. The default format is RAW.
Considerations
• You must enter the command on one line.
• If the MARKUP format is CSV or COLSEP, the column header information and status
messages are not displayed.
• For the XML and HTML markup format, the syntax and interface errors have been
reformatted so that consistent XML and HTML markup is displayed. In previous releases,
the structure of the XML and HTML error depended on whether the error was generated
by the application or an SQL error that was received from the database. Also, specific
characters are also escaped when the markup is set to XML or HTML. For XML markup,
any occurrence of “]]>” that appear in the error message or invalid query are replaced with
“]]>”. When error messages are output as HTML markup, both the “>” (greater than) and
“<” (less than) symbols are replaced with their escaped versions: “>” and <”, respectively.
An example of the formatted error messages are show below.
Examples
• This command specifies results be displayed in HTML:
SQL>set markup html
SQL>select c.custnum, c.custnum, ordernum, order_date
+>from customer c, orders o where c.custnum=o.custnum;
SET MARKUP Command 121