Re: Difference Between dbaccess & isql
This is a multi-part message in MIME format.
------=_NextPart_000_0033_01C3CDF0.19D7E410
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Blankdbaccess should be fully compatible with isql with the exceptions =
that it does not support isql froms, reports, and user menus. You =
should be able to modify scripts and replace isql by dbaccess. The =
reason for the two utilities is that originally the isql utility was a =
comprehensive system which could be used to develop simple database =
applications. dbaccess was introduced when the engine product was =
separated from the application products and is supplied with the =
database engine so that databases can be created, maintained, etc =
without needing to buy additional products.
If you have purchased the isql it is installed in much the same way as =
the engine is installed. i.e. you copy the files from the media to the =
hard disk and run an install script. But if you haven't bought isql you =
might be able to use a previous release of isql. Anyhting above version =
7 should be compatible with 9.3 . The problem is how to set the =
environment variables accordingly. I find it best to install the engine =
products in one directory and start them with INFORMIXDIR, ONCONFIG, and =
INFORMIXSERVER set to the appropriate values. To then use isql you only =
need to set INFORMIXDIR to the location of the isql installation, set =
INFORMIXSERVER to the same thing, and set INFORMIXSQLHOSTS to the =
etc/sqlhosts file for the database engine installation.
Hope this helps
Malcolm
----- Original Message -----=20
From: Vijay=20
To: informix-list@iiug.org=20
Sent: Monday, December 29, 2003 7:37 AM
Subject: Difference Between dbaccess & isql
Hi All,
We are working on Informix 9.3... Our current installation =
doesnot have isql utility... But our shell scripts have isql utility =
written in them... We have dbaccess installed... So can we modify our =
scripts which has isql with dbaccess & run them successfully???=20
Also let us know how do we install isql utility... Will that come =
along with the Informix Installation or is it a patch which need to be =
installed explicitly??? Thanks in advance
Regards,
Vijay Kumar.R
Software Engg.
------=_NextPart_000_0033_01C3CDF0.19D7E410
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE id=3DridTitle>Blank</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<STYLE>BODY {
MARGIN-TOP: 25px; FONT-SIZE: 10pt; MARGIN-LEFT: 25px; COLOR: #000000; =
FONT-FAMILY: Arial, Helvetica; BACKGROUND-COLOR: #ffffff
}
P.msoNormal {
MARGIN-TOP: 0px; FONT-SIZE: 10pt; MARGIN-LEFT: 0px; COLOR: #ffffcc; =
FONT-FAMILY: Helvetica, "Times New Roman"
}
LI.msoNormal {
MARGIN-TOP: 0px; FONT-SIZE: 10pt; MARGIN-LEFT: 0px; COLOR: #ffffcc; =
FONT-FAMILY: Helvetica, "Times New Roman"
}
</STYLE>
<META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR></HEAD>
<BODY id=3DridBody style=3D"BACKGROUND-COLOR: #ffffff" bgColor=3D#ffffff =
background=3D"">
<DIV>dbaccess should be fully compatible with isql with the exceptions =
that it=20
does not support isql froms, reports, and user menus. You should =
be able=20
to modify scripts and replace isql by dbaccess. The reason for the =
two=20
utilities is that originally the isql utility was a comprehensive system =
which=20
could be used to develop simple database applications. dbaccess =
was=20
introduced when the engine product was separated from the application =
products=20
and is supplied with the database engine so that databases can be =
created,=20
maintained, etc without needing to buy additional products.</DIV>
<DIV>If you have purchased the isql it is installed in much the same way =
as the=20
engine is installed. i.e. you copy the files from the media to the =
hard=20
disk and run an install script. But if you haven't bought isql you =
might=20
be able to use a previous release of isql. Anyhting above version =
7 should=20
be compatible with 9.3 . The problem is how to set the environment =
variables accordingly. I find it best to install the engine =
products in=20
one directory and start them with INFORMIXDIR, ONCONFIG, and =
INFORMIXSERVER set=20
to the appropriate values. To then use isql you only need to set=20
INFORMIXDIR to the location of the isql installation, set INFORMIXSERVER =
to the=20
same thing, and set INFORMIXSQLHOSTS to the etc/sqlhosts file for the =
database=20
engine installation.</DIV>
<DIV> </DIV>
<DIV>Hope this helps</DIV>
<DIV> </DIV>
<DIV>Malcolm</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A title=3Drudrappa@india.hp.com =
href=3D"mailto:rudrappa@india.hp.com">Vijay</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3Dinformix-list@iiug.org=20
href=3D"mailto:informix-list@iiug.org">informix-list@iiug.org</A> =
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Monday, December 29, 2003 =
7:37=20
AM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Difference Between =
dbaccess=20
& isql</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=3D015233407-29122003>Hi All,</SPAN></DIV>
<DIV><SPAN class=3D015233407-29122003></SPAN> </DIV>
<DIV><SPAN=20
=
class=3D015233407-29122003> We =
are=20
working on Informix 9.3... Our current installation doesnot have isql=20
utility... But our shell scripts have isql utility written in them... =
We have=20
dbaccess installed... So can we modify our scripts which has isql with =
dbaccess & run them successfully??? </SPAN></DIV>
<DIV><SPAN class=3D015233407-29122003> Also let us =
know how do=20
we install isql utility... Will that come along with the Informix =
Installation=20
or is it a patch which need to be installed explicitly??? Thanks in=20
advance</SPAN></DIV>
<DIV><SPAN class=3D015233407-29122003></SPAN> </DIV>
<DIV><SPAN class=3D015233407-29122003></SPAN> </DIV>
<DIV><FONT face=3D"Comic Sans MS" =
color=3D#808000>Regards,</FONT></DIV>
<DIV><FONT face=3D"Comic Sans MS" color=3D#808000>Vijay =
Kumar.R</FONT></DIV>
<DIV><FONT face=3D"Comic Sans MS" color=3D#808000>Software =
Engg.</FONT></DIV>
<DIV>
<DIV><FONT face=3D"Comic Sans MS"=20
color=3D#808000></FONT></DIV></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0033_01C3CDF0.19D7E410