IDS Forum

RE: term type for dbaccess?

Posted By: Justin Killen
Date: Wednesday, 26 March 2014, at 2:01 p.m.

In Response To: RE: term type for dbaccess? (Paul Watson)

[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\n'
INFORMIXDIR=/usr/informix
INFORMIXSERVER=moenet
INFORMIXSQLHOSTS=/usr/informix/etc/sqlhosts
LANG=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:cd=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;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=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:*.flv=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=onconfig
OPTERR=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/bin
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:monitor
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=terminfo
TERMCAP=

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
> >> > > 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
>
>
> **************************************************************************
> *****
> Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• term type for dbaccess?
  Justin Killen -- Wednesday, 26 March 2014, at 12:25 p.m.
  • Re: term type for dbaccess?
    Paul Watson -- Wednesday, 26 March 2014, at 12:29 p.m.
    • RE: term type for dbaccess?
      Justin Killen -- Wednesday, 26 March 2014, at 1:43 p.m.
      • RE: term type for dbaccess?
        Paul Watson -- Wednesday, 26 March 2014, at 2:01 p.m.
        • RE: term type for dbaccess?
          Justin Killen -- Wednesday, 26 March 2014, at 2:04 p.m.
        • RE: term type for dbaccess?
          Justin Killen -- Wednesday, 26 March 2014, at 2:04 p.m.
  • Re: term type for dbaccess?
    Marcus Haarmann -- Wednesday, 26 March 2014, at 1:11 p.m.
  • Re: term type for dbaccess?
    Art Kagel -- Wednesday, 26 March 2014, at 1:16 p.m.
    • Re: term type for dbaccess?
      Art Kagel -- Wednesday, 26 March 2014, at 1:18 p.m.
      • RE: term type for dbaccess?
        Justin Killen -- Wednesday, 26 March 2014, at 1:31 p.m.
        • RE: term type for dbaccess?
          Paul Watson -- Wednesday, 26 March 2014, at 1:36 p.m.
          • RE: term type for dbaccess?
            Justin Killen -- Wednesday, 26 March 2014, at 2:01 p.m.
        • RE: term type for dbaccess?
          Art Kagel -- Wednesday, 26 March 2014, at 1:39 p.m.
          • RE: term type for dbaccess?
            Justin Killen -- Wednesday, 26 March 2014, at 2:07 p.m.
            • Re: RE: term type for dbaccess?
              KARL OLIVER -- Wednesday, 26 March 2014, at 8:23 p.m.
              • Re: RE: term type for dbaccess?
                Art Kagel -- Wednesday, 26 March 2014, at 8:44 p.m.
                • RE: RE: term type for dbaccess?
                  Justin Killen -- Thursday, 27 March 2014, at 11:53 a.m.
                  • RE: RE: term type for dbaccess?
                    Justin Killen -- Thursday, 27 March 2014, at 2:17 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.