Neoview Command Interface (NCI) Guide (R2.4)
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;
<TABLE>
<!--select c.custnum, c.custname,ordernum,order_date
from customer c, orders o where c.custnum=o.custnum;-->
<tr>
<th>CUSTNUM</th>
<th>CUSTNAME</th>
<th>ORDERNUM</th>
<th>ORDER_DATE</th>
</tr>
<tr>
<td>143</td>
<td>STEVENS SUPPLY</td>
<td>700510</td>
<td>2003-06-01</td>
</tr>
<tr>
<td>3333</td>
<td>NATIONAL UTILITIES</td>
<td>600480</td>
<td>2003-05-12</td>
</tr>
<tr>
<td>7777</td>
<td>SLEEP WELL HOTELS</td>
<td>100250</td>
<td>2003-01-23</td>
</tr>
<!-- --- 3 row(s) selected.-->
</TABLE>
SQL>select c.custnum, c.custname,ordernum,order_date,
+>from customer c, orders o where c.custnum=o.custnum;
<TABLE>
<!-- select c.custnum, c.custname,ordernum,order_date,
from customer c, orders o where c.custnum=o.custnum;-->
SET MARKUP Command 123