Question

2
Replies
427
Views
Khareem_Shaik Member since 2008 6 posts
Virtusa Corp.
Posted: 4 years ago
Last activity: 4 years 8 months ago
Closed
Solved

Stored Procedure is throwing error. however, dynamic SQL works fine.

Facing issue while calling stored procedure from pega. same SP is working fine from IBM data studio and dynamic SQL is working fine too.

Error:

There was a problem getting a list: code: -104 SQLState: 42601 Message: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=EXEC;<ERR_STMT> <WNG_STMT> GET SQL SAVEPOINT HOLD FREE ASSOCIATE, DRIVER=4.18.60


Pega Version: Pega 7.1.7 Version

Database: DB2

Data Integration
Moderation Team has archived post
Share this page LinkedIn