Extreme Networks EPICenter 4.1, Руководство по установке программного обеспечения

Страница: 497 / 546

External Access Protocol Structure
EPICenter Software Installation and User Guide 497
Note that the name must match “Al’s Brewery”, which has a ‘ (single quote) character in it. But the
standard SQL statement must quote its string inside a pair of single quote characters. As a result, the
external application must specify the above query using the following select statement:
select * from Store where name = ?
followed by “Al’s Brewery” as a separate parameter to be substituted for the ?.
The EPICenter server responds to the
dbquery
command with either an error message or a table of
results. If an error occurs while processing the query, the server sends back:
<H2>ERROR, error message text </H2>
If it is a table of results, the EPICenter server sends back a table of 2 or more rows. The first row
contains the column name of each column in the resulting table. The second row contains the column
type of each column in the resulting table. Rows 3 to n contains the actual row values in the table. For
example, if the external application sends the following:
<command><param>dbquery</param><param> select * from Employee</ param></command>
The result may be:
<TABLE>
<TR>
<TD>name</TD>
<TD>age</TD>
</TR>
<TR>
<TD>varchar(10)</TD>
<TD>integer</TD>
</TR>
<TR>
<TD>Bob</TD>
<TD>31</TD>
</TR>
<TR>
<TD>Jane</TD>
<TD>27</TD>
</TR>
</TABLE>
When viewed as a table, the returned result looks as follows:
Policy Command
The policy command can be used by an external application to control the policy server. The external
application must be logged in to the EPICenter server with administrator or manager privilege (see
Login command). The policy command has the following syntax:
<command><param>policy</param><param> command </param>[<param>arg1</param>...]</command>
name age
varchar(10) integer
Bob 31
Jane 27