Last activity: 10 Nov 2017 4:47 EST
Semi colon issues in migration from DB2 to UDB database.
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***