The data retrieval response document has a format similar to the data load response document—as explained in Load Request Document Format—but it is easier to parse. The general format of a retrieval response document looks as follows:
<rowsets>tag: This is the root element of a retrieval response document. Its children are:<rowset>tag: One<rowset>tag for each<free-query>tag sent in the request<error>tag
<rowset>tag: Each<rowset>tag gets the same ID as the<free-query>tag in the retrieval request document to indicate to which query this rowset replies.<error>tag: This tag contains a complete description of the error. It is a required tag indicating whether a problem has occurred on rowset level. Errors on rowset level mostly point out problems in the RDBMS.
<rowsets> tag
Root element of a retrieval response document.
The <rowsets-tag> tag can have the following children, which are described in the following sections:
<rowset><error>
<rowset> Tag
Holds the information for a specific rowset.
Each <rowset> tag gets the same ID as the <free-query> tag in the retrieval request document to indicate to which query this rowset replies.
| Attribute | Definition |
|---|---|
id | Required. Holds the same ID value as the <free-query> tag in the retrieval request document to help identify to which query this rowset replies. |
The <rowset> tag can have the following children, which are described in the following sections:
<row><rowset-info>- <error>
<row> Tag
Holds the value for a specific row.