Having found and followed the excellent instructions in

http://www7b.software.ibm.com/dmdd/l...206mathew.html

I can use the CLP under Xemacs (21.4.11 and .13). However I still have a
couple of problems I would appreciate advice on:

I am getting an extra blank line after each line of output from db2.

I still can't do C-c C-r to create a reasonably complex trigger that has
statement termination characters in it. There seem to be problems with
parsing these declarations in Command Centre as well - the only reliable way
I have found to get them to work is to cut and paste into the Development
Centre or run a sql file with the -f option.

TIA,
Bruce

Scratch the second question - the old 'put a blank comment after every
embedded ;' works fine using Xemacs. I would very much appreciate a
solution to the blank lines, however! Note that these are not ^M - they
simply show up as extra lines.

"Bruce MacDonald" <brucemac@removeme.netcomuk.metoo.co.uk> wrote in message
news:blii5i$rd3$1$8300dec7@news.demon.co.uk...
> Having found and followed the excellent instructions in
>
>
http://www7b.software.ibm.com/dmdd/l...206mathew.html
>
> I can use the CLP under Xemacs (21.4.11 and .13). However I still have a
> couple of problems I would appreciate advice on:
>
> I am getting an extra blank line after each line of output from db2.
>
> I still can't do C-c C-r to create a reasonably complex trigger that has
> statement termination characters in it. There seem to be problems with
> parsing these declarations in Command Centre as well - the only reliable
way
> I have found to get them to work is to cut and paste into the Development
> Centre or run a sql file with the -f option.
>
> TIA,
> Bruce
>
>

Did you use db2 -td<something>?

Cheers
Serge

Serge,

Here are the relevant lines from my init.el:

(setq sql-db2-program "C:/Program Files/ibm/sqllib/bin/db2cmd.exe")
(setq sql-db2-options '("-c" "-i" "-w" "db2" "-tv"))

Thanks,
Bruce

"Serge Rielau" <srielau@ca.eyebeem.com> wrote in message
news:blktv0$ec4$1@hanover.torolab.ibm.com...
> Did you use db2 -td<something>?
>
> Cheers
> Serge
>
>

OK, try this:
(setq sql-db2-options '("-c" "-i" "-w" "db2" "-td% -v"))

Then use % as an end of statement delimiter.