The usage of
stilts <stilts-flags> sqlclient db=<jdbc-url> user=<value> password=<value> sql=<sql> ofmt=<out-format>If you don't have the
stiltsscript installed, write "
java -jar stilts.jar" instead of "
stilts" - see Section 3. The available
<stilts-flags>are listed in Section 2.1. For programmatic invocation, the Task class for this command is
Parameter values are assigned on the command line as explained in Section 2.3. They are as follows:
db = <jdbc-url>(Connection)
jdbc:<subprotocol>:<subname>- the details are database- and driver-dependent. Consult Sun's JDBC documentation and that for the particular JDBC driver you are using for details. Note that the relevant driver class will need to be on your classpath and referenced in the
jdbc.driverssystem property as well for the connection to be made.
ofmt = <out-format>(String)
(auto)" (the default), then the output filename will be examined to try to guess what sort of file is required usually by looking at the extension. If it's not obvious from the filename what output format is intended, an error will result.
password = <value>(String)
sql = <sql>(String)
user = <value>(String)