DB2, vim, and dbext

[Dave Hughes]

Anyone else out there a regular DB2 and vim user? A while back, Lennart
pointed me in the direction of an interesting database extension plugin
for vim (dbext.vim [1]). I took it for a spin, but couldn't get it
working properly under Linux (it looked as though it would /probably/
work under Windows with vim though).

I recently decided to revisit it and dig deeper into the plugin code to
see if I could figure out what was going on. The DB2 specific chunks of
code were in need of quite a bit of work (the Linux/UNIX bits were just
broken, and there were quite a few references in the metadata retrieval
routines to deprecated views like SYSCAT.PROCEDUR ES which should point
to SYSCAT.ROUTINES since DB2 v8).

To cut a long story short, I've now got it working. Before submitting a
(rather large) patch to the author, I'd like to give it a good test
run. Anyone interested? If so, drop me a mail and I'll send along a
copy (I can either provide the patch and/or the repackaged plugin with
the patch already applied).

I'd be particularly interested if someone could test it with vim on
Windows (I wound up ripping out and replacing all the DB2 launching
code for both Windows and non-Windows platforms, but haven't had the
chance to test it on Windows yet).

[1] http://www.vim.org/scripts/script.php?script_id=356


Cheers,

Dave.

[Zbikow]

Re: DB2, vim, and dbext

On 11 Cze, 05:26, "Dave Hughes" <d...@waveform. plus.comwrote:

Anyone else out there a regular DB2 and vim user? A while back, Lennart
pointed me in the direction of an interesting database extension plugin
for vim (dbext.vim [1]). I took it for a spin, but couldn't get it
working properly under Linux (it looked as though it would /probably/
work under Windows with vim though).
>
I recently decided to revisit it and dig deeper into the plugin code to
see if I could figure out what was going on. The DB2 specific chunks of
code were in need of quite a bit of work (the Linux/UNIX bits were just
broken, and there were quite a few references in the metadata retrieval
routines to deprecated views like SYSCAT.PROCEDUR ES which should point
to SYSCAT.ROUTINES since DB2 v8).
>
To cut a long story short, I've now got it working. Before submitting a
(rather large) patch to the author, I'd like to give it a good test
run. Anyone interested? If so, drop me a mail and I'll send along a
copy (I can either provide the patch and/or the repackaged plugin with
the patch already applied).
>
I'd be particularly interested if someone could test it with vim on
Windows (I wound up ripping out and replacing all the DB2 launching
code for both Windows and non-Windows platforms, but haven't had the
chance to test it on Windows yet).
>
[1]http://www.vim.org/scripts/script.php?scri pt_id=356
>
Cheers,
>
Dave.

Dave,
Is it LUW specific or it also works for z/OS?
I remember trying the plugin once but gave up.
I wrote my own python script which executes query via ODBC and put it
on my VIM menu. Works more or less fine.
I can test the plugin on Windows provided it can connect to mainframe
(via DB2 connect i suppose).

regards
Zbikow

[Dave Hughes]

Re: DB2, vim, and dbext

Zbikow wrote:

Dave,
Is it LUW specific or it also works for z/OS?
I remember trying the plugin once but gave up.
I wrote my own python script which executes query via ODBC and put it
on my VIM menu. Works more or less fine.
I can test the plugin on Windows provided it can connect to mainframe
(via DB2 connect i suppose).

Yup, it works with a z/OS target - just tried it from my Linux box and
it worked fine.


Cheers,

Dave.

[Zbikow]

Re: DB2, vim, and dbext

Yup, it works with a z/OS target - just tried it from my Linux box and

it worked fine.
>
Cheers,
>
Dave.

Can you send me "repackaged plugin" then onto: zbikow1 (at) wp (dot)
pl. I'd like to try it.

Cheers & Thanx
Zbikow

[Ian]

Re: DB2, vim, and dbext

Dave Hughes wrote:

Anyone else out there a regular DB2 and vim user?

Real Men use Emacs (and, therefore, sql-db2).

I can prove this using the fact that DB2 still comes with elisp packages
in sqllib/bin.


:-) No flame wars, please. I use vi(m) all of the time, too.

[Dave Hughes]

Re: DB2, vim, and dbext

Ian wrote:

Dave Hughes wrote:

Anyone else out there a regular DB2 and vim user?

>
Real Men use Emacs (and, therefore, sql-db2).
>
I can prove this using the fact that DB2 still comes with elisp
packages in sqllib/bin.
>
>
:-) No flame wars, please. I use vi(m) all of the time, too.

http://xkcd.com/378/

:-)


Cheers,

Dave.

[Ian]

Re: DB2, vim, and dbext

Dave Hughes wrote:

Ian wrote:
>

>Dave Hughes wrote:

>>Anyone else out there a regular DB2 and vim user?

>Real Men use Emacs (and, therefore, sql-db2).
>>
>I can prove this using the fact that DB2 still comes with elisp
>packages in sqllib/bin.
>>
>>
>:-) No flame wars, please. I use vi(m) all of the time, too.

>

http://xkcd.com/378/

>
:-)
>

That is awesome. Best response to Emacs/VI flame bait ever. Thanks
for starting my Friday nicely. :-)