Professional Web Applications Themes

Xemacs & DB2 CLP (W2K) - IBM DB2

Having found and followed the excellent instructions in http://www7b.software.ibm.com/dmdd/library/techarticle/0206mathew/0206mathew.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 ...

Sponsored Links
  1. #1

    Default Xemacs & DB2 CLP (W2K)

    Having found and followed the excellent instructions in

    http://www7b.software.ibm.com/dmdd/library/techarticle/0206mathew/0206mathew.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


    Sponsored Links
    Bruce Guest

  2. #2

    Default Re: Xemacs & DB2 CLP (W2K)

    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" <netcomuk.metoo.co.uk> wrote in message
    news:blii5i$rd3$1$demon.co.uk... 
    http://www7b.software.ibm.com/dmdd/library/techarticle/0206mathew/0206mathew.html 
    way 


    Bruce Guest

  3. #3

    Default Re: Xemacs & DB2 CLP (W2K)

    Did you use db2 -td<something>?

    Cheers
    Serge


    Serge Guest

  4. #4

    Default Re: Xemacs & DB2 CLP (W2K)

    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" <eyebeem.com> wrote in message
    news:blktv0$ec4$torolab.ibm.com... 


    Bruce Guest

  5. #5

    Default Re: Xemacs & DB2 CLP (W2K)

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

    Then use % as an end of statement delimiter.


    Serge Guest

Similar Threads

  1. Syntax Coloring Problem with Xemacs
    By Markus Jais in forum Ruby
    Replies: 2
    Last Post: October 20th, 12:45 PM
  2. Problems with ruby mode in Xemacs
    By W. Crowshaw in forum Ruby
    Replies: 3
    Last Post: October 7th, 08:08 PM
  3. perl man pages in xemacs
    By Sam in forum PERL Miscellaneous
    Replies: 2
    Last Post: September 20th, 11:42 AM
  4. Replies: 0
    Last Post: August 4th, 08:20 AM
  5. Ruby syntax-coloring in XEmacs
    By Larry Elmore in forum Ruby
    Replies: 0
    Last Post: July 21st, 01:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139