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:
>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...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:
> 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

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:
>> 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

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

ssameer via DBMonster.com wrote:
> I want to run select sql queries like viewing tablespaces and their size etc
> etc...
> Will I be able to do that with dbaccess.
>

YES! Dbaccess it the query tool that's delivered as part of Informix
Dynamic Server. As for 'tablespaces', assuming you are using the term
in the Oracle sense the Informix equivalent is dbspaces, you can use the
server status tool, onstat, to view dbspaces and the disk chunks that
make them up as well as just about everything else about the operation
of the server itself.

> 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
>

NO! Informix Connect is the runtime library installation that needs to
be on client boxes that have no server installed. The server is the IDS
package.

> 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).
>

You've now posted this question about 10 times in different forums. The
answer is the same: If you are getting a branding error then you are
most likely trying to install the WRONG version of the Informix
product. Probably you have a version for Solaris on Sparc processors
NOT the version for i86. Jonathan and I BOTH posted instructions for
testing that theory to your other posting yesterday.
Art S. Kagel
Oninit

>
> scottishpoet 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
>>
>
>

> You've now posted this question about 10 times in different forums. The
> answer is the same: If you are getting a branding error then you are most
> likely trying to install the WRONG version of the Informix product.
> Probably you have a version for Solaris on Sparc processors NOT the
> version for i86. Jonathan and I BOTH posted instructions for testing that
> theory to your other posting yesterday.

I also asked you over a week ago to tell us the name of the download/install
file you have and offered to check with OS this is for.