Re: dbaccess: the only SQL option?!

you can also run finderr from the command line to give you online help. and do echo =22select * from mytable=22 =7C dbaccess mydb I suppose it comes down to what you are used to but I find awk, sed and = the ksh to be fully adequate at the command line, and also allows me to = dynamically prepare sql. rgds Peter Tashkoff <tashkop=40iname.com> Zespri International Limited Std Disclaimers Apply All rights reserved. No party may use this document to vilify another. Zespri New Zealand Kiwifruit, The World=27s Finest }>> Andreas Zeugswetter <andreas.zeugswetter=40telecom.at> 18/11/97 = 00:16:35 >>> Al Wang wrote: }=20 } Hi, }=20 } I=27ve just recently begun to play around with Informix Universal } Server, and while I am very impressed with the technology under the } hood, I=27m kind of dismayed by the interface, in terms of database } creation: is the only way to enter SQL statements through dbaccess=27s } 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? }=20 } I=27m probably just missing the boat entirely on how to do this stuff } effectively, so I=27d appreciate it if someone could set me straight. }=20 } Thanks, } Al you can use: dbaccess <database> - which gives you a command line. But I agree it is still horrible.