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

<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;-->
<tr>
<th>Error Id</th>
<th>Error Code</th>
<th>Error Message</th>
<tr>
<td>1</td>
<td>4082</td>
<td>Object NEO.NVS.CUSTOMER does not exist or is inaccessible.</td>
</tr>
</TABLE>
• To set the application to format output as HTML:
SQL>set markup HTML
HTML formatted error message example:
SQL>set markup <invalid>
<?xml version="1.0"?>
<Results>
<Query>
<![CDATA[set markup <invalid ]]>
</Query>
<ErrorList>
<Error id="1">
<ErrorCode>NVCI001</ErrorCode
<ErrorMsg> <![CDATA[
ERROR: A syntax error occurred at or before:set markup <invalid>
122 NCI Commands