Can anybody tell me how to use Informix like DB2 ?

like:

db2 "select * from shema.tab_name"
or
db2 get dbm cfg

Thanks!

Kind Regards,
Marcus

Hi,

Informix is quite different in some things. Instead of db2 we have an interactive tool called dbacces. This tool is character oriented an menu driven. But if you want to include sql's for example in scripts you can use the following two options:

1)

dbaccess mydb <<EOF!
select * from schema.my_tab;
!EOF

2)

Put sql in a file called for example mysql.sql and do:

dbaccess mydb mysql.sql

To answer your second question:
a) onstat -c
b) cat $INFORMIXDIR/etc/$ONCONFIG

Hope this helps,

Rob

Thanks a lot for your help. I'll test it soon.

Regards,
Marcus