Informix

[Simon Wickham_7]

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

[Arunvijai_4 · Accepted solution]

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

-Arun

[Muthukumar_5]

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

hth.

[Simon Wickham_7]

Thanks

[Yogeeraj_1]

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

[Simon Wickham_7]

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]

dbaccess -- <<-EOF
show databases;
EOf

Is it working.

hth.

[Jean-Luc Oudart]

Simon,

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

Regards
Jean-Luc

[Simon Wickham_7]

Thanks Muthukumar this has resolved the issue.

Thanks all for your help.

Regards,
Simon