Question
EvonSys
IN
Last activity: 10 Nov 2017 4:47 EST
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***
Accepted Solution
Pegasystems Inc.
US
Hi Sunny,
Since the issue is with the semicolon we can do a data fix, however that is not the suggested approach.
So, to do this data fix we can write the Activity where we can use the Obj-Browse method to retrieve the list of rows which has pxObjClass - Rule-Connect-SQL. The result of this will be stored in the Clipboard Page.
Then we have to run a for loop on this retrieved list. So, in each embedded page the query resides in the variable pySaveSQL. Thus, using expression builder we can do a substring of this like
@substring(.pySaveSQL,0,length(.pySaveSQL)-1).
After the modification is done for this variable we can again save the object to the database using Obj-Save.
Please take the full backup of the database before doing this.