Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

PowerBuilder calling a db2 stored procedure results in a sqlstate=38503 SQL1131N error – PB Docs 2022 – PowerBuilder Library

PowerBuilder calling a db2 stored procedure results in a sqlstate=38503 SQL1131N error – PB Docs 2022

  2. Powerbuilder Documentation
  3. Powerbuilder Documentation 2022
  4. PowerBuilder calling a db2 stored procedure results in a sqlstate=38503 SQL1131N error – PB Docs 2022

PowerBuilder calling a db2 stored procedure results in a
sqlstate=38503 SQL1131N error

Symptom

When PowerBuilder is connected to DB2 using ODBC and calling a
stored procedure written in COBOL using RPC, the following DB2 error
message is returned:

Environment

  • PowerBuilder

  • ODBC

  • IBM DB2

Reproducing the Issue

  1. In PowerBuilder, connect to DB2 using ODBC.

  2. Call a stored procedure that is written in COBOL.

  3. The following DB2 error message may be returned:

Cause

DB2 server error

Solution

Add CURRENTFUNCTIONPATH=’XXX’ in the db2cli.ini file where ‘XXX’
is the schema name and

Add PBUSEPROCOWNER=’YES’ in the pbodbcXXX.ini file where XXX is
the PowerBuilder version (for example, pbodbc220.ini).

Document get from Powerbuilder help
Thank you for watching.
Powerbuilder Documentation 2022
PB Docs 2022 Powerbuilder Documentation 2022
August 21, 2023
Was this article helpful?
2
2
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x