Hi
I am in DB2 command prompt in Unix written some Sql. Now i want to modify this Sql using "vi" is there any way to take sql command (or this buffer) in the "vi" modify and run it again without exiting isql prompt.
like we have in sybase and oracle too.

Thanks
Ashok

Copy it into a file and do db2 -vtf filename will run it and this way you can edit it as much as you want

Hi
Copy to a file i know but i am looking for something like Sybase has and you don't need to exit the sql session.

Thanks.

Can't you open anther session to do the editing?

in db2 v8.1.2

there are several clp commands for this -

edit - edit the last sql stmt
history - show history of sql/db2 commands
runcmd - run sql/cmd # from history output