Question

1
Replies
213
Views
Sunny Moses Tharalla (SunnyMosesT)
Virtusa
Consultant
Virtusa
IN
SunnyMosesT Member since 2014 2 posts
Virtusa
Posted: September 27, 2017
Last activity: November 10, 2017
Posted: 27 Sep 2017 3:01 EDT
Last activity: 10 Nov 2017 4:47 EST
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 System Administration Upgrades
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.