Hi,
does anybody know whether it is possible to get the sqlcode / sqlstate that is launched by DB2 when processing a query to get a result set.
Backgorund of the question is that we have implemented a sql extension in arsuperm, which lead to a call of a DB2 user defined function. We want to show the result of the udf in a readable manner. The results are transported by special sqlstates and messages.
Without changes in the frontend we get the error:
At least one search criteria was invalid: com.ibm.mm.beans.CMBInvalidQueryException: DGL2013A: Nicht unterst?tzte Suchkriterien. "". (DK_OD_MSG_NO_MESSAGE) [RC=9(DK_OD_RC_MISC_ERROR),ExtRC=9(DK_OD_MSG_SERVER_FAILED_SEARCH)]
regards
Egon
