title: WITH Clause in spark sql Context not supported
body: <p>I am trying to fetch records from mainframe table using <strong>spark sql context</strong> with the below query </p>
  
  <p>data_config.db2_qry= SELECT A.E_No,A.E_Name FROM Scheema.Employee A  WITH UR</p>
  
  <p>but it is throwing the below error </p>
  
  <blockquote>
    <p>com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-199, SQLSTATE=42601, SQLERRMC=WITH;HAVING WHERE GROUP ORDER INTERSECT MINUS EXCEPT UNION ) , FETCH, DRIVER=4.19.26</p>
  </blockquote>
  
  <p>but if I run the same query in mainframe console directly it works fine.</p>
  
  <p>How to use <strong>WITH</strong> clause in sql context of spark?</p>
  
  <p>I am using spark version 2.4.0</p>
  
  <p>I am retrieving the records like below </p>
  
  <blockquote>
    <p>filt_cond = "(" + data_config.db2_qry + ") ref_id"</p>
    
    <p>db2Df = sqlContext.read.format("jdbc").option("url", data_config.db2_url).option("driver",
                                                                                             "com.ibm.db2.jcc.DB2Driver").option(
                "dbtable", filt_cond).option("user", data_config.db2_uname).option("password",
                                                                                   data_config.db2_passwd).load()</p>
  </blockquote>