Paul Mason wrote:
Are you sure you installed a recent version of Ingres? I've not heard
of dbaccess before and I don't think it's an ingres tool.
Ingres 2006 (int.lnx/103) built from source on Gentoo 2006.
As for your points sql terminal monitor "sql" will do what you want.
It uses ; as an SQL command separator. It's line mode so "no terminal
weirdness" and as of Ingres 2006 there's readline re-entry on Linux by
using the "-history_recall" flag. If you're not on Linux, what I use
all the time is "\e" to take your current input buffer into an editor.
Just make sure that ING_EDIT is set to the path of your editor.
Sorry I should have rechecked (was away from the system with Ingres on
it, and typed from memory... that will teach me!). So lets see if I can
correct myself :-) :
In the version I have 'sql' uses '\go' and does not seem to provide
anything to change this (maybe int.lnx/104 changes to ';'?). With the
-history_recall option and using \e I get a (rather rudimentary I must
say, sorry) command line editing.
With respect to 'dbaccess' - I should have said 'isql' (dunno how that
crept in...).
I think the original points still stand, with minor modifications,
essentially 'sql' is too basic and clunky, and 'isql' too fiddly...
1/ No terminal weirdness (ok sql has this).
2/ Command terminator ';' (preferably configurable) [1].
3/ Convenient (read: open src standand) command line editing via
libedit or readline.
Cheers
Mark
[1] Now Paul says 2/ is already sorted - So I guess he is using
something like int.lnx/104 or 105. I would update if someone would post
the source code for these (103 is *still* the only source posted - hint).
_______________________________________________
Users mailing list
Users@lists.ingres.com
http://lists.ingres.com/mailman/listinfo/users
