Page History
...
Code Block | ||
---|---|---|
| ||
Usage: dbviscmd -connection <name> [-userid <userid>] [-password <password>]
-sql <statements> | -sqlfile <filename> [-encoding <encoding>]
[-catalog <catalog>] [-schema <schema>]
[-maxrows <max>] [-maxchars <max>]
[-stoponerror] [-stoponwarning]
[-output all | none | log | result] [-outputfile <filename>]
[-listconnections]
[-debug [-debugfile <filename>]
[-prefsdir <directory>] [-help] [-version]
[-masterpw <password>]
Options:
-connection <name> Database connection name (created with the GUI)
-userid <userid> Userid to connect as
-password <password> Password for userid
-sql <statements> One or more delimited SQL statements
-sqlfile <filename> SQL script file to execute
-encoding <encoding> Encoding for the SQL script file
-catalog <catalog> Catalog to use for unqualified identifiers
-schema <schema> Schema to use for unqualified identifiers
-maxrows <max> Maximum number of rows to display for a result set
-maxchars <max> Maximum number of characters to display for a column
-stoponerror Stop execution when getting an error
-stoponwarning Stop execution when getting a warning
-stripcomments Strip comments before sending to database. Default is
the setting made in the GUI
-output "all" (default), output both log msgs and result sets
"none", suppress both log messages and result sets
"log", output only log messages
"result", output only result sets
-outputfile <filename> Script execution output file. Default is stdout
-listconnections Lists all database connections
-debug Write debug messages
-debugfile <filename> File for debug messages. Default is stderr
-prefsdir <directory> Use an alternate user preferences directory
-masterpw <password> Master Password for encrypted database passwords
-help Display this help
-version Show version info |
...
Overview
Content Tools