SEO

Hi there,

Can anyone recommend a tutorial for using dbaccess in menu mode?

When prompted to hit return, e.g. "Select a server with the Arrow
Keys, or enter a name, then press Return." I can move the cursor to
highlight the database but hitting return causes the cursor to move
forward to the next db. Manually entering the name and hitting return
will work though.

I am running it from a console in Ubuntu Linux.

Apologies if this has been asked before, but I couldn't find it by
searching the group.

Kind Regards

Andrew

On Dec 27, 6:24 am, Andrew2006 <mymate...@googlemail.com> wrote:
> Hi there,
>
> Can anyone recommend a tutorial for using dbaccess in menu mode?

How about the Dbaccess Manual which is part of the IDS documentation
set online.

Art S. Kagel
Oninit

> When prompted to hit return, e.g. "Select a server with the Arrow
> Keys, or enter a name, then press Return." I can move the cursor to
> highlight the database but hitting return causes the cursor to move
> forward to the next db. Manually entering the name and hitting return
> will work though.
>
> I am running it from a console in Ubuntu Linux.
>
> Apologies if this has been asked before, but I couldn't find it by
> searching the group.
>
> Kind Regards
>
> Andrew

On Dec 27, 11:52 am, "Art S. Kagel" <art.ka...@gmail.com> wrote:
> On Dec 27, 6:24 am, Andrew2006 <mymate...@googlemail.com> wrote:
>
> > Hi there,
>
> > Can anyone recommend a tutorial for using dbaccess in menu mode?
>
> How about the Dbaccess Manual which is part of the IDS documentation
> set online.
>
> Art S. Kagel
> Oninit
>
> > When prompted to hit return, e.g. "Select a server with the Arrow
> > Keys, or enter a name, then press Return." I can move the cursor to
> > highlight the database but hitting return causes the cursor to move
> > forward to the next db. Manually entering the name and hitting return
> > will work though.
>
> > I am running it from a console in Ubuntu Linux.
>
> > Apologies if this has been asked before, but I couldn't find it by
> > searching the group.
>
> > Kind Regards
>
> > Andrew

Hi Art,

Have had a look at the manual, but it just reiterates what the
dbaccess program tells you to do. ie. press RETURN.

Everything works for me except pressing RETURN (or Enter)

Thanks

Andrew

On Dec 27, 1:21 pm, Andrew2006 <mymate...@googlemail.com> wrote:
> On Dec 27, 11:52 am, "Art S. Kagel" <art.ka...@gmail.com> wrote:
>
>
>
> > On Dec 27, 6:24 am, Andrew2006 <mymate...@googlemail.com> wrote:
>
> > > Hi there,
>
> > > Can anyone recommend a tutorial for using dbaccess in menu mode?
>
> > How about the Dbaccess Manual which is part of the IDS documentation
> > set online.
>
> > Art S. Kagel
> > Oninit
>
> > > When prompted to hit return, e.g. "Select a server with the Arrow
> > > Keys, or enter a name, then press Return." I can move the cursor to
> > > highlight the database but hitting return causes the cursor to move
> > > forward to the next db. Manually entering the name and hitting return
> > > will work though.
>
> > > I am running it from a console in Ubuntu Linux.
>
> > > Apologies if this has been asked before, but I couldn't find it by
> > > searching the group.
>
> > > Kind Regards
>
> > > Andrew
>
> Hi Art,
>
> Have had a look at the manual, but it just reiterates what the
> dbaccess program tells you to do. ie. press RETURN.
>
> Everything works for me except pressing RETURN (or Enter)
>
> Thanks
>
> Andrew

The page I'm referring to is here:
http://publib.boulder.ibm.com/infoce...doc/sqlt65.htm

Andrew2006 wrote:
> On Dec 27, 11:52 am, "Art S. Kagel" <art.ka...@gmail.com> wrote:
>> On Dec 27, 6:24 am, Andrew2006 <mymate...@googlemail.com> wrote:
>>
>>> Hi there,
>>> Can anyone recommend a tutorial for using dbaccess in menu mode?
>> How about the Dbaccess Manual which is part of the IDS documentation
>> set online.
>>
>> Art S. Kagel
>> Oninit
>>
>>> When prompted to hit return, e.g. "Select a server with the Arrow
>>> Keys, or enter a name, then press Return." I can move the cursor to
>>> highlight the database but hitting return causes the cursor to move
>>> forward to the next db. Manually entering the name and hitting return
>>> will work though.
>>> I am running it from a console in Ubuntu Linux.
>>> Apologies if this has been asked before, but I couldn't find it by
>>> searching the group.
>>> Kind Regards
>>> Andrew
>
> Hi Art,
>
> Have had a look at the manual, but it just reiterates what the
> dbaccess program tells you to do. ie. press RETURN.
>
> Everything works for me except pressing RETURN (or Enter)
>
> Thanks
>
> Andrew

Chances are that there is something wrong with your termcap.
RETURN (or ENTER) is indeed what you should be using. Try Control-J or
Control-M, and see if it makes a difference
--
Ciao,
Marco
__________________________________________________ ____________________________
Marco Greco /UK /IBM Standard disclaimers apply!

