[Squirrel-sql-users] DB2 z/OS stored procedure - error when calling using parameters

[Laura M. <lj...@nt...>]

When calling the following DB2 z/OS stored procedure: call ntsdb.db2sp2('DSNDB06');
I receive the following error message:  ExampleExceptionFormatter: exception message was: [jcc][10413][10940][3.71.22] Literal replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text call ntsdb.db2sp2('DSNDB06'). ERRORCODE=-4463, SQLSTATE=42601
Error occurred in:
call ntsdb.db2sp2('DSNDB06')

I am able to successfully call a stored procedure which does not require parameters.
I am also able to successfully execute the call the ntsdb.db2sp2('DSNDB06') using IBM Data Studio.

Thanks for any help you can provide.



I am out of the office on Friday.


[cid:image002.png@01D156AA.2CA49E30]<https://www.northerntrust.com/>
Laura J. Moravek, Vice President, Global Database Platforms (GDP) - DB2/IMS
50 S. LaSalle Street, LQ 11, Chicago , Illinois 60603 USA
312 444-3990 | lj...@nt...<mailto:lj...@nt...>
_______________________________________________________________________________

CONFIDENTIALITY NOTICE:  This communication is confidential, may be privileged and is meant only for the intended recipient.  If you are not the intended recipient, please notify the sender ASAP and delete this message from your system.                      NTAC:3NS-20

P Please consider the environment before printing this email.