Re: dbaccess: the only SQL option?!

Al Wang wrote: > > Hi, > > I've just recently begun to play around with Informix Universal > Server, and while I am very impressed with the technology under the > hood, I'm kind of dismayed by the interface, in terms of database > creation: is the only way to enter SQL statements through dbaccess's > menu system? This seems horribly inefficient. Is there no sort of > command-line SQL parser like for Oracle? Are there no online help > features? Can the SQL error messages be any less helpful? You can use the query option to compose and execute a DDL script also, or just use the command line: dbaccess mydatabase <QUERY><CHOOSE>mytable_ddl<RUN> (to execute the script: mytable_ddl.sql) or dbaccess mydatabase mytable_ddl (this will stop on errors) or dbaccess mydatabase - <mytable_ddl.sql (this will continue past errors) Add a '-e' option before the database name to echo inputs to the output stream. In dbaccess <Query-language> you can use the built in editor or choose the <Use-editor> option to create/modify your scripts in your favorite editor (uses the DBEDITOR or EDITOR environment variables to specify). Art S. Kagel