Thread: Run SQL Query on Informix database from Unix-Shell
View Single Post
  #2 (permalink)  
Old 06-19-07, 07:36
ceinma ceinma is offline
Registered User
  
Join Date: Apr 2007
Location: Jundiai / SP - Brasil
Posts: 311
You can
- write a esql/c program... but i never do that...
- Use a dbaccess (in a shell program)
some examples:
echo "select * from table_X" | dbaccess myDB ;
dbaccess myDB Myselect.sql ;
dbaccess myDB <<EOF
select * from table_X
EOF

Read the dbaccess manual...
http://www-306.ibm.com/software/data...y/ids_100.html
__________________
________________________________________
César Inacio Martins
Jundiai / SP - Brasil
http://www.imartins.com.br/informix - em Português
http://www.imartins.com.br/informix - English (translated by Google).
________________________________________
Reply With Quote