Neoview Command Interface (NCI) Guide (R2.5)
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
• This command specifies results be displayed in XML:
SQL>set markup xml
SQL>select * from author
<?xml version="1.0"?>
<Results>
<Query>
<![CDATA[select * from author;]]>
</Query>
<rowid="1">
<AUTHORID>91111</AUTHORID>
<AUTHORNAME>Bjarne Stroustrup</AUTHORNAME>
</row>
<rowid="2">
<AUTHORID>444444</AUTHORID>
<AUTHORNAME>John Steinbeck</AUTHORNAME>
</row>
<rowid="3">
<AUTHORID>2323423</AUTHORID>
<AUTHORNAME>Irwin Shaw</AUTHORNAME>
</row>
<rowid="4">
<AUTHORID>93333</AUTHORID>
<AUTHORNAME>Martin Fowler</AUTHORNAME>
</row>
<rowid="5">
<AUTHORID>92222</AUTHORID>
<AUTHORNAME>Grady Booch</AUTHORNAME>
</row>
<rowid="6">
<AUTHORID>84758345</AUTHORID>
<AUTHORNAME>Judy Blume</AUTHORNAME>
</row>
<rowid="7">
<AUTHORID>89832473</AUTHORID>
<AUTHORNAME>Barbara Kingsolver</AUTHORNAME>
</row>
<Status> <![CDATA[-- 7 row(s) selected .]]></Status>
</Results>
• To set the application to format output as XML:
SQL>set markup XML
XML formatted error message examples:
SQL>set markup <]]>
<?xml version="1.0"?>
<Results>
<Query>
<![CDATA[set markup <]]> ]]>>
</Query>
<ErrorList>
<Error id="1">
<ErrorCode>UNKNOWN ERROR CODE</ErrorCode
<ErrorMessage> <![CDATA[
ERROR: A syntax error occurred at or before:
set markup <]]>>
116 NCI Commands