Question

1
Replies
194
Views
SunnyMosesT Member since 2014 1 post
Virtusa
Posted: September 27, 2017
Last activity: November 10, 2017
Closed
Solved

Semi colon issues in migration from DB2 to UDB database.

Hello,

I'm working on a cloud migration project. We are running into errors when running Connect-SQL rules with semi colon as the delimiter in the SQL statement. Is there a way to execute the SQL without removing the semi colon from the statement manually.

Error: There was a problem getting a list: code: -104 SQLState: 42601 Message: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;UPPER('%%') with ur;END-OF-STATEMENT, DRIVER=4.19.49

The current environment isDB2 on z/OS to be database is UDB on Linux. Can someone help me figure out this issue or has anyone run into similar issues? Kindly share the solution for the same.

***Edited by Moderator Marissa to update categories***

Data Integration Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn