467,185 Members | 1,224 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,185 developers. It's quick & easy.

Error Message Retreival in SQL Stored Procedures

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
  • viewed: 872
Share:

Post your reply

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

Similar topics

6 posts views Thread by amitavabardhan | last post: by
9 posts views Thread by dtwilliams@hotmail.com | last post: by
5 posts views Thread by Jurgen Defurne | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.