Distributed SQL

The Distributed SQL test type gives the ability to execute distributed SQL via RTPJ from python. This can be useful when driving SQL activity during a RTPPY automation test is needed.

Test Parameters

The table below lists the required and optional parameters that are valid for this test. Follow the link by clicking on the parameter name in the JSON column. If the parameter has a command line override option it will be listed in the Command Line Override column. Additionally there are examples at the bottom of this page.

Required

JSON	Command Line Override	Special Usage or Note
product_code
test_type
lpar	lpar
userid	userid
ssid	ssid
rtpj_file	rtpj_file

Optional

JSON	Command Line Override	Special Usage or Note
environment	environment
output_location	output_location
rtpj_library	rtpj_library
rtpj_sync	rtpj_sync
rtpj_log_level	rtpj_log_level

JSON Examples

---

Execute distributed SQL via RTPJ from the internal test library

{
  "connection":
  {
    "lpar": "ca31",
    "userid": "qartp03",
    "ssid": "d11a"
  },
  "tests":
  [
    {
      "test_type": "distributed sql",
      "product_code": "PDT",
      "rtpj_file": "Select_Count_Test.JSON",
      "rtpj_library": ""
    }
  ]
}

Execute distributed SQL via RTPJ from a local library.

{
  "connection":
  {
    "lpar": "ca31",
    "userid": "qartp03",
    "ssid": "d11a"
  },
  "tests":
  [
    {
      "test_type": "distributed sql",
      "product_code": "PDT",
      "rtpj_file": "Select_Count_Test.JSON",
      "rtpj_library": "C:\Users\spean03\Desktop\JSON\PDT1497"
    }
  ]
}