Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-2755

debezium-connector-db2: DB2 SQL Error: SQLCODE=-206 on DB2 for z/OS

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Blocker Blocker
    • 1.4.0.Alpha2
    • 1.3.0.Final
    • db2-connector
    • None
    • False
    • False
    • Undefined

      I use db2-connector for DB2 for z/OS.

      I am getting error while creating connection:

      Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=CURRENT_SERVER, DRIVER=4.26.14

       

      Before version 12 function level 504, the DB2 for z/OS does not support CURRENT_SERVER special register, but always support CURRENT SERVER special register (without "_").

      https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/db2z_currentserver.html

       

      DB2 LUW also support CURRENT SERVER.

      https://www.ibm.com/support/producthub/db2/docs/content/SSEPGG_11.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0005882.html

       

      Can you use CURRENT SERVER special register instead of CURRENT_SERVER?

      Thank you!

       

              urbanetz Peter Urbanetz (Inactive)
              konstantin.krasnov Konstantin Krasnov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: