In my code I am accessing a stored procedure which returns a resultset.But it never returns a resultset. It does not throw any error in connection or executing the procedure.
I tried using LC LSX using DB2 connectors and using LS:DO using ODBC connectors but neither returned a resultset.
Any action stored procedure like updating data is executed and produces desired result.
Also if I pass directly an SQL Query it results in the resultset.
Only resultset from stored procedure is not returned. Any help would be greatly appreciated.