Problem using UltraEdit as the editor for DB2/UDB CLP

Problem using UltraEdit as the editor for DB2/UDB CLP

1

    Nov 16, 2004#1

    I was trying to configure UltraEdit as the default editor for the IBM DB2 UDB Command Line Processor utility (CLP) and cold not get it to work properly. The editor starts uip OK with the proper text to edit, but when the save occurs, the changed results are not returned to the CLP. The Windows notepad works OK in this regard.

    Does anyone know what is going wrong?
    John Thompson
    President, JCAT Associates Inc.
    London, Canada
    1
    NewbieNewbie
    1

      Nov 18, 2004#2

      I am trying to use UE with ISPF Workstation Agend (WSA) and I get the same thing. I make a change and it is not saved back to the mainframe. From past experience with trying editors with WSA I think UE is not saving the file in place. That is it seems to be saving the change to a copy. Notepad and VIM for example work with WSA, but Compuware's old PREDITOR doesn't work. I have tried changing UE options including the advanced option of copying for backup instead of renaming and that didn't work. I also tried turning off backup and that didn't work. I really like the looks of UE so far, but if I can't use it with WSA I won't be buying it.
      1
      NewbieNewbie
      1

        Oct 19, 2006#3

        Hi forumers,

        I'm replying to a very old thread here, but I just now got a "Run in DB2" tool working on UE 12.10, and thought I'd share the setup for other DB2 coders using UltraEdit.

        Tool Configuration:

        Command:

        Menu Item Name: Run in DB2
        Command Line: C:\PROGRA~1\IBM\SQLLIB\BIN\DB2CMD.exe -w -c -i DB2SETCP.BAT "DB2.EXE -tvf %F"
        Working Directory: C:\Program Files\IBM\SQLLIB\BIN\
        Toolbar bitmap/icon: C:\Program Files\IBM\SQLLIB\BIN\db2.ico

        Options:

        Dos Program - selected
        (Save options at your pleasure)

        Output:

        Show DOS Box - NOT selected
        Capture Output - selected
        Command Output: Create New File (or as you please)
        Replace selected text with: No Replace

        The trick was getting the command switches and quotation marks right in the command line. It took me about half an hour, but it works great now.

        Best,
        Pete K.