how use 'VI' in db2 on UNIX

[udb2db2]

I want to use 'vi' editor to edit my commands once I got into db2 CLP using 'db2'.

!vi will just open editor
but I need to see whatever command in buffer so I can make modifications like typo.
In oracle we can say list OR l2 to goto 2'd line (ln= n'th line) in buffer.
Is there anything available ??
Thanks in advance.

 

[gregsimpson]

udb2db2,

I don't think db2 offers the functionality which UNIX does at the clp. I usually create a file using vi and run it through db2 afterwards.

Cheers
Greg

 

[udb2db2]

Thanks!!!

 

[gregsimpson]

Don't thank me, thank IBM.

Cheers
Greg