QPE Sample Response

Below is the JSON object returned from the QPE example listed in the initQPE method description.
This qpeResponse object represents the array of response objects returned from each API call executed in a QPE process.
Within each response object element:
1. The resultset[0]  array element contains the SQL response object returned from the API call.
2. The resultset[1]  array element contains the associated SQL callback definition function return object.

// Array of response objects
[
  // Response object element 1
  {
    "rc": 200,
    "agentVersion": "V2.16.33.5",
    "session": 24,
    "sqlresp": {
      "sql": "SELECT SUM(SALARY) AS TOTAL_SALARY FROM DSN81110.MFCEMP5 WHERE WORKDEPT = 'D11'",
      "resultset": [
        // Resultset element 1 (resultset[0]) - SQL response object returned from the API call.
        {
          "column": [
            {
              "title": "TOTAL_SALARY",
              "type": "DECIMAL",
              "nullable": true,
              "precision": 15,
              "scale": 2
            }
          ],
          "row": [
            {
              "TOTAL_SALARY": 222100
            }
          ]
        },
        // Resultset element 2 (resultset[1]) - SQL callback definition function return object.
        "$222,100.00"
      ],
      "firstrow": 1,
      "lastrow": 1,
      "more": false,
      "sqlcode": 0
    }
  },
  // Response object element 2
  {
    "rc": 200,
    "agentVersion": "V2.16.33.5",
    "session": 24,
    "sqlresp": {
      "sql": "SELECT LASTNAME, WORKDEPT, JOB, SALARY FROM DSN81110.MFCEMP5 WHERE WORKDEPT = 'D11' ORDER BY SALARY DESC FETCH FIRST ROW ONLY",
      "resultset": [
        // Resultset element 1 (resultset[0]) - SQL response object returned from the API call.
        {
          "column": [
            {
              "title": "LASTNAME",
              "type": "VARCHAR",
              "nullable": false,
              "length": 15,
              "ccsid": 1208
            },
            {
              "title": "WORKDEPT",
              "type": "CHAR",
              "nullable": true,
              "length": 3,
              "ccsid": 1208
            },
            {
              "title": "JOB",
              "type": "CHAR",
              "nullable": true,
              "length": 8,
              "ccsid": 1208
            },
            {
              "title": "SALARY",
              "type": "DECIMAL",
              "nullable": true,
              "precision": 9,
              "scale": 2
            }
          ],
          "row": [
            {
              "LASTNAME": "STERN",
              "WORKDEPT": "D11",
              "JOB": "MANAGER",
              "SALARY": 32250
            }
          ]
        },
        // Resultset element 2 (resultset[1]) - SQL callback definition function return object.
        {
          "LASTNAME": "STERN",
          "WORKDEPT": "D11",
          "JOB": "MANAGER",
          "SALARY": "$32,250.00"
        }
      ],
      "firstrow": 1,
      "lastrow": 1,
      "more": false,
      "sqlcode": 0,
      "rowsaffected": 0
    }
  },
  // Response object element 3
  {
    "rc": 200,
    "agentVersion": "V2.16.33.5",
    "session": 24,
    "sqlresp": {
      "sql": "SELECT WORKDEPT, JOB, SALARY FROM DSN81110.MFCEMP5 WHERE JOB = 'MANAGER' ORDER BY SALARY DESC FETCH FIRST ROW ONLY",
      "resultset": [
        // Resultset element 1 (resultset[0]) - SQL response object returned from the API call.
        {
          "column": [
            {
              "title": "WORKDEPT",
              "type": "CHAR",
              "nullable": true,
              "length": 3,
              "ccsid": 1208
            },
            {
              "title": "JOB",
              "type": "CHAR",
              "nullable": true,
              "length": 8,
              "ccsid": 1208
            },
            {
              "title": "SALARY",
              "type": "DECIMAL",
              "nullable": true,
              "precision": 9,
              "scale": 2
            }
          ],
          "row": [
            {
              "WORKDEPT": "B01",
              "JOB": "MANAGER",
              "SALARY": 41520
            }
          ]
        },
        // Resultset element 2 (resultset[1]) - SQL callback definition function return object.
        {
          "WORKDEPT": "B01",
          "JOB": "MANAGER",
          "SALARY": "$41,520.00"
        }
      ],
      "firstrow": 1,
      "lastrow": 1,
      "more": false,
      "sqlcode": 0,
      "rowsaffected": 0
    }
  }
]