Results 1 to 14 of 14
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Which editor is good for scripts (sql,shell,bat) ?

    Hello All,

    I have been using Crimson Editor for years. It provides good functions.

    Now I think if I can find some editor which can edit remote files. Crimson does, but it requires FTP connections.

    And these days FTP previliges has to be requested explicitly. Usually SSH connection is everywhere which is not supported by crimson.


    Can some one suggest me some simple programmers' editor that supports remote editing through SSH connection ??


    My laptop is having windows 7 and the target system is AIX 5.3 with DB2 9.1.


    Regards
    DBFinder

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Hi,

    UltraEdit (UltraEdit Text Editor | UltraCompare file compare | UEStudio | UltraSentry) can use sftp. But i don't use it, so i don't know how well it works. My remote editing is ssh + vi.

    Cheers
    nvk

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Great nvk !!

    UltraEdit makes sense. Worth the price.

    I am grateful to you for the info.

    Regards
    DBFinder

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    WinSCP is free, but the default editor it uses is fairly basic (although you may be able to invoke other editors, not sure). One nice thing is that it can import all your putty connections into WinSCP without having to manually create them.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Oh Yeah, I had forgotten that.

    I was already using WinSCP till now. Now I am using UltraEdit.

    My editor ( crimson ) is simple best ; but WinSCP fails to detect that I had closed the file after completing the change. WinSCP wants me to close the editor to signal my completion of editing.

    However still, WinSCP is better than many.

    Thanks
    DBFinder

  6. #6
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Take a look at this: MobaXterm - The free multitab Unix browser for Windows
    and you'll find yourself NOT using PuTTy anymore. NOT using winSCP anymore and continue to use your own favorite editor for local & (unix)remote files.
    Back on topic: my favourite editor (besides ISPF ) is Notepad++ Home

  7. #7
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Thanks,

    MobaXterm seems promissing. I will keep trying it. I seems cygwin based.

    I still have to explore the editor interface. My goal is to have common editor for both platforms.

    Good thing !

    Regards
    DBFinder

  8. #8
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    What is this? You should be asleep right now.
    Anyhow, did you already notice how easy the X part works? Just "ssh -X -Y -l db2inst1" to your aix/linux based databaseserver and type "db2cc" and tadaa!

  9. #9
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Yes, I should be asleep now; fast asleep.

    Well as you said X part is a breeze. I need midnight commander. I will see this in a day or two.

    Quick ques : How can I grant SELECT to a new user on all database tables in one shot.
    Like assign a role so that I do not have to re-do for each new table ??


    Thanks

    DBFinder

  10. #10
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    What's wrong with using putty + vi/vim for AIX files?

  11. #11
    Join Date
    Jan 2010
    Posts
    207
    WinSCP und VI! :-)

  12. #12
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Hey Bella,

    I was wondering where were you.

    Actually, nothing wrong with it. Infact this combination is great. My friend "ROCKY" really rocks with this !!

    I have been coding with ME ( microsoft editor ) in olden (1992) days.
    In short I have seen may editors and they all have some kind of uniqueness.
    For past few years I was using crimson.
    Today I am using UltraEdit.
    My current assignment requires that I connect to multiple dev machines to complete a monitoring script and I feel with UltraEdit I am 10% faster.

    A matter suitability. Or you can say personal choice.

    Reagrds

  13. #13
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Quote Originally Posted by DB_N00b View Post
    WinSCP und VI! :-)
    WinSCP and VI is good definitely ; but as I believe currently using UltrEdit I am faster in current setup.

    Thanks for your input.

    Regards

  14. #14
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Have been playing/experimenting with mobaXterm (v4.2 already there). I found a way to access db2 using this shell instead of the db2cmd box.
    I created a script in the home dir called prepareDB2.sh
    Code:
    export PATH=${PATH}:~/drives/c/ibm/sqllib/bin/
    export DB2INSTANCE=db2
    export DB2CLP=**$$**
    db2set db2dbdft=sample
    This script must be executed like this (after chmod +x prepareDB2.sh)
    Code:
    . ./prepareDB2.sh
    and then you can type
    Code:
    db2 "select * from employee"
    Because I am bound to use the "db2set db2dbdft=sample" option the functionaly is limited to databases which you can access without specifying your userid/passwd. But the result so far is nice

    (when I try ". db2 connect to sample" (notice the 'dot space' preceding the db2 command) to prevent the subshell issue I get a strange error: bash: $'MZ\220': command not found. (almost the same as the motorcycle I used to drive many years ago (motorencyclopedie****/motorencyclopedie/mz-ts250-1/ts250-1) I know: ugly bike but that was the only thing I could afford back then))

    Can somebody smarted than me help to figure this out?
    Last edited by dr_te_z; 02-02-12 at 02:36. Reason: cannot get the url right. There should be dot nl there

Posting Permissions

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