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

DBFinder · #1 (**permalink**) 10-13-11, 08:46

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

nvk@vhv · #2 (**permalink**) 10-13-11, 11:48

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

DBFinder · #3 (**permalink**) 10-13-11, 20:34

Great nvk !!

UltraEdit makes sense. Worth the price.

I am grateful to you for the info.

Regards
DBFinder

Marcus_A · #4 (**permalink**) 10-13-11, 20:43

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.

DBFinder · #5 (**permalink**) 10-13-11, 21:02

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

dr_te_z · #6 (**permalink**) 10-14-11, 01:18

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

DBFinder · #7 (**permalink**) 10-14-11, 02:44

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

dr_te_z · #8 (**permalink**) 10-14-11, 04:07

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!

DBFinder · #9 (**permalink**) 10-14-11, 04:12

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

db2girl · #10 (**permalink**) 10-14-11, 08:20

What's wrong with using putty + vi/vim for AIX files?

DB_N00b · #11 (**permalink**) 10-14-11, 10:24

WinSCP und VI! :-)

DBFinder · #12 (**permalink**) 10-14-11, 10:26

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

DBFinder · #13 (**permalink**) 10-14-11, 10:29

Quote:

Originally Posted by DB_N00b

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

dr_te_z · #14 (**permalink**) 02-01-12, 09:39

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?

Internet Services

Web Development

Digital Marketing

Consumer Tech