dbTalk Databases Forums  

Re: Newbie: Can't get HISTORY, EDIT or RUNCMD working

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss Re: Newbie: Can't get HISTORY, EDIT or RUNCMD working in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Derek Clarkson
 
Posts: n/a

Default Re: Newbie: Can't get HISTORY, EDIT or RUNCMD working - 08-17-2003 , 08:40 PM






Thanks, it seems we are only at fix pack 1 here (linux). ;-)

cio
Derek.



PM (pm3iinc-nospam) wrote:

Quote:
db2 => ? history
or
db2 => ? edit
Documentation reports this as a fixpack2 feature.

Verify your db2 level.
prompt>db2level
DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08012"
with level identifier "02030106".
Informational tokens are "DB2 v8.1.2.169", "s030508", "WR21318", and
FixPak

There has to be at least one command in the buffer to edit it.
db2
connect...
list tables for schema syscat
history
edit 1
...

If you're running windows, verify the editor executable is in the path.
os-prompt>start wordpad.exe
or
os-prompt>start notepad.exe

Did you use something like
db2set DB2_CLP_EDITOR=notepad.exe
If it still doesn't work, try specifying the full path.

PM

"Derek Clarkson" <dclarkson (AT) waterwerks (DOT) com.au> a �rit dans le message de
news:3f3c8407 (AT) mail (DOT) netspeed.com.au...
Hi all,
Read about these commands in the DB2 manual for editing
previously
entered
commands when in interactive mode(Db2 =>).

On our system they don't seem to exist. executing "? command" does not
list
them amongst the commands available and typing them in returns DB2
generic "can't find it" error.

Have we missed something or is something not installed ?

cio
Derek.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.