Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts Is possible to call subprogram from c... cmsmoon COBOL Programming 3 Fri Aug 05, 2016 6:46 pm
This topic is locked: you cannot edit posts or make replies. Stored procedure on Federated thru DB2 arif677 DB2 6 Tue May 31, 2016 11:48 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us