topic Re: Backspace key does not work in sqlplus. in Operating System - HP-UX

Backspace key does not work in sqlplus.

Jack C. Mahaffey — Mon, 27 Oct 2003 12:02:35 GMT

Any ideas why the backspace will not work in sqlplus or svrmgrl?

thanks....

Re: Backspace key does not work in sqlplus.

Steven E. Protter — Mon, 27 Oct 2003 12:07:03 GMT

This is a terminal type issue.

echo $TERM

stty -a and see if you have done anything special with the backspace key.

Attaching mine as a reference. My backspace key does work in sqlplus.

SEP

Re: Backspace key does not work in sqlplus.

A. Clay Stephenson — Mon, 27 Oct 2003 12:09:01 GMT

There is nothing special about sqlplus or svrmgrl; they simply use the erase key as defined by your TERM setting. Do a stty -a (as whatever user is actually running sqlplus) and note the 'erase=' value. You thgen need to make certain that your terminal (or terminal emulator) is indeed generating that key OR use the stty command to define a matcvhing erase character.

Re: Backspace key does not work in sqlplus.

Umapathy S — Mon, 27 Oct 2003 12:09:26 GMT

Jack,
Mostly term problems. try stty erase ^? before opening sqlplus

HTH,
Umapathy

Re: Backspace key does not work in sqlplus.

Bill Hassell — Mon, 27 Oct 2003 12:44:56 GMT

If you are not using a 'real' terminal but an emulator, most likely it is a VT100 lookalike, perhaps supplied with an Xwindow package, and many of these programs default to VMS mode for backspace which means the backspace key on the keyboard transmits the DEL character. If stty -a shows that erase = ^H then configure your terminal emulator to map backspace = backspace rather than backspace = deleteKey.

Re: Backspace key does not work in sqlplus.

Jack C. Mahaffey — Mon, 27 Oct 2003 13:04:45 GMT

Thanks all. My .profile was setting erase to ^H

jack...

Re: Backspace key does not work in sqlplus.

Jack C. Mahaffey — Mon, 27 Oct 2003 13:05:26 GMT

Typo in last response. My .profile was setting erase to ^?

Re: Backspace key does not work in sqlplus.

Bill Hassell — Mon, 27 Oct 2003 20:20:18 GMT

FYI: ^? is the DEL (delete) key.