By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,333 Members | 1,226 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,333 IT Pros & Developers. It's quick & easy.

Error Message Retreival in SQL Stored Procedures

P: 1
We have begun to create SQL stored procedures and are having difficulty creating code to display the contents of the SQLCA following an error. Has anyone developed a good method of doing so? We are using version 7 so the GET DIAGNOSTICS command is not available to us. We tried calling DSNTIAR but we get a -440 sqlcode back. Any tips? Thanks.
Jun 25 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.