Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Stored procedure returning SQLSTATE=56072

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Anney

New User


Joined: 06 Jan 2007
Posts: 7
Location: Chennai

PostPosted: Fri Nov 16, 2007 3:53 pm    Post subject: Stored procedure returning SQLSTATE=56072
Reply with quote

Hi,

Am executing a DB2 Stored procedure from ASP. Getting this error.

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[IBM][CLI Driver][DB2] SQL30005N Execution failed because function not supported by the server: location "" product ID "" reason code "". SQLSTATE=56072

Can any one guide me how to resolve this?

Thanks.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Nov 18, 2007 4:06 am    Post subject:
Reply with quote

Hello,

Do you have anything working from that win-based system to db2 or is this the first attempt?

With no more to go on, it sounds like there is a problem in the data source definition. Once you define the data source, are you able to successfully test the connection?

If you have not already done so, i'd suggest talking with the dba(s) and the network support people from both ends to track down the problem(s).
Back to top
View user's profile Send private message
Anney

New User


Joined: 06 Jan 2007
Posts: 7
Location: Chennai

PostPosted: Fri Nov 23, 2007 9:28 am    Post subject:
Reply with quote

Thanks Dick.

Seems like the stored procedure consumed more CPU service units than the ASUTIME value allows. DB2 might have cancelled the procedure.

ASUTIME was increased to resolve this.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Nov 24, 2007 9:03 am    Post subject:
Reply with quote

You're welcome.

Thank you for posting your solution - it may help another person later icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Handling result sets in the calling N... Rusikesh DB2 7 Fri Apr 13, 2018 12:25 am
No new posts CICS web service from DB2 Triggers or... kiranprasad DB2 2 Wed Dec 20, 2017 11:10 am
This topic is locked: you cannot edit posts or make replies. ISREDIT Macro is not returning back t... nico_neoz CLIST & REXX 21 Sat Nov 18, 2017 7:40 pm
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us