Re: <No Subject Supplied>

mltsa!jgill@mlgtw.att.com writes: >chaps, >is there a way of knowing whether or not a database exists? In 4GL, you could: WHENEVER ERROR CONTINUE DATABASE dbname IF SQLCA.SQLCODE < 0 THEN # assume it doesn't exist ERROR "dbname does no exist!" END IF WHENEVER ERROR STOP You could also check for the specific error, instead of just < 0. ... and of course, in Colorado, chaps are what cowboys wear over their jeans. ============================================================ Dennis J. Pimple Informix Software Inc Senior Consultant Denver Colorado USA dennisp@informix.com Voice:303-850-0210 Fax:303-779-4025