Using Ingres on HP Workstation 
Author Message
 Using Ingres on HP Workstation

Hi !

Before I proceed with the problem description, here is our environment :

Ingres 6.4/04 (hp8.us5/00)
HP-UX ver 9.00 on
HP-9000 G40

When I try to use abf, qbf, isql etc from an HP workstation then I get
all the funny characters appearing where it should have drawn straight
lines. I have tried setting the TERM_INGRES to all the *.map present in
$II_SYSTEM/ingres/files but still I am not able to get rid of this
problem.

TERM_INGRES=hp gives me correct emulation but I can not use any of the
function keys because none is attached to any menuoption. Finally I have
settled for TERM_INGRES=dgxterm which does not give me correct emulation
but allows me to use some of the function keys.

Ideally what I would like to have is correct emulation plus use of
function keys and PageUp and PageDown keys.

I believe something needs to be done to 'termcap' in
$II_SYSTEM/ingres/files and also the map file. Am I in the right
direction ?

Has anybody else faced this problem and was able to solve it ??

Thanks for all the help.

Regards

G.D.Madan
-------------------------------------------------------------------------------
SGS-Thomson Microelectronics,           | Phone    : (65) 4821411 Ext 5496
28 Ang Mo Kio, Industrial Park II,      | Fax      : (65) 4820240          

-------------------------------------------------------------------------------



Mon, 03 Nov 1997 03:00:00 GMT
 Using Ingres on HP Workstation

When I try to use abf, qbf, isql etc from an HP workstation then I get
all the funny characters appearing where it should have drawn straight
lines. I have tried setting the TERM_INGRES to all the *.map present in
$II_SYSTEM/ingres/files but still I am not able to get rid of this
problem.
<<<

Firstly I should say that I  am not an expert in this area, so someone can correct
me if I'm wrong and I probably won't have the complete answer, but I seem to recall
I had a problem like this once. I did something like the following:-

