Re: SQL from the command line

In article <3idm0i$12h@crchh327.bnr.ca> Andy Cordell <andy@bnr.ca> writes: >What is the proper way to provide a SQL command line interface to >a user without making them create a sql command file to issue a >command? What I'd like is the ability to type something like >this on the unix command line: > ><dbname> <SQL command here> >The response would come back to stdout. You mean besides the "-" argument? dbaccess <dbname|-> - e.g. dbaccess stores - or dbaccess - - (must begin with DATABASE|START DATABASE|CREATE DATABASE) Terminate each statement with a semicolon to execute it (statements can be entered free form and span lines); get out with ^D. If that's not what you're after, please start with what this doesn't do that you were looking for... >Andy Cordell >andy@bnr.ca -- Alan Denney aland@informix.com Disclaimer: Sender under influence of 1,3,7-trimethylxanthine Martha Raye, the animal-loving entertainer who died in October at the age of 78, left money to the fervently anti-fur group People for the Ethical Treatment of Animals, and she also left seventh husband Mark Harris $1.5 Million. Now, the flamboyant Harris is becoming a fashion designer: he's going to design and market his own line of furs.