|
From: Laura M. <lj...@nt...> - 2018-04-03 14:44:51
|
I changed the log4j.rootlogger to debug and see the following in the log: [cid:image002.png@01D3CB30.5B382030] 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. From: Laura Moravek Sent: Tuesday, April 03, 2018 9:25 AM To: 'squ...@li...' Subject: DB2 z/OS stored procedure - error when calling using parameters 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. |
