I am new to informix.
I have installed IDS (version---IIF_et.10.00---)on my windows machine.I have
some informix scripts which i want to run,can anyone please guide me which
client tool to download and install in order to run informix statements..
It will be helpful for me if u can provide the link to download the client
tool.

Regards,
SS

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....ormix/200712/1

which version i should download and from where

ssameer wrote:
--
Message posted via http://www.dbmonster.com

On Dec 27, 12:39*pm, "ssameer via DBMonster.com" <u40142@uwe> wrote:

Are these scripts .sql files?

If so then "dbaccess" - which would be installed with the server - can
be used to run them

Yes these are .sql files and i also need to run some independent informix
commands.
can u please give me the link for download.

scottishpoet wrote:
--
Message posted via http://www.dbmonster.com

ssameer via DBMonster.com wrote:
Dynamic Server.
Just set your environment to include $INFORMIXDIR/bin in the path - this
is where 'dbaccess' resides on the disk.

Then on a command prompt type dbaccess . dbaccess has a menu that allows
you to load existing SQL files and run them.

A users guide to the DB-Access tool can be found at
http://www-306.ibm.com/software/data...y/ids_100.html

What type of other Informix commands to you need to run?

If you need to combine commands like onstat , onspaces, onmode etc with
some SQL skripts you may run these from a shell script.
See http://www.ibm.com/developerworks/bl...n?tag=dbaccess
for a quick overview how you may use dbaccess
(G Bowerman's BLOG )
HTH
Tilman

On Dec 28, 2:57*am, "ssameer via DBMonster.com" <u40142@uwe> wrote:
dbaccess should have been installed when you installed IDS

I think you said you are running on Windows. In that case

Start -> All Programs -> Informix Dynamic Server -> (the name of the
instaance you are running

This will opena command prompt with the Informix environemnt set


cd into the directory that yoru .sql file resides

You then have 2 choices

1/ dbaccess <dbname> <script name.

or 2/ type "dbaccess" to open the menu interface

then its "query language", select the database and "choose" you will
then be given a list of the .sql scripts
alternatively "new" to run "ad hoc" sql commands

alternatively

I want to run select sql queries like viewing tablespaces and their size etc
etc...
Will I be able to do that with dbaccess.

I more query
I am trying to install informix connect on my solaris OS ...Is this informix
connect same as Informix dynamic server.Installation of informix connect is
giving some brand error ...log file says:
(Dec 19, 2007 9:50:26 PM), Install, BrandFiles, err, CUSTOM_BEAN_ERROR_BEGIN
/opt/IBM/informix/etc/install: etc/brand: cannot execute
CUSTOM_BEAN_ERROR_END

Can anyone help me on this.my ultimate aim is to install IDS on Solaris
system()
sun OS 5.10 generic 120012 -14 i86 pc i386 i86 pc(64 bit).


scottishpoet wrote:
--
Message posted via http://www.dbmonster.com