Which informix client to use

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.aspx/informix/200712/1

which version i should download and from where ssameer wrote: >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 http://www.dbmonster.com

On Dec 27, 12:39 pm, "ssameer via DBMonster.com" <u40142@uwe> wrote: > 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.comhttp://www.dbmonster.com/Uwe/Forums.aspx/informix/200712/1 What type of scripts are these? 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: >> I am new to informix. >> I have installed IDS (version---IIF_et.10.00---)on my windows machine.I have >[quoted text clipped - 8 lines] >> -- >> Message posted via DBMonster.comhttp://www.dbmonster.com/Uwe/Forums.aspx/informix/200712/1 >What type of scripts are these? > >Are these scripts .sql files? > >If so then "dbaccess" - which would be installed with the server - can >be used to run them -- Message posted via http://www.dbmonster.com

ssameer via DBMonster.com wrote: > Yes these are .sql files and i also need to run some independent informix > commands. > can u please give me the link for download. There is nothing to downlaod . dbaccess is installed along with Informix 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/informix/pubs/library/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/blogs/page/gbowerman?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: > Yes these are .sql files and i also need to run some independent informix > commands. > can u please give me the link for download. 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