term type for dbaccess?
Problem: in dbaccess on CentOS 6.4 / Informix 12.1, the arrow keys don't move the highlight in the table Modify screens (and 'enter' then gives "The highlight must be on a value when you select Modify"), regardless of whether PuTTY or WRQ Reflection is used. Suggestions offered: use TERM=scoansi with PuTTY's SCO keypad mode (symlinking scoansi to ansi under /usr/share/terminfo if missing), or TERM=xterm with INFORMIXTERM=terminfo, or vt220/vt100 with TERMCAP=terminfo, plus toggling keypad application mode and using letter keys/space bar to move the highlight. The poster tried all of these and posted his full environment (TERM=scoansi, TERMCAP pointing at $INFORMIXDIR/etc/termcap), but the thread ends there with no resolution recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I've noticed on our system that when designing new tables using dbaccess that
the console doesn't react as I would expect. For example, if I go to Modify,
the up/down buttons don't change the highlighted field. Is there a certain
terminal type I should be using, or some other environment variable I need to
set?
The server is running Linux (Centos 6.4), Informix 12.1. I've tried connecting
via putty using xterm and via WRQ Reflection using 'Linux Console', but they
seem to have the same result.
Is there some sort of standard terminal type that dbaccess requires to
function properly?
-Justin
If you are using Putty then use the scoansi setting and you should be good
with the TERM as scoansi. If you are using termcap then scoansi should be
there, some Linux distro don't seem to have scoansi under terminfo so just
link ansi to scoansi under /usr/share/terminfo
Cheers
Paul
> I've noticed on our system that when designing new tables using dbaccess
> that
> the console doesn't react as I would expect. For example, if I go to
> Modify,
> the up/down buttons don't change the highlighted field. Is there a certain
> terminal type I should be using, or some other environment variable I need
> to
> set?
>
> The server is running Linux (Centos 6.4), Informix 12.1. I've tried
> connecting
> via putty using xterm and via WRQ Reflection using 'Linux Console', but
> they
> seem to have the same result.
>
> Is there some sort of standard terminal type that dbaccess requires to
> function properly?
>
> -Justin
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
--
Paul Watson
Tel: +1 913-674-0360
Mob: +1 913-387-7529
Web: www.oninit.com
Failure is not as frightening as regret.
If you want to improve, be content to be thought foolish and stupid.
What this country needs are more unemployed politicians
Hi,
xterm should be ok, make sure you have
export INFORMIXTERM=terminfoenvironment set.
Also check your env for TERM variable. Should be xterm.
Marcus Haarmann
----- Ursprüngliche Mail -----
Von: "Justin Killen" <jkillen@allamericanasphalt.com>
An: ids@iiug.org
Gesendet: Mittwoch, 26. März 2014 17:25:31
Betreff: term type for dbaccess? [32808]
I've noticed on our system that when designing new tables using dbaccess that
the console doesn't react as I would expect. For example, if I go to Modify,
the up/down buttons don't change the highlighted field. Is there a certain
terminal type I should be using, or some other environment variable I need to
set?
The server is running Linux (Centos 6.4), Informix 12.1. I've tried connecting
via putty using xterm and via WRQ Reflection using 'Linux Console', but they
seem to have the same result.
Is there some sort of standard terminal type that dbaccess requires to
function properly?
-Justin
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Set putty to use vt220, set TERM=vt220 or vt100, set TERMCAP=terminator
Art
Art S. Kagel
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG or any other organization with which I sm
associated either explicitely or implicitely not on individuals affiliated
with those organizations.
On Mar 26, 2014 12:26 PM, "Justin Killen" <jkillen@allamericanasphalt.com>
wrote:
> I've noticed on our system that when designing new tables using dbaccess
> that
> the console doesn't react as I would expect. For example, if I go to
> Modify,
> the up/down buttons don't change the highlighted field. Is there a certain
> terminal type I should be using, or some other environment variable I need
> to
> set?
>
> The server is running Linux (Centos 6.4), Informix 12.1. I've tried
> connecting
> via putty using xterm and via WRQ Reflection using 'Linux Console', but
> they
> seem to have the same result.
>
> Is there some sort of standard terminal type that dbaccess requires to
> function properly?
>
> -Justin
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1135e20c2b6a8504f5859f47
Oops TERMCAP=terminfo
Art
Art S. Kagel
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG or any other organization with which I sm
associated either explicitely or implicitely not on individuals affiliated
with those organizations.
On Mar 26, 2014 1:16 PM, "Art Kagel" <art.kagel@gmail.com> wrote:
> Set putty to use vt220, set TERM=vt220 or vt100, set TERMCAP=terminator
>
> Art
>
> Art S. Kagel
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG or any other organization with which I sm
> associated either explicitely or implicitely not on individuals affiliated
> with those organizations.
>
> On Mar 26, 2014 12:26 PM, "Justin Killen" <jkillen@allamericanasphalt.com>
> wrote:
>
> > I've noticed on our system that when designing new tables using dbaccess
> > that
> > the console doesn't react as I would expect. For example, if I go to
> > Modify,
> > the up/down buttons don't change the highlighted field. Is there a
> certain
> > terminal type I should be using, or some other environment variable I
> need
> > to
> > set?
> >
> > The server is running Linux (Centos 6.4), Informix 12.1. I've tried
> > connecting
> > via putty using xterm and via WRQ Reflection using 'Linux Console', but
> > they
> > seem to have the same result.
> >
> > Is there some sort of standard terminal type that dbaccess requires to
> > function properly?
> >
> > -Justin
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a1135e20c2b6a8504f5859f47
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e0158aef49ee35904f585a82e
I've tried the suggestions from Paul, Marcus, and Art, but none of them seem
to work as I would expect. Can someone confirm that these key sequences do
what I think they should do?
dbaccess dbname[enter]
[right arrow][right arrow][right arrow][enter]
[enter]
test[enter]
[enter]
[enter]
asdf[return][return][return][return][return][return]
fdsa[return][return][return][return][return][return]
jkl[return][return][return][return][return][return]
[control-c]
[right arrow][enter]
[down arrow]
After this, I would expect the column name 'fdsa' to be selected, and pressing
[enter] would allow me to re-name it. Right now, everything seems to work fine
until I press [down arrow], which seems to do nothing (asdf is still
highlighted). To top it off, if I then press [enter], instead of being
prompted to re-name the column, I get the error "The highlight must be on a
value when you select Modify".
Justin
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Wednesday, March 26, 2014 10:19 AM
> To: ids@iiug.org
> Subject: Re: term type for dbaccess? [32814]
>
> Oops TERMCAP=terminfo
>
> Art
>
> Art S. Kagel
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG or any other organization with which I sm
> associated either explicitely or implicitely not on individuals affiliated
> with those organizations.
>
> On Mar 26, 2014 1:16 PM, "Art Kagel" <art.kagel@gmail.com> wrote:
>
> > Set putty to use vt220, set TERM=vt220 or vt100, set TERMCAP=terminator
> >
> > Art
> >
> > Art S. Kagel
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG or any other organization with which I sm
> > associated either explicitely or implicitely not on individuals
> affiliated
> > with those organizations.
> >
> > On Mar 26, 2014 12:26 PM, "Justin Killen"
> <jkillen@allamericanasphalt.com>
> > wrote:
> >
> > > I've noticed on our system that when designing new tables using
> dbaccess> > > that
> > > the console doesn't react as I would expect. For example, if I go to
> > > Modify,
> > > the up/down buttons don't change the highlighted field. Is there a
> > certain
> > > terminal type I should be using, or some other environment variable I
> > need
> > > to
> > > set?
> > >
> > > The server is running Linux (Centos 6.4), Informix 12.1. I've tried
> > > connecting
> > > via putty using xterm and via WRQ Reflection using 'Linux Console',
> but
> > > they
> > > seem to have the same result.
> > >
> > > Is there some sort of standard terminal type that dbaccess requires to
> > > function properly?
> > >
> > > -Justin
> > >
> > >
> > >
> > >
> >
> >
> **************************************************************************
> *****
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a1135e20c2b6a8504f5859f47
> >
> >
> >
> >
> **************************************************************************
> *****
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --089e0158aef49ee35904f585a82e
>
>
> **************************************************************************
> *****
> Forum Note: Use "Reply" to post a response in the discussion forum.
Post your env and the emulator you are using if coming from a PC
> I've tried the suggestions from Paul, Marcus, and Art, but none of them
> seem
> to work as I would expect. Can someone confirm that these key sequences do
> what I think they should do?
>
> dbaccess dbname[enter]
> [right arrow][right arrow][right arrow][enter]
> [enter]
> test[enter]
> [enter]
> [enter]
> asdf[return][return][return][return][return][return]
> fdsa[return][return][return][return][return][return]
> jkl[return][return][return][return][return][return]
> [control-c]
> [right arrow][enter]
> [down arrow]
>
> After this, I would expect the column name 'fdsa' to be selected, and
> pressing
> [enter] would allow me to re-name it. Right now, everything seems to work
> fine
> until I press [down arrow], which seems to do nothing (asdf is still
> highlighted). To top it off, if I then press [enter], instead of being
> prompted to re-name the column, I get the error "The highlight must be on
> a
> value when you select Modify".
>
> Justin
>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>> Art
>> Kagel
>> Sent: Wednesday, March 26, 2014 10:19 AM
>> To: ids@iiug.org
>> Subject: Re: term type for dbaccess? [32814]
>>
>> Oops TERMCAP=terminfo
>>
>> Art
>>
>> Art S. Kagel
>>
>> Disclaimer: Please keep in mind that my own opinions are my own opinions
>> and do not reflect on the IIUG or any other organization with which I sm
>> associated either explicitely or implicitely not on individuals
>> affiliated
>> with those organizations.
>>
>> On Mar 26, 2014 1:16 PM, "Art Kagel" <art.kagel@gmail.com> wrote:
>>
>> > Set putty to use vt220, set TERM=vt220 or vt100, set
>> TERMCAP=terminator
>> >
>> > Art
>> >
>> > Art S. Kagel
>> >
>> > Disclaimer: Please keep in mind that my own opinions are my own
>> opinions
>> > and do not reflect on the IIUG or any other organization with which I
>> sm
>> > associated either explicitely or implicitely not on individuals
>> affiliated
>> > with those organizations.
>> >
>> > On Mar 26, 2014 12:26 PM, "Justin Killen"
>> <jkillen@allamericanasphalt.com>
>> > wrote:
>> >
>> > > I've noticed on our system that when designing new tables using
>> dbaccess>> > > that
>> > > the console doesn't react as I would expect. For example, if I go to
>> > > Modify,
>> > > the up/down buttons don't change the highlighted field. Is there a
>> > certain
>> > > terminal type I should be using, or some other environment variable
>> I
>> > need
>> > > to
>> > > set?
>> > >
>> > > The server is running Linux (Centos 6.4), Informix 12.1. I've tried
>> > > connecting
>> > > via putty using xterm and via WRQ Reflection using 'Linux Console',
>> but
>> > > they
>> > > seem to have the same result.
>> > >
>> > > Is there some sort of standard terminal type that dbaccess requires
>> to
>> > > function properly?
>> > >
>> > > -Justin
>> > >
>> > >
>> > >
>> > >
>> >
>> >
>> **************************************************************************
>> *****
>> > > Forum Note: Use "Reply" to post a response in the discussion forum.
>> > >
>> > >
>> >
>> > --001a1135e20c2b6a8504f5859f47
>> >
>> >
>> >
>> >
>> **************************************************************************
>> *****
>> > Forum Note: Use "Reply" to post a response in the discussion forum.
>> >
>> >
>>
>> --089e0158aef49ee35904f585a82e
>>
>>
>> **************************************************************************
>> *****
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
--
Paul Watson
Tel: +1 913-674-0360
Mob: +1 913-387-7529
Web: www.oninit.com
Failure is not as frightening as regret.
If you want to improve, be content to be thought foolish and stupid.
What this country needs are more unemployed politicians
Try changing the keypad mode to/from application mode. You can also select
menu choices with a letter and move the highlight with the space bar.
Art
Art S. Kagel
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG or any other organization with which I sm
associated either explicitely or implicitely not on individuals affiliated
with those organizations.
On Mar 26, 2014 1:31 PM, "Justin Killen" <jkillen@allamericanasphalt.com>
wrote:
> I've tried the suggestions from Paul, Marcus, and Art, but none of them
> seem
> to work as I would expect. Can someone confirm that these key sequences do
> what I think they should do?
>
> dbaccess dbname[enter]
> [right arrow][right arrow][right arrow][enter]
> [enter]
> test[enter]
> [enter]
> [enter]
> asdf[return][return][return][return][return][return]
> fdsa[return][return][return][return][return][return]
> jkl[return][return][return][return][return][return]
> [control-c]
> [right arrow][enter]
> [down arrow]
>
> After this, I would expect the column name 'fdsa' to be selected, and
> pressing
> [enter] would allow me to re-name it. Right now, everything seems to work
> fine
> until I press [down arrow], which seems to do nothing (asdf is still
> highlighted). To top it off, if I then press [enter], instead of being
> prompted to re-name the column, I get the error "The highlight must be on a
> value when you select Modify".
>
> Justin
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art
> > Kagel
> > Sent: Wednesday, March 26, 2014 10:19 AM
> > To: ids@iiug.org
> > Subject: Re: term type for dbaccess? [32814]
> >
> > Oops TERMCAP=terminfo
> >
> > Art
> >
> > Art S. Kagel
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG or any other organization with which I sm
> > associated either explicitely or implicitely not on individuals
> affiliated
> > with those organizations.
> >
> > On Mar 26, 2014 1:16 PM, "Art Kagel" <art.kagel@gmail.com> wrote:
> >
> > > Set putty to use vt220, set TERM=vt220 or vt100, set TERMCAP=terminator
> > >
> > > Art
> > >
> > > Art S. Kagel
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> > > and do not reflect on the IIUG or any other organization with which I
> sm
> > > associated either explicitely or implicitely not on individuals
> > affiliated
> > > with those organizations.
> > >
> > > On Mar 26, 2014 12:26 PM, "Justin Killen"
> > <jkillen@allamericanasphalt.com>
> > > wrote:
> > >
> > > > I've noticed on our system that when designing new tables using
> > dbaccess> > > > that
> > > > the console doesn't react as I would expect. For example, if I go to
> > > > Modify,
> > > > the up/down buttons don't change the highlighted field. Is there a
> > > certain
> > > > terminal type I should be using, or some other environment variable I
> > > need
> > > > to
> > > > set?
> > > >
> > > > The server is running Linux (Centos 6.4), Informix 12.1. I've tried
> > > > connecting
> > > > via putty using xterm and via WRQ Reflection using 'Linux Console',
> > but
> > > > they
> > > > seem to have the same result.
> > > >
> > > > Is there some sort of standard terminal type that dbaccess requires
> to
> > > > function properly?
> > > >
> > > > -Justin
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> **************************************************************************
> > *****
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --001a1135e20c2b6a8504f5859f47
> > >
> > >
> > >
> > >
> >
> **************************************************************************
> > *****
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --089e0158aef49ee35904f585a82e
> >
> >
> >
> **************************************************************************
> > *****
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11c3cbe241067a04f585f141
I don't appear to have a scoansi. I do have an ansi, so I linked scoansi ->
ansi.
Justin Killen
Senior Programmer / Analyst
All American Asphalt
951-736-7600 x 260
jkillen@allamericanasphalt.com
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Paul
> Watson
> Sent: Wednesday, March 26, 2014 9:30 AM
> To: ids@iiug.org
> Subject: Re: term type for dbaccess? [32809]
>
> If you are using Putty then use the scoansi setting and you should be good
> with the TERM as scoansi. If you are using termcap then scoansi should be
> there, some Linux distro don't seem to have scoansi under terminfo so just
> link ansi to scoansi under /usr/share/terminfo
>
> Cheers
> Paul
>
> > I've noticed on our system that when designing new tables using dbaccess
> > that
> > the console doesn't react as I would expect. For example, if I go to
> > Modify,
> > the up/down buttons don't change the highlighted field. Is there a
> certain
> > terminal type I should be using, or some other environment variable I
> need
> > to
> > set?
> >
> > The server is running Linux (Centos 6.4), Informix 12.1. I've tried
> > connecting
> > via putty using xterm and via WRQ Reflection using 'Linux Console', but
> > they
> > seem to have the same result.
> >
> > Is there some sort of standard terminal type that dbaccess requires to
> > function properly?
> >
> > -Justin
> >
> >
> >
> **************************************************************************
> *****
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> --
> Paul Watson
> Tel: +1 913-674-0360
> Mob: +1 913-387-7529
> Web: www.oninit.com
>
> Failure is not as frightening as regret.
> If you want to improve, be content to be thought foolish and stupid.
> What this country needs are more unemployed politicians
>
>
> **************************************************************************
> *****
> Forum Note: Use "Reply" to post a response in the discussion forum.
[informix@moe ~]$ set
BASH=/bin/bash
BASHOPTS=checkwinsize:cmdhist:expand_aliases:extquote:force_fignore:hostcomplete
:interactive_comments:login_shell:progcomp:promptvars:sourcepath
BASH_ALIASES=()
BASH_ARGC=()
BASH_ARGV=()
BASH_CMDS=()
BASH_LINENO=()
BASH_SOURCE=()
BASH_VERSINFO=([0]="4" [1]="1" [2]="2" [3]="1" [4]="release"
[5]="x86_64-redhat-linux-gnu")
BASH_VERSION='4.1.2(1)-release'
COLORS=/etc/DIR_COLORS
COLUMNS=237
CVS_RSH=ssh
DBEDIT=vim
DIRSTACK=()
EUID=500
GROUPS=()
G_BROKEN_FILENAMES=1
HISTCONTROL=ignoredups
HISTFILE=/home/informix/.bash_history
HISTFILESIZE=1000
HISTSIZE=1000
HOME=/home/informix
HOSTNAME=moe.sg1.allamericanasphalt.com
HOSTTYPE=x86_64
ID=500
IFS=$' \\\\t\\
'
INFORMIXDIR=/usr/informix
INFORMIXSERVER=moenet
INFORMIXSQLHOSTS=/usr/informix/etc/sqlhostsLANG=en_US.UTF-8
LESSOPEN='|/usr/bin/lesspipe.sh %s'
LINES=69
LOGNAME=informix
LS_COLORS='rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:c
d=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;
42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31
:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31
:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;3
1:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=0
1;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.b
mp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35
:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx
=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:
*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01
;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.fl
v=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.
emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36
:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg
=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:'
MACHTYPE=x86_64-redhat-linux-gnu
MAIL=/var/spool/mail/informix
MAILCHECK=60
ONCONFIG=onconfigOPTERR=1
OPTIND=1
OSTYPE=linux-gnu
PATH=/usr/informix/bin:/usr/informix/extend/krakatoa/jre/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/informix/b
in
PIPESTATUS=([0]="0")
PPID=11035
PROMPT_COMMAND='printf "\\\\033]0;%s@%s:%s\\\\007" "${USER}" "${HOSTNAME%%.*}"
"${PWD/#$HOME/~}"'
PS1='[\\\\u@\\\\h \\\\W]\\\\$ '
PS2='> '
PS4='+ '
PWD=/home/informix
QTDIR=/usr/lib64/qt-3.3
QTINC=/usr/lib64/qt-3.3/include
QTLIB=/usr/lib64/qt-3.3/lib
SHELL=/bin/bash
SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments:moni
tor
SHLVL=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
TERM=scoansi
TERMCAP=/usr/informix/etc/termcap
UID=500
USER=informix
_=rmca_test
colors=/etc/DIR_COLORS
software terminal is putty version 0.63. The Terminal/Keyboard/ 'The function
keys and keypad' setting is: SCO (available options are ESC[n~, Linux, Xterm
R6, VT400, VT100+, SCO). All other settings are default.
I've also tried the following combinations:
(per Marcus)
TERM=xterm
INFORMIXTERM=terminfoTERMCAP=
Putty: Linux
(per Art)
TERM=vt220
TERMCAP=terminfo
INFORMIXTERM=
Putty: vt100+
-Justin
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Paul
> Watson
> Sent: Wednesday, March 26, 2014 10:37 AM
> To: ids@iiug.org
> Subject: RE: term type for dbaccess? [32816]
>
> Post your env and the emulator you are using if coming from a PC
>
> > I've tried the suggestions from Paul, Marcus, and Art, but none of them
> > seem
> > to work as I would expect. Can someone confirm that these key sequences
> do
> > what I think they should do?
> >
> > dbaccess dbname[enter]
> > [right arrow][right arrow][right arrow][enter]
> > [enter]
> > test[enter]
> > [enter]
> > [enter]
> > asdf[return][return][return][return][return][return]
> > fdsa[return][return][return][return][return][return]
> > jkl[return][return][return][return][return][return]
> > [control-c]
> > [right arrow][enter]
> > [down arrow]
> >
> > After this, I would expect the column name 'fdsa' to be selected, and
> > pressing
> > [enter] would allow me to re-name it. Right now, everything seems to
> work
> > fine
> > until I press [down arrow], which seems to do nothing (asdf is still
> > highlighted). To top it off, if I then press [enter], instead of being
> > prompted to re-name the column, I get the error "The highlight must be
> on
> > a
> > value when you select Modify".
> >
> > Justin
> >
> >> -----Original Message-----
> >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> >> Art
> >> Kagel
> >> Sent: Wednesday, March 26, 2014 10:19 AM
> >> To: ids@iiug.org
> >> Subject: Re: term type for dbaccess? [32814]
> >>
> >> Oops TERMCAP=terminfo
> >>
> >> Art
> >>
> >> Art S. Kagel
> >>
> >> Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> >> and do not reflect on the IIUG or any other organization with which I
> sm
> >> associated either explicitely or implicitely not on individuals
> >> affiliated
> >> with those organizations.
> >>
> >> On Mar 26, 2014 1:16 PM, "Art Kagel" <art.kagel@gmail.com> wrote:
> >>
> >> > Set putty to use vt220, set TERM=vt220 or vt100, set
> >> TERMCAP=terminator
> >> >
> >> > Art
> >> >
> >> > Art S. Kagel
> >> >
> >> > Disclaimer: Please keep in mind that my own opinions are my own
> >> opinions
> >> > and do not reflect on the IIUG or any other organization with which I
> >> sm
> >> > associated either explicitely or implicitely not on individuals
> >> affiliated
> >> > with those organizations.
> >> >
> >> > On Mar 26, 2014 12:26 PM, "Justin Killen"
> >> <jkillen@allamericanasphalt.com>
> >> > wrote:
> >> >
> >> > > I've noticed on our system that when designing new tables using
> >> dbaccess> >> > > that
> >> > > the console doesn't react as I would expect. For example, if I go
> to
> >> > > Modify,
> >> > > the up/down buttons don't change the highlighted field. Is there a
> >> > certain
> >> > > terminal type I should be using, or some other environment variable
> >> I
> >> > need
> >> > > to
> >> > > set?
> >> > >
> >> > > The server is running Linux (Centos 6.4), Informix 12.1. I've tried
> >> > > connecting
> >> > > via putty using xterm and via WRQ Reflection using 'Linux Console',
> >> but
> >> > > they
> >> > > seem to have the same result.
> >> > >
> >> > > Is there some sort of standard terminal type that dbaccess requires
> >> to@@
In the s directory under /usr/share/terminfo ?
> I don't appear to have a scoansi. I do have an ansi, so I linked scoansi
> ->
> ansi.
>
> Justin Killen
> Senior Programmer / Analyst
> All American Asphalt
> 951-736-7600 x 260
> jkillen@allamericanasphalt.com
>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>> Paul
>> Watson
>> Sent: Wednesday, March 26, 2014 9:30 AM
>> To: ids@iiug.org
>> Subject: Re: term type for dbaccess? [32809]
>>
>> If you are using Putty then use the scoansi setting and you should be
>> good
>> with the TERM as scoansi. If you are using termcap then scoansi should
>> be
>> there, some Linux distro don't seem to have scoansi under terminfo so
>> just
>> link ansi to scoansi under /usr/share/terminfo
>>
>> Cheers
>> Paul
>>
>> > I've noticed on our system that when designing new tables using
>> dbaccess>> > that
>> > the console doesn't react as I would expect. For example, if I go to
>> > Modify,
>> > the up/down buttons don't change the highlighted field. Is there a
>> certain
>> > terminal type I should be using, or some other environment variable I
>> need
>> > to
>> > set?
>> >
>> > The server is running Linux (Centos 6.4), Informix 12.1. I've tried
>> > connecting
>> > via putty using xterm and via WRQ Reflection using 'Linux Console',
>> but
>> > they
>> > seem to have the same result.
>> >
>> > Is there some sort of standard terminal type that dbaccess requires to
>> > function properly?
>> >
>> > -Justin
>> >
>> >
>> >
>> **************************************************************************
>> *****
>> > Forum Note: Use "Reply" to post a response in the discussion forum.
>> >
>>
>> --
>> Paul Watson
>> Tel: +1 913-674-0360
>> Mob: +1 913-387-7529
>> Web: www.oninit.com
>>
>> Failure is not as frightening as regret.
>> If you want to improve, be content to be thought foolish and stupid.
>> What this country needs are more unemployed politicians
>>
>>
>> **************************************************************************
>> *****
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
--
Paul Watson
Tel: +1 913-674-0360
Mob: +1 913-387-7529
Web: www.oninit.com
Failure is not as frightening as regret.
If you want to improve, be content to be thought foolish and stupid.
What this country needs are more unemployed politicians
Yes
-Justin
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Paul
> Watson
> Sent: Wednesday, March 26, 2014 11:02 AM
> To: ids@iiug.org
> Subject: RE: term type for dbaccess? [32820]
>
> In the s directory under /usr/share/terminfo ?
>
> > I don't appear to have a scoansi. I do have an ansi, so I linked scoansi
> > ->
> > ansi.
> >
> > Justin Killen
> > Senior Programmer / Analyst
> > All American Asphalt
> > 951-736-7600 x 260
> > jkillen@allamericanasphalt.com
> >
> >> -----Original Message-----
> >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> >> Paul
> >> Watson
> >> Sent: Wednesday, March 26, 2014 9:30 AM
> >> To: ids@iiug.org
> >> Subject: Re: term type for dbaccess? [32809]
> >>
> >> If you are using Putty then use the scoansi setting and you should be
> >> good
> >> with the TERM as scoansi. If you are using termcap then scoansi should
> >> be
> >> there, some Linux distro don't seem to have scoansi under terminfo so
> >> just
> >> link ansi to scoansi under /usr/share/terminfo
> >>
> >> Cheers
> >> Paul
> >>
> >> > I've noticed on our system that when designing new tables using
> >> dbaccess> >> > that
> >> > the console doesn't react as I would expect. For example, if I go to
> >> > Modify,
> >> > the up/down buttons don't change the highlighted field. Is there a
> >> certain
> >> > terminal type I should be using, or some other environment variable I
> >> need
> >> > to
> >> > set?
> >> >
> >> > The server is running Linux (Centos 6.4), Informix 12.1. I've tried
> >> > connecting
> >> > via putty using xterm and via WRQ Reflection using 'Linux Console',
> >> but
> >> > they
> >> > seem to have the same result.
> >> >
> >> > Is there some sort of standard terminal type that dbaccess requires
> to
> >> > function properly?
> >> >
> >> > -Justin
> >> >
> >> >
> >> >
> >>
> **************************************************************************
> >> *****
> >> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >> >
> >>
> >> --
> >> Paul Watson
> >> Tel: +1 913-674-0360
> >> Mob: +1 913-387-7529
> >> Web: www.oninit.com
> >>
> >> Failure is not as frightening as regret.
> >> If you want to improve, be content to be thought foolish and stupid.
> >> What this country needs are more unemployed politicians
> >>
> >>
> >>
> **************************************************************************
> >> *****
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> **************************************************************************
> *****
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> --
> Paul Watson
> Tel: +1 913-674-0360
> Mob: +1 913-387-7529
> Web: www.oninit.com
>
> Failure is not as frightening as regret.
> If you want to improve, be content to be thought foolish and stupid.
> What this country needs are more unemployed politicians
>
>
> **************************************************************************
> *****
> Forum Note: Use "Reply" to post a response in the discussion forum.
Just to be clear:
[root@moe ~]# ls -lah /usr/share/terminfo/s/*
lrwxrwxrwx. 1 root root 31 Mar 26 09:52 /usr/share/terminfo/s/scoansi ->
../../../../lib/terminfo/a/ansi
-Justin
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Paul
> Watson
> Sent: Wednesday, March 26, 2014 11:02 AM
> To: ids@iiug.org
> Subject: RE: term type for dbaccess? [32820]
>
> In the s directory under /usr/share/terminfo ?
>
> > I don't appear to have a scoansi. I do have an ansi, so I linked scoansi
> > ->
> > ansi.
> >
> > Justin Killen
> > Senior Programmer / Analyst
> > All American Asphalt
> > 951-736-7600 x 260
> > jkillen@allamericanasphalt.com
> >
> >> -----Original Message-----
> >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> >> Paul
> >> Watson
> >> Sent: Wednesday, March 26, 2014 9:30 AM
> >> To: ids@iiug.org
> >> Subject: Re: term type for dbaccess? [32809]
> >>
> >> If you are using Putty then use the scoansi setting and you should be
> >> good
> >> with the TERM as scoansi. If you are using termcap then scoansi should
> >> be
> >> there, some Linux distro don't seem to have scoansi under terminfo so
> >> just
> >> link ansi to scoansi under /usr/share/terminfo
> >>
> >> Cheers
> >> Paul
> >>
> >> > I've noticed on our system that when designing new tables using
> >> dbaccess> >> > that
> >> > the console doesn't react as I would expect. For example, if I go to
> >> > Modify,
> >> > the up/down buttons don't change the highlighted field. Is there a
> >> certain
> >> > terminal type I should be using, or some other environment variable I
> >> need
> >> > to
> >> > set?
> >> >
> >> > The server is running Linux (Centos 6.4), Informix 12.1. I've tried
> >> > connecting
> >> > via putty using xterm and via WRQ Reflection using 'Linux Console',
> >> but
> >> > they
> >> > seem to have the same result.
> >> >
> >> > Is there some sort of standard terminal type that dbaccess requires
> to
> >> > function properly?
> >> >
> >> > -Justin
> >> >
> >> >
> >> >
> >>
> **************************************************************************
> >> *****
> >> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >> >
> >>
> >> --
> >> Paul Watson
> >> Tel: +1 913-674-0360
> >> Mob: +1 913-387-7529
> >> Web: www.oninit.com
> >>
> >> Failure is not as frightening as regret.
> >> If you want to improve, be content to be thought foolish and stupid.
> >> What this country needs are more unemployed politicians
> >>
> >>
> >>
> **************************************************************************
> >> *****
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> **************************************************************************
> *****
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> --
> Paul Watson
> Tel: +1 913-674-0360
> Mob: +1 913-387-7529
> Web: www.oninit.com
>
> Failure is not as frightening as regret.
> If you want to improve, be content to be thought foolish and stupid.
> What this country needs are more unemployed politicians
>
>
> **************************************************************************
> *****
> Forum Note: Use "Reply" to post a response in the discussion forum.
I don't see an option in putty to change to/from application mode on-the-fly.
I did try changing "Initial state of cursor keys" and "Initial state of
numeric keypad" to 'Application' instead of 'Normal', then opened a new
session with those settings with no distinguishable difference.
Justin Killen
Senior Programmer / Analyst
All American Asphalt
951-736-7600 x 260
jkillen@allamericanasphalt.com
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Wednesday, March 26, 2014 10:39 AM
> To: ids@iiug.org
> Subject: RE: term type for dbaccess? [32817]
>
> Try changing the keypad mode to/from application mode. You can also select
> menu choices with a letter and move the highlight with the space bar.
>
> Art
>
> Art S. Kagel
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG or any other organization with which I sm
> associated either explicitely or implicitely not on individuals affiliated
> with those organizations.
>
> On Mar 26, 2014 1:31 PM, "Justin Killen" <jkillen@allamericanasphalt.com>
> wrote:
>
> > I've tried the suggestions from Paul, Marcus, and Art, but none of them
> > seem
> > to work as I would expect. Can someone confirm that these key sequences
> do
> > what I think they should do?
> >
> > dbaccess dbname[enter]
> > [right arrow][right arrow][right arrow][enter]
> > [enter]
> > test[enter]
> > [enter]
> > [enter]
> > asdf[return][return][return][return][return][return]
> > fdsa[return][return][return][return][return][return]
> > jkl[return][return][return][return][return][return]
> > [control-c]
> > [right arrow][enter]
> > [down arrow]
> >
> > After this, I would expect the column name 'fdsa' to be selected, and
> > pressing
> > [enter] would allow me to re-name it. Right now, everything seems to
> work
> > fine
> > until I press [down arrow], which seems to do nothing (asdf is still
> > highlighted). To top it off, if I then press [enter], instead of being
> > prompted to re-name the column, I get the error "The highlight must be
> on a
> > value when you select Modify".
> >
> > Justin
> >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Art
> > > Kagel
> > > Sent: Wednesday, March 26, 2014 10:19 AM
> > > To: ids@iiug.org
> > > Subject: Re: term type for dbaccess? [32814]
> > >
> > > Oops TERMCAP=terminfo
> > >
> > > Art
> > >
> > > Art S. Kagel
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> > > and do not reflect on the IIUG or any other organization with which I
> sm
> > > associated either explicitely or implicitely not on individuals
> > affiliated
> > > with those organizations.
> > >
> > > On Mar 26, 2014 1:16 PM, "Art Kagel" <art.kagel@gmail.com> wrote:
> > >
> > > > Set putty to use vt220, set TERM=vt220 or vt100, set
> TERMCAP=terminator
> > > >
> > > > Art
> > > >
> > > > Art S. Kagel
> > > >
> > > > Disclaimer: Please keep in mind that my own opinions are my own
> > opinions
> > > > and do not reflect on the IIUG or any other organization with which
> I
> > sm
> > > > associated either explicitely or implicitely not on individuals
> > > affiliated
> > > > with those organizations.
> > > >
> > > > On Mar 26, 2014 12:26 PM, "Justin Killen"
> > > <jkillen@allamericanasphalt.com>
> > > > wrote:
> > > >
> > > > > I've noticed on our system that when designing new tables using
> > > dbaccess> > > > > that
> > > > > the console doesn't react as I would expect. For example, if I go
> to
> > > > > Modify,
> > > > > the up/down buttons don't change the highlighted field. Is there a
> > > > certain
> > > > > terminal type I should be using, or some other environment
> variable I
> > > > need
> > > > > to
> > > > > set?
> > > > >
> > > > > The server is running Linux (Centos 6.4), Informix 12.1. I've
> tried
> > > > > connecting
> > > > > via putty using xterm and via WRQ Reflection using 'Linux
> Console',
> > > but
> > > > > they
> > > > > seem to have the same result.
> > > > >
> > > > > Is there some sort of standard terminal type that dbaccess
> requires
> > to
> > > > > function properly?
> > > > >
> > > > > -Justin
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
> **************************************************************************
> > > *****
> > > > > Forum Note: Use "Reply" to post a response in the discussion
> forum.
> > > > >
> > > > >
> > > >
> > > > --001a1135e20c2b6a8504f5859f47
> > > >
> > > >
> > > >
> > > >
> > >
> >
> **************************************************************************
> > > *****
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --089e0158aef49ee35904f585a82e
> > >
> > >
> > >
> >
> **************************************************************************
> > > *****
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
> **************************************************************************
> *****
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a11c3cbe241067a04f585f141
>
>
> **************************************************************************
> *****
> Forum Note: Use "Reply" to post a response in the discussion forum.
WRQ Reflection - i usee term type vt102 in environment TERM=vt100 TERMCAP=/opt/informix/etc/termcap this is on RHEL
Try setting TERMCAP=terminfo because some of the special keys aren't defined in the termcap file. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Mar 26, 2014 at 8:23 PM, KARL OLIVER <karl.oliver@maf.govt.nz>wrote: > WRQ Reflection - i usee term type vt102 > > in environment > TERM=vt100 > TERMCAP=/opt/informix/etc/termcap > this is on RHEL > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c352a44a966b04f58be2d7
I tried with Reflections with a termcap, and the down arrow still doesn't work.
Without the termcap (TERMCAP=terminfo), the down arrow also does not work.
Interestingly, the down arrow does seem to work on the menus (it goes to the
previous/next page), just not on the bottom grid.
-Justin
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Wednesday, March 26, 2014 5:44 PM
> To: ids@iiug.org
> Subject: Re: RE: term type for dbaccess? [32825]
>
> Try setting TERMCAP=terminfo because some of the special keys aren't
> defined in the termcap file.
>
> Art
>
> Art S. Kagel, Principal Consultant
> ASK Database Management
>
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Wed, Mar 26, 2014 at 8:23 PM, KARL OLIVER
> <karl.oliver@maf.govt.nz>wrote:
>
> > WRQ Reflection - i usee term type vt102
> >
> > in environment
> > TERM=vt100
> > TERMCAP=/opt/informix/etc/termcap
> > this is on RHEL
> >
> >
> >
> >
> **************************************************************************
> *****
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a11c352a44a966b04f58be2d7
>
>
> **************************************************************************
> *****
> Forum Note: Use "Reply" to post a response in the discussion forum.
I reached out to a third party support to look at this, and the tech was able
to duplicate the issue within the 12.10FC1 virtual appliance. It seems to be a
bug in dbaccess for that specific version.
For anybody interested, I opened a PMR with IBM, PMR# 14038,227,000.
-Justin
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Justin Killen
> Sent: Thursday, March 27, 2014 8:53 AM
> To: ids@iiug.org
> Subject: RE: RE: term type for dbaccess? [32836]
>
> I tried with Reflections with a termcap, and the down arrow still doesn't
> work.
>
> Without the termcap (TERMCAP=terminfo), the down arrow also does not work.
>
> Interestingly, the down arrow does seem to work on the menus (it goes to
> the
> previous/next page), just not on the bottom grid.
>
> -Justin
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art
> > Kagel
> > Sent: Wednesday, March 26, 2014 5:44 PM
> > To: ids@iiug.org
> > Subject: Re: RE: term type for dbaccess? [32825]
> >
> > Try setting TERMCAP=terminfo because some of the special keys aren't
> > defined in the termcap file.
> >
> > Art
> >
> > Art S. Kagel, Principal Consultant
> > ASK Database Management
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG, nor any other organization with which I
> am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Wed, Mar 26, 2014 at 8:23 PM, KARL OLIVER
> > <karl.oliver@maf.govt.nz>wrote:
> >
> > > WRQ Reflection - i usee term type vt102
> > >
> > > in environment
> > > TERM=vt100
> > > TERMCAP=/opt/informix/etc/termcap
> > > this is on RHEL
> > >
> > >
> > >
> > >
> >
> **************************************************************************
> > *****
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a11c352a44a966b04f58be2d7
> >
> >
> >
> **************************************************************************
> > *****
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> **************************************************************************
> *****
> Forum Note: Use "Reply" to post a response in the discussion forum.