IBM Mainframe Forum Index
Log In
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register

DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884

IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message

New User

Joined: 24 May 2010
Posts: 92
Location: Pune

PostPosted: Sat Feb 18, 2017 2:31 am
Reply with quote

Hello Team,

My Java application is trying to call a Native SQL stored procedure AA400400 which is using a DB2 table.

When calling that stored procedure, we are getting the below error in Java application logs:

10:49:31,261 INFO [stdout] (http-/ DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=PROCEDURE;AA400400 DRIVER=4.14.113

My application connection URL in standalone file:
<connection-url> jdbc:db2://;resultSetHoldability=2;

Application call to stored procedure
Call AA400400(NULL,NULL);

It does not points to correct schema TZZ1 and we can see the stored proc running in different schema i.e. SYSPROC.

We updated the connection URL as:
<connection-url> jdbc:db2://;currentFunctionPath="SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","TZZ1";resultSetHoldability=2;

But it still runs under SYSPROC.

Then we changed the connection URL as below:
<connection-url> jdbc:db2://;currentFunctionPath="TZZ1","SYSFUN","SYSPROC","SYSIBMADM","SYSIBM";resultSetHoldability=2;

But still getting -440.

Please advise.

Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator

Joined: 21 Sep 2010
Posts: 2573
Location: NYC,USA

PostPosted: Sun Feb 19, 2017 7:46 am
Reply with quote

Did you contact DBA at your site first? Did you try executing this sp outside java environment pointing to desired schema?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2


Similar Topics
Topic Forum Replies
No new posts Secondary index error while loading d... IMS DB/DC 2
No new posts Error 0C1 Reason Code 1 with branch i... PL/I & Assembler 3
No new posts Getting error while xped JCL & VSAM 10
No new posts can someone please help me in finding... IBM Tools 9
Search our Forums:

Back to Top