Results 1 to 3 of 3

Thread: Informix use

  1. #1
    Join Date
    Jun 2004
    Posts
    21

    Unanswered: Informix use

    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

  2. #2
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    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

  3. #3
    Join Date
    Jun 2004
    Posts
    21
    Thanks a lot for your help. I'll test it soon.

    Regards,
    Marcus

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •