Re: Should I use dbaccess or isql ?

joseph v d'silva wrote: > Hi, > > Our DBA has advised us to use isql and not dbaccess. He says that > the later has a chance of corrupting informix file system ( not sure > if that was the term he used ). But our problem is that isql always > returns 0 even for errors, and redirecting the ouput to some log file > and grep ing for all sorts of thing seems to be the only workaround > with isql, but that seems quite a bit unprofessional and dirty coding > to me, and we do a lot of database access from shell scripts, so this > work around is also very tedious and there is every chance of messing > up things, on the other hand dbaccess returns error code which can be > used in shell scripts to write a more legible, easily maintanable code > .... but our DBA says otherwise.. If your DBA has not yet logged a case for this "problem", then do so now. If you have a case / bug number then check the status with Informix tech support, it may already be fixed or a patch may be available. It is unlikely that dbaccess has many problems, and if it develops them, they are likely to be fixed quickly. > can some one tell me the facts on dbaccess vs isql or any other > workarounds ...? dbaccess is supplied with the database server, and is more likely to be kept up to date than isql, which is a separate product. If you are writing code for clients, then you can be pretty sure they will have dbaccess, but they will probably not have isql. You can create links between dbaccess & isql in either direction, but that is usually a temporary fix. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+