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.PROCEDURES 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]

On 11 Cze, 05:26, "Dave Hughes" <[e-mail]:

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.PROCEDURES 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.

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]

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]

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]

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]

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]

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. :-)