We have an ad-hoc query tool for the Web that was built to work with SYBASE
databases. The CGI scripts just build some SQL and then run it in a 'batch'
mode via SYBASE's ISQL utility.
I'm wondering whether we can do the same thing with SqlPlus. With ISQL you can
actually invoke it from a command line like this:
ISQL -SSYBASE -Uxxxx -Pxxxx -i input.txt -o output.txt
This takes the SQL that's in 'input.txt' and runs it, putting the output in
'output.txt'. (then the CGI script just reads the output file)
Also - we often have several of these ISQL sessions running concurrently
(using different UserIDs). Our platform is OS/2 and I know that SQL*Plus is
available for OS/2.
Bob Malos - Univ of Minnesota - malos001_at_tc.umn.edu