cancel
Showing results for 
Search instead for 
Did you mean: 

Informix

SOLVED
Go to solution
Simon Wickham_7
Occasional Visitor

Informix

Hi,

Can any one advise me how to get to an SQL prompt in Informix. At present the customer is running 9.21.

Regards,
Simon
8 REPLIES
Arunvijai_4
Honored Contributor
Solution

Re: Informix

I hope its called "dbaccess".
http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.dba.doc/dba45.htm

-Arun
"A ship in the harbor is safe, but that is not what ships are built for"
Muthukumar_5
Honored Contributor

Re: Informix

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=838380

hth.
Easy to suggest when don't know about the problem!
Simon Wickham_7
Occasional Visitor

Re: Informix

Thanks
Yogeeraj_1
Honored Contributor

Re: Informix

hi simon,

also have a look at this great link which will help you get started with dbaccess and informix:

http://www.nws.noaa.gov/om/hod/Shows/dbaccess_sql/

hope this helps too!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Simon Wickham_7
Occasional Visitor

Re: Informix

Hi,

Thanks for the help is there anyway as in Oracle to discover what the database name is for the instance after I enter dbaccess - -.

Regards,
Simon
Muthukumar_5
Honored Contributor

Re: Informix

dbaccess -- <<-EOF
show databases;
EOf

Is it working.

hth.
Easy to suggest when don't know about the problem!
Jean-Luc Oudart
Honored Contributor

Re: Informix

Simon,

find the dbaccess manual at :
http://www.cs.rit.edu/~rkr/doc/dbdocs.html

Regards
Jean-Luc
fiat lux
Simon Wickham_7
Occasional Visitor

Re: Informix

Thanks Muthukumar this has resolved the issue.

Thanks all for your help.

Regards,
Simon