IBM Support

Behavior of leading double hyphen while doing an insert into DB2 using the UrbanCode Deploy JDBC-SQL plugin in z OS

Troubleshooting


Problem

You receive errors while executing an INSERT statement from the agent running on z/OS using the UrbanCode Deploy JDBC-SQL plugin step targeting a DB2 database.

Symptom

The UrbanCode Deploy JDBC-SQL plugin throws the error below:

Error Executing SQL Scripts: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;FOR <END-OF-STATEMENT> NOT ATOMIC, DRIVER=3.65.102

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS4GSP","label":"IBM UrbanCode Deploy"},"Component":"JDBC-SQL plugin","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
21 January 2019

UID

ibm10796042