Re: dbaccess syntax

Aaron Savage wrote: > My problem however is that it was my understanding that you could call > dbaccess with arguments to execute a query and have the results returned > to you. > > we are running dbaccess <name_of_database> - SQL_QUERY > > Ive tried to keep the query as simple as possible (suchhe as select * > from tablename) so I know its not an sql or wrongly phrased query. The > problem is that the process doesnt run, it simply places me into the > dbaccess prompt where I have to enter the query again. Hi,I do not really understand your question. If you mean that you have some options to specifiy your sql commands in the command line (e.g. like the program for awk): there is nothing like that. But maybe you can do something like this: dbaccess <<EOF database mydb; select * from .......EOF Regards Helmut Leininger Bull AG