Re: dbaccess vs isql

>From: Adam Sorati <adams@sgen.com.au> >Date: Mon, 03 Mar 1997 09:33:32 +1000 >X-Informix-List-Id: <news.34692> > >SE 7.2 >SQL 6 > >Does anyone know why the 'connect to' command can be used in >dbaccess and not isql. Because ISQL only barely understands SQL, and doesn't recognise that CONNECT, DISCONNECT and SET CONNECTION are not preparable statements. >Or on a more general note what are the differences between the two, ISQL doesn't understand CREATE PROCEDURE statements (in any form which involves more than one semi-colon or the CREATE PROCEDURE FROM form). ISQL's Schema Editor doesn't understand the more complex create table options which DB-Access does. You can create any table via the Query-Language option in either ISQL or DB-Access, and in my view, you should seldom if ever use the Schema Editor, because you normally need to be able to reproduce the table creation script, and the Schema Editor doesn't preserve it for you. ISQL handles forms -- DB-Access doesn't. ISQL handles reports -- DB-Access doesn't. ISQL handles user menus -- DB-Access doesn't. These are deliberate design decisions by those who created DB-Access. You can find the differences by comparing the ISQL and DB-Access manuals. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>