Retrieves the version number and additional status information of the ACDB.
querydb [--database_type sybase_ase | sybase_asa | oracle] [--jdbc_admin_username user_name] [--jdbc_admin_password password] [--jdbc_driver driverName] [--jdbc_url jdbcURL]
Argument |
Datatype |
Default value |
Description |
|---|---|---|---|
database_type |
choice |
sybase_ase |
The database type. This value is used to determine the default values for the jdbc_url and jdbc_driver arguments.Acceptable values are:
|
jdbc_admin_username |
string |
sa |
The user name for connecting to the database for administrative purposes (creating databases, tables, and so on). |
jdbc_admin_password |
string |
The password for the user specified by jdbc_admin_username. |
|
jdbc_driver |
Java class name |
Depends on the value of database_type; for sybase_ase: com.sybase.jdbc2.jdbc.SybDriver |
The JDBC driver to use when connecting to the database. |
jdbc_url |
string |
Depends on the value of database_type; for sybase_ase: jdbc:sybase:Tds:host: 5000/acdb |
The JDBC URL to use when connecting to the database. |
Return value |
Indicates |
|---|---|
0 |
The command ran successfully; the result is true/success. |
1 |
The command failed. |
2 |
The database does not exist. |
3 |
The database is not populated. Use populate_only option with createdb task. |
4 |
The database schema is old. Upgrade the database. |
This command line example retrieves the version number of the ACDB using the default values for the JDBC driver, JDBC URL, user name, and password:
securetool querydb