1. Find a terminal in the supplied termcap file that works best.
2. Copy it and then add escape sequences for the keys you want to add. You can
   use the od command or vi (vi aaa, then i for insert, then Control &
v, then hit the
   desired key, say PgUp) for this. So on the end you will add something like
   :kI=\E[6~:\  for PgUp
3. Change the mapping file you are using. To find this look for a string something
   like this in the termcap file - :mf=xterm.map:

Have a look at Appendix B and Appendix C in the 'Using Ingres Through
Forms and Menus'
manual which can help a fair bit.

Good luck.

Tony Buckley
Port of Melbourne Authority



Mon, 03 Nov 1997 03:00:00 GMT
 Using Ingres on HP Workstation
: >>>
: When I try to use abf, qbf, isql etc from an HP workstation then I get
: all the funny characters appearing where it should have drawn straight
: lines. I have tried setting the TERM_INGRES to all the *.map present in
: $II_SYSTEM/ingres/files but still I am not able to get rid of this
: problem.
: <<<

: Firstly I should say that I  am not an expert in this area, so someone
: can correct me if I'm wrong and I probably won't have the complete answer,
: but I seem to recall I had a problem like this once. I did something like
: the following:-

: 1. Find a terminal in the supplied termcap file that works best.
: 2. Copy it and then add escape sequences for the keys you want to add. You
:    can use the od command or vi (vi aaa, then i for insert, then Control &
: v, then hit the
:    desired key, say PgUp) for this. So on the end you will add something
:    like :kI=\E[6~:\  for PgUp
: 3. Change the mapping file you are using. To find this look for a string
:    something like this in the termcap file - :mf=xterm.map:

: Have a look at Appendix B and Appendix C in the 'Using Ingres Through
: Forms and Menus'
: manual which can help a fair bit.

: Good luck.

: Tony Buckley
: Port of Melbourne Authority

   This is basically correct.  Ingres delivers basic functionality
   for hp terminals, but to use the Prev(PgUp), Next(PgDn), etc, keys
   you will need to modify the termcap and keymap files. You will be
   able to map most of the hp keys.  To get the line draw stuff to
   work correctly you will need to make sure that you are using the
   correct font set. Similar to this: hpterm -fn hp8.8x16 -fb line.8x16.
   Check your font directory to see what line draw sets are available.
   If need be I could post some hp termcap and keymap files that I
   use that you could modify for your own use.  By using the right
   TERM_INGRES setting you can even get color, but Ingres doesn't
   handle color on hp terminals very well.

   Dennis Roesler

   P.S. Tony, I just visited your fair city a couple of weeks ago.
        Lovely city.



Tue, 04 Nov 1997 03:00:00 GMT
 Using Ingres on HP Workstation
: >>>
: When I try to use abf, qbf, isql etc from an HP workstation then I get
: all the funny characters appearing where it should have drawn straight
: lines. I have tried setting the TERM_INGRES to all the *.map present in
: $II_SYSTEM/ingres/files but still I am not able to get rid of this
: problem.
: <<<

This is what I do:

Use an xterm with the font vtsingle which contains the relevant line
drawing character set. e.g.

  xterm -fn vtsingle -e isql dbname &

I also use the following termcap entry -

  vttim:\
        :mf=vttim.map:\
        :yn#80:yo#132:yp=\E[%i%2;%2H:yq=\E[%i%2;%3H:yr=\E[?3l:ys=\E[?3h:\
        :Ge=ansi:Gp=ansi:Gh:Go:Gw:GC#68:GR#23:\
        :co#80:li#24:cl=\E[;H\E[2J:bs:cm=\E[%i%2;%2H:nd=\E[C:up=\E[A:\
        :ce=\E[K:cd=\E[J:us=\E[4m:ue=\E[m:\
        :is=\E>\E[?3l\E[?4l\E[?7l\E[?8h:ks=\E[?1h\E=:ke=\E[?1l\E>:\
        :ku=\EOA:kd=\EOB:kr=\EOC:kl=\EOD:vs=\E[?7l:ve=\E[?7h:\

        :qi=v:qj=w:qk=x:ls=\016:le=\017:cs=\E[%2;%2r:\
        :bl=\E[5m:be=\E[m:bo=\E[1m:eb=\E[m:rv=\E[7m:re=\E[m:ea=\E[m:\
        :za=\E[1;4;5;7m:zb=\E[1;4m:zc=\E[1;5m:zd=\E[1;7m:\
        :ze=\E[4;5m:zf=\E[4;7m:zg=\E[5;7m:zh=\E[1;4;5m:\
        :zi=\E[4;5;7m:zj=\E[1;5;7m:zk=\E[1;4;7m:es=\E[?7h:\
        :ky:k0=\E[11~:k1=\E[12~:k2=\E[13~:k3=\E[14~:sr=\EM:\
        :k4=\EOw:k5=\EOx:k6=\EOy:k7=\EOm:k8=\EOt:k9=\EOu:kA=\EOv:\
        :kB=\EOl:kC=\EOq:kD=\EOr:kE=\EOs:kF=\EOp:kG=\EOn:kH=\EOM:kn#18:

vttim.map is a copy of vt100f.map, except for the following:

  /* Menu Key */
        menu = pf1 (F1)

  /* Help facility */
        frskey1 = pf2 (F2)

  /* Exit the system */
        frskey2 = pf4 (F4)

  /* End current screen and return to previous screen */
        frskey3 = pf3 (F3)

..

finally, set the following env. variables:

TERM=vt100
TERM_INGRES=vttim

Tim.

--
                  ____  
 .   ,      ^ \|'/    \
  \ o  \!/ ,'  . |    |
|\~~~~~~~~~~~~~~~~|\  |
||   Tim Holmes   ||----------------------------------------------------+

||   Consultant   ||----------------------------------------------------+
\-================-/  |
 _^^^^^^^^^^^^^^^^_   |
 ( ************** )<--+



Fri, 07 Nov 1997 03:00:00 GMT
 Using Ingres on HP Workstation
HI,
re your use of the workstation - I am asuming you have xterm capabilities.

All things are unsupported to a degree - including the following, though
whenever I have made a prsentation on HP UX workstations the following
gives great results:

From within your xterm window, fire up Ingres's unsupported ( ??) window
view software.

ie:

wview -fn 12x24 -fb 12x24 -ms blue -cr blue


wview -h for all the choices ).

This should open up a new wview session.

swap user ( su ) to the account you want to use if not Ingres and rerun
your .login or .profile script - whichever applies to your shell
environment.

set the following environment variables using the appropriate shell
command.
eg:

setenv TERM_INGRES wviewf
setenv TERM hp2392

(Yes - that does say wviewf )

You should now have a pretty decent window with mouse control ( click on
function keys, scroll table fields, "tab" to input fields etc ) as well as
function key control ( F1 - F12 ? ).

Hints:
CTRL Z wipes out the session - issue the command FG to bring it back
Your mouse must remain in the window for it to be active
Watch out for caps lock and function keys
play with the colors
play with the fonts
placing an ampersand & at the end of the wview command string should allow
more than one window to be spawned from the controlling session
fonts should be in the /usr/lib/X11/fonts directory - not all work though
9x15 is OK

Cheers,

Peter Barzen
CSP Inc / PROPHECY

This is not my real signature



Fri, 07 Nov 1997 03:00:00 GMT
 Using Ingres on HP Workstation
Yes, we have a similar setup.  I edited $II_SYSTEM/ingres/files/termcap and
created a map file.  It still has some problems, but maybe this will get you
started.  I think it's really lame that CA distributes this product with such
poor support for the HP 700 series terminals.  I'd recommend not using hpterm
but use xterm instead, for starters, and obtain a 101-key keyboard instead of
the lame HP keyboard that only has 8 function keys.  I'd appreciate hearing
an explanation of this situation from someone at CA, especially since I've
spent a lot of time trying to get their software to function properly on our
equipment.  Anyway, enough pouting; here is my hp70092.map and my termcap:

/* FRS mapping file for hp70092 or hp70094 with Function Keys.      */
/* Modified so more function keys work  */                                          

/* Move left one space within a field */
    leftchar = pf19 (Left Arrow)

/* Move right one space within a field */
    rightchar = pf18 (Right Arrow)

/* Move down one line */
    downline = pf17 (Down Arrow)

/* Move up one line */
    upline = pf16 (Up Arrow)

/* Move cursor to previous field */
        previousfield = pf20 (<Shift> Tab)

/* Menu Key */
        menu = pf1 (f1)

/* Help facility */
        frskey1 = pf2 (f2)

/* Quit from program */
        frskey2        = pf4 (f4)

/* End current screen and return to previous screen */
        frskey3        = pf3 (f3)

/* Go or execute function */
        frskey4 = pf8 (f8)

/* Put cursor on top of form or table field */
        frskey5 = pf15 (Prev)

/* Put cursor on bottom of form or table field */
        frskey6 = pf14 (Next)

/* Find next occurrence of string in this column of table field */
        frskey7        = controlF (^F)

/* Save object in database */
        frskey8 = pf5 (f5)

/* Forget and Undo */
        frskey9 = pf6 (f6)

/* Previous screen or set of rows in table field */
        scrolldown = pf13 (Scroll Down)

/* Next screen or set of rows in table field */
        scrollup = pf12 (Scroll Up)

/* Move cursor to next field */
        nextfield = controlI (Tab)

/* Move up one word within field */
        nextword = controlT (^T)

/* Move back one word within field */
        previousword = controlR (^R)

/* Switch between insert and overstrike mode */
        mode = pf11 (Insert Char)

/* Redraw the screen */
        redraw = controlW (^W)

/* Delete the character under the cursor */
        deletechar = pf10 (Delete Char)

/* Delete character immediately to left of cursor */
        rubout = controlH (Backspace)

/* Start default text editor on field */
        editor = controlV (^V)

/* Move to first column of next row in table field */
        newrow = controlN (^N)

/* Clear out the rest of the field */
        clear = pf9 (Clear Line)

/* Clear out the rest of the field, and move to next field */
        clearrest = controlM (Return)

/* Auto-duplicate value while in fill mode */
        duplicate = controlD (^D)

/* Scroll left on a form */
scrollleft = controlO (^O)

/* Scroll right on a form */
scrollright = controlU (^U)

/* Write current screen to file */
    printscreen = controlZ (^Z)

hpterm|hp|HP700 series, 80 column mode: \
#   basic stuff                                                \
    :is=\E&f0a1k0d2L\Ep\E&f0a2k0d2L\Eq\E&f0a3k0d2L\Er\E&f0a4k0d2L\Es\
        \E&f0a5k0d2L\Et\E&f0a6k0d2L\Eu\E&f0a7k0d2L\Ev\E&f0a8k0d2L\Ew\

    :co#80:li#24:bs:am: \
    :cd=\EJ:ce=\EK:cl=\EH\EJ: \
    :cm=\E&a%r%dc%dY:nd=\EC: \
    :mf=hp70092.map: \
    :vs=100\E&s1A:ve=\E&s0A: \
#   line drawing stuff                                         \
    :ld=:ls=^n:le=^o: \
    :qa=/:qb=\\:qc=/:qd=\\:qe=+:qf=-:  \
    :qg=+:qh=+:qi=+:qj=+:qk=|: \
#   video enhancement stuff                                    \


    :zd=\E&dJ:ze=\E&dE:zf=\E&dF:zg=\E&dC:zh=\E&dM:zi=\E&dG:  \

#   color (by dudley) \
    :ya=\E&v0S:yb=\E&v1S:yc=\E&v2S:yd=\E&v3S:ye=\E&v4S: \
    :yf=\E&v5S:yg=\E&v6S:yh=\E&v7S: \
#   function keys stuff                                        \
    :ky:kn#20: \
    :k0=\Ep:k1=\Eq:k2=\Er:k3=\Es:k4=\Et:k5=\Eu:k6=\Ev:k7=\Ew: \
    :k8=\EK:k9=\EP:kA=\EQ:kB=\ES:kC=\ET:kD=\EU:kE=\EV: \
    :kF=\EA:kG=\EB:kH=\EC:kI=\ED:kJ=\Ei:\
#   arrow keys stuff                                           \
    :ku=\EA:kd=\EB:kr=\EC:kl=\ED: \
#   miscellaneous stuff                                        \
    :bt=\Ei:do=\EB:up=\EA:xs:

--

California Cooperative Snow Surveys
Department of Water Resources           (916) 653-0881



Tue, 11 Nov 1997 03:00:00 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. Using Ingres Forms with Sun Workstations

2. using HP and AIX Xterminals with Ingres...

3. Using Java with Ingres II on HP UX

4. HP problem and Ingres bug 99377 for ingresII on HP-UX 11

5. PC en emulation de terminaux hp 700/60 sur serveur hp unix avec applicatif ABF INGRES

6. Ingres installation problem - Ingres II 2.5 on hp-ux 11

7. 18004-Nationwide-HP-HP-9000-HP-UX-HP Speedware-PowerHouse-Amisys-PowerBuilder-Vi

8. 18004-Nationwide-HP-HP-9000-HP-UX-HP Speedware-PowerHouse-Amisys-PowerBuilder-Vi

9. HP Workstation 9000

10. HP Workstation 9000

11. HP Workstation 9000

12. HP Workstation


 
Powered by phpBB® Forum Software