[sqr-users] Running SQR's from Textpad

[David Ward <wardd@mail.uww.edu>]

One option which I have found pretty slick is submitting a sqr from within 
an edit session if using Textpad(although other editors probably also have 
this capability).  It's pretty simple to setup the DOS command line, and 
you can include the DB signon stuff(instance, userid, pass), along with any 
flags you use.  You can designate a pull down menu selection or hotkey for 
different database instances.

I have a document which I created for our staff outlining the steps to set 
this up I'd be willing to share.  Contact me directly if you'd like a copy 
as an attachment.

David Ward




Hi all,
I am getting tired of typing in the database and user id in the sqr 
dialogue box every time I run my sqr to test it. I know I can append report 
parameters in the icon properties (see below). Is there any way to modify 
the icon so that it will autopopulate the database and username each time I 
double click it??
W:\UUSOFT\PSFS840\bin\sqr\DB2\BINW\sqrw.exe -Iw:\UUSOFT\PSFS840\sqr\ 
-Mc:\dragon\code\startup.cfg -fc:\temp -oc:\temp\sqr.log -s
thanks in advance,
clark 'the dragon' willis




David Ward
Technology & Information Resources
UW-Whitewater
800 W. Main St.
Whitewater, WI  53190
262-472-1039
Fax:     262-472-5733


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users