Order of the R>
Does the SQLCODE get set to some non-0 value if an ODBC connection cannot be made or is unavailable? Situation: Some of my programs SCONNECT to DB2 and Oracle databases. In some instances the connection is unavailable if only for a short period of time. I would like to test for connection availability. If it's not available I could then PAUSE for 30 seconds or whatever and then loop back and try the connection again. If SQLCODE doesn't get set is there some other way to test for the connection? Thanks and have a phenomenal day! Mike Ramsour Authorized R:BASE Developer AK Steel Coshocton Works Quality Department Phone/VMS: 740-829-4340
