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.