Structured Query Scripting Language http://www.4glworks.com/sqsl.htm
4glworks http://www.4glworks.com
Informix on Linux http://www.4glworks.com/ifmxlinux.htm

On Dec 27, 2:35 pm, Marco Greco <ma...@4glworks.com> wrote:
> Andrew2006 wrote:
> > On Dec 27, 11:52 am, "Art S. Kagel" <art.ka...@gmail.com> wrote:
> >> On Dec 27, 6:24 am, Andrew2006 <mymate...@googlemail.com> wrote:
>
> >>> Hi there,
> >>> Can anyone recommend a tutorial for using dbaccess in menu mode?
> >> How about the Dbaccess Manual which is part of the IDS documentation
> >> set online.
>
> >> Art S. Kagel
> >> Oninit
>
> >>> When prompted to hit return, e.g. "Select a server with the Arrow
> >>> Keys, or enter a name, then press Return." I can move the cursor to
> >>> highlight the database but hitting return causes the cursor to move
> >>> forward to the next db. Manually entering the name and hitting return
> >>> will work though.
> >>> I am running it from a console in Ubuntu Linux.
> >>> Apologies if this has been asked before, but I couldn't find it by
> >>> searching the group.
> >>> Kind Regards
> >>> Andrew
>
> > Hi Art,
>
> > Have had a look at the manual, but it just reiterates what the
> > dbaccess program tells you to do. ie. press RETURN.
>
> > Everything works for me except pressing RETURN (or Enter)
>
> > Thanks
>
> > Andrew
>
> Chances are that there is something wrong with your termcap.
> RETURN (or ENTER) is indeed what you should be using. Try Control-J or
> Control-M, and see if it makes a difference
> --
> Ciao,
> Marco
> __________________________________________________ ____________________________
> Marco Greco /UK /IBM Standard disclaimers apply!
>
> Structured Query Scripting Language http://www.4glworks.com/sqsl.htm
> 4glworks http://www.4glworks.com
> Informix on Linux http://www.4glworks.com/ifmxlinux.htm


Hi Marco,

Ctrl-J and Ctrl-M just cause the cursor to move down. :-(

Thanks

Andrew

On Dec 27, 2007 3:24 AM, Andrew2006 <mymatebob@googlemail.com> wrote:
> Can anyone recommend a tutorial for using dbaccess in menu mode?
>
> When prompted to hit return, e.g. "Select a server with the Arrow
> Keys, or enter a name, then press Return." I can move the cursor to
> highlight the database but hitting return causes the cursor to move
> forward to the next db. Manually entering the name and hitting return
> will work though.
>
> I am running it from a console in Ubuntu Linux.

I agree with the general consensus that the problem is most likely
related to terminal handling.

One option no-one else mentioned is setting INFORMIXTERM=terminfo and
then using
the terminfo entries instead of the termcap entries. You might then
need to set TERMINFO=/where/you/terminfo/files/are (but probably would
not).

This isn't necessarily a slam dunk - the Informix termcap file is a
weird and wonderful thing (but not necessarily updated very often -
I'd be mildly surprised if it had been updated in the current
millennium, but I might be doing people an injustice).


--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2007.0914 -- http://dbi.perl.org/
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.

On Dec 28, 7:04 am, "Jonathan Leffler" <jleffler.i...@gmail.com>
wrote:
> On Dec 27, 2007 3:24 AM, Andrew2006 <mymate...@googlemail.com> wrote:
>
> > Can anyone recommend a tutorial for using dbaccess in menu mode?
>
> > When prompted to hit return, e.g. "Select a server with the Arrow
> > Keys, or enter a name, then press Return." I can move the cursor to
> > highlight the database but hitting return causes the cursor to move
> > forward to the next db. Manually entering the name and hitting return
> > will work though.
>
> > I am running it from a console in Ubuntu Linux.
>
> I agree with the general consensus that the problem is most likely
> related to terminal handling.
>
> One option no-one else mentioned is setting INFORMIXTERM=terminfo and
> then using
> the terminfo entries instead of the termcap entries. You might then
> need to set TERMINFO=/where/you/terminfo/files/are (but probably would
> not).
>
> This isn't necessarily a slam dunk - the Informix termcap file is a
> weird and wonderful thing (but not necessarily updated very often -
> I'd be mildly surprised if it had been updated in the current
> millennium, but I might be doing people an injustice).
>
> --
> Jonathan Leffler #include <disclaimer.h>
> Email: jleff...@earthlink.net, jleff...@us.ibm.com
> Guardian of DBD::Informix v2007.0914 --http://dbi.perl.org/
> NB: Please do not use this email for correspondence.
> I don't necessarily read it every week, even.


Jonathon,

Tried setting INFORMIXTERM=terminfo, with and without TERMINFO=/usr/
share/terminfo/
Unfortunately no joy there.

Thanks

Andrew

A colleague found the problem in my .bashrc:

alias dbaccess='rlwrap dbaccess'

I use rlwrap when in non-menu mode as you can view your history of all
previous sql queries using the up and down arrows.

When I used the alternative version I was specifying the full path and
so not using my alias, hence it worked correctly.

Thankyou everyone for all the help.

Andrew