Re: problem with isql

ISQL 6.0x is a 4.1x product with with the 6.0x connectivity libraries. As a 4.1x product, there are lots of things it doesn't understand which were introduced after the 4.1x Engines. Things like stored procedures, triggers, fragmentation, etc. However, most of the new ESQL/C facilities can be handled by PREPARE, and since ISQL uses PREPARE on each statement it does not recognise (it only recognises LOAD, UNLOAD, OUTPUT, INFO, CHECK TABLE, REPAIR TABLE that I can think of), it actually handles most of these statements. However, it does not know anything about CREATE PROCEDURE FROM "file", and since virtually every stored procedure contains at least one semi-colon before the END PROCEDURE, it does not handle CREATE PROCEDURE procname statements either. The CONNECT, DISCONNECT and SET CONNECTION statements are not preparable -- basically, they tell you how to get to an engine, but prepared statements are handled by an engine -- so ISQL does not handle them at all. DB-Access, by contrast, is a 7.1x product when released with the 7.1x Engines, and it does understand these changes. Consequently, for SQL script interpretation, if you are using fancy statements (those using facilities beyond those in 4.1x), you should also use DB-Access, though 95% or more of the time you will get away with it in ISQL. ISQL should be used for its forms, reports and user menu facilities. Use DB-Access for low-level database adminstration work. In your particular case, you can probably circumvent the problem by using: isql databasename@servername - <<! SELECT * FROM Table;! However, that may not suffice as a general solution for you; use DB-Access. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: agoodloe@osf1.gmu.edu (Alwyn E Goodloe) >Date: 16 Mar 1996 19:40:23 GMT >X-Informix-List-Id: <news.22197> > > We are trying our first experiment with Informix's client server >capability. I have two machines seemingly properly configured. I tried to >run the following sql script: > > CONNECT TO databasename@servername; > select * from table;> >We have 7.10 Online Engine running with SCO V OS and ISQL 6.01 UD4. > >When I execute the script via dbaccess everything works GREAT!!!! >When I execute it with ISQL 6.01 I get Error -930 Cannot Connect to Database >Servername. > > I would have no problem if neither dbaccess or isql worked. I don't >understand why only isql fails. I have gone through the manuals all day >and can't find anything that helps. Are there environment variables required, >other than having INFORMIXSERVER and INFORMIXDIR and termcap, for isql >not required for dbaccess. > > This is really frustrating since what we need to ru is ace reports and forms. > > Anyones help would be greatly appreciated. > >Alwyn E. Goodloe >agoodloe@gmu.edu