Neoview Script Guide (R2.2)

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
Neoview Script.
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
In the Neoview Script interface, 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.
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>
SET MARKUP Command 111