The JSON object format creates one JSON object per row where the column name is the field name and the column value is the field value. The JSON object is the default result format.
The following is an example of a JSON object response to SELECT * FROM DBC.DBCInfo:
{ "queryDuration": 45, "queueDuration": 3, "results": [ { "data": [ { "InfoData": "15.00.00.01", "InfoKey": "VERSION" }, { "InfoData": "Japanese", "InfoKey": "LANGUAGE SUPPORT MODE" }, { "InfoData": "15.00.00.01", "InfoKey": "RELEASE" } ], "resultSet": true, "rowCount": 3, "rowLimitExceeded": false } ] }The following table describes the fields in the JSON object response:
Field | Description |
---|---|
queueDuration | Time the request was queued in milliseconds. |
queryDuration | Time the request ran once submitted in milliseconds. |
results | Array of the result sets, update counts produced by the submitted SQL. The array has more than one element if the submitted SQL contains more than one statement or if a stored procedure was called that returns more than one result set. The following fields may be present inside of a result array element:
|
responseError | The field is only present if an error occurs while the query is in the RESPONDING state. In this case, a successful status is already sent to the client, so responseError is included as the last field in the JSON response. |