Executing SQL from prompt

1. How can I execute SQL files from a server console? Thanks

Aurelio wrote: > > 1. How can I execute SQL files from a server console? > > Thanks dbaccess databasename myscript.sql OR dbaccess databasename - <myscript.sql Art S. Kagel

Your Mileage may vary, but I always use dbaccess <dbname> <sql_file_name> Note: sql_file_name assumes a ".sql" suffix -----Original Message----- From: Aurelio [SMTP:i52sacaa@uco.es] Posted At: Monday, April 26, 1999 7:38 AM Posted To: informix Conversation: Executing SQL from prompt Subject: Executing SQL from prompt 1. How can I execute SQL files from a server console? Thanks

In article <37247BA1.6980@bloomberg.net>, kagel@bloomberg.net wrote: > Aurelio wrote: > > > > 1. How can I execute SQL files from a server console? > > > > Thanks > > dbaccess databasename myscript.sql > > OR > > dbaccess databasename - <myscript.sql > > Art S. Kagel > This is my 0.02 Euro If I have some variables from the shell environment to throw in I always use dbaccess -e databasename <<EOF >the_statements_and_the_results.log \\ 2>the_errors.log-- SQL-text using shell variables like $TABLE for instance: select * from $THIS_TABLE where $THIS_COLUMN = "$COMPARE_STRING" ; all the $variables have to be preset in the shell, of course I often use parameters to the script The '-e' flag for dbaccess makes the sql-text visible in the log file It is useful, when you have errors. You may want to omit that after debugging is done -- Richard Kofler debis Systemhaus EDVg a Daimler Chrysler Enterprise Vienna / Austria -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own