SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)

<!-- --- 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 CAT.NVS.CUSTOMER does not exist or is inaccessible.</td>
</tr>
</TABLE>
• The following command formats output as HTML:
SQL>set markup HTML
The following is an example of HTML formatted error message :
SQL>select * from ;
<TABLE?>
<!—select * from ; -->
<tr>
<th>Error Id</th>
<th>Error Code</th>
<th>Error Message</th>
</tr>
<tr>
<td>1</td>
<td>15001</td>
<td>ERROR: A syntax error occurred at or before:</td>
select * from;
^ (14 characters from start of SQL statement) [2011-07-09 18:56:04]</td>
</tr>
</TABLE>
• The following command specifies that results must be displayed in CSV format:
SQL>set markup CSV
SQL>select c.custnum, c.custnum, ordernum, order_date
+>from customer c,orders o where c.custnum=o.custnum;
143,STEVENS SUPPLY ,700510,2003-06-01
3333,NATIONAL UTILITIES,600480,2003-05-12
7777,SLEEPWELL HOTELS ,100250,2003-01-23
324,PREMIER INSURANCE ,500450,2003-04-20
926,METALL-AG. ,200300,2003-02-06
123,BROWN MEDICAL CO ,200490,2003-03-19
123,BROWN MEDICAL CO ,300380,2003-03-19
543,FRESNO STATE BANK ,300350,2003-03-03
5635,ROYAL CHEMICALS ,101220,2003-07-21
21,CENTRAL UNIVERSITY,200320,2003-02-17
1234,DATASPEED ,100210,2003-04-10
3210,BESTFOOD MARKETS ,800660,2003-10-09
• The following command specifies that results must be displayed in XML format:
SQL>set markup xml
SQL>select * from author;
<?xml version="1.0"?>
<Results>
90 RMXCI commands