Skip to main content
Result value returned when Procedure call is made in DB2API: 
{
  "statusCode": 200,
  "statusDescription": "OK",
  "numRows": 0,
  "data": [ {} ],
  "result": [
    {
      "data": {
        "columnNames": [ "xxx", "yyy" ],
        "numRows": 2,
        "result": [
          { "xxx":"aaa", "yyy":"bbb" },
          { "xxx":"ccc", "yyy":"ddd" }
        ]
      }
    }
  ],
  "elapsedTime": 6,
  "errors": []
}
JOLT Transformation Code
This operation is meaningful only if a single result set is returned.
[
  {
    "operation": "shift",
    "spec": {
      "statusCode":"statusCode",
      "statusDescription":"statusDescription",
      "result": {
        "*": {
          "data": {
            "columnNames":"columnNames",
            "numRows":"numRows",
            "result": "data"
          }
        }
      },
      "elapsedTime":"elapsedTime",
      "errors":"errors"
    }
  }
]
Output Value 
{
  "statusCode" : 200,
  "statusDescription" : "OK",
  "columnNames" : [ "xxx", "yyy" ],
  "numRows" : 2,
  "data" : [
    { "xxx" : "aaa", "yyy" : "bbb" },
    { "xxx" : "ccc", "yyy" : "ddd" }
  ],
  "elapsedTime" : 6,
  "errors" : [ ]
}