IBM's DB2 has a command line processing mode that appears to work from a DOS or CMD prompt. The environment is initiated through clicking on an icon which seems to run a batch file. The batch file starts an exe and maybe calls another batch file. One is then presented with a command prompt. From there you can enter db2 commands by prefacing them with "db2" like this:
db2 select * from mytable
Seems to me like it ought to be possible to substitute TextPad for this process. In other words, enter my SQL command in one textpad window then click a button or menu item or some such and have textpad send the command to db2 and open a second window for the return. Just like it does now for java. Only thing is I'm not smart enought to figure out how to set it up. Has anybody done this? If not, does anybody have some suggestions how I might go about it?
Thanks.
Randy