solidDB Help : solidDB reference : Command line options : solidDB Data Dictionary (soldd) command line syntax
  
solidDB Data Dictionary (soldd) command line syntax
Start solidDB Data Dictionary (soldd) with the command soldd. For information about using soldd, see solidDB Data Dictionary (soldd).
The syntax for starting soldd is:
soldd [options] [network_name] username [password] [tablename]
where:
▪ network_name is the network name of a solidDB server that you are connected to, see Network listening names (Com.Listen). The given network name must be enclosed in quotation marks. Logical data source names can also be used with the solidDB tools.
If you are using soldd to connect to a solidDB grid, include grid in the network name, for example:
soldd "grid tcp myhost1 1964" dba dba
For more information, see Connecting to a grid.
▪ username is required to identify the user and to determine the authorization level of the user authorization. Without appropriate rights, command execution is denied.
▪ password is the password of the user for accessing the database. The password is mandatory, if the password is not read from a file (defined with option -x pwdfile: filename), or optional, if the password is read from a file.
▪ tablename is the name of the table for which you want to retrieve data definition statements. If no table name is given, all definitions to which the user has rights are listed.
▪ options are described in the following table:
 
Option
Description
grid
Uses the ODBC grid-aware driver to connect to a solidDB grid, see solidDB Grid overview.
-c dir
Changes working directory
-C catalog_name
Sets the default catalog from where data definitions are read from or written to
-h
-?
Displays command usage
-m
In Unicode databases (General.InternalCharEncoding=UTF8), expect the data in character and wide character data type columns to be encoded in the console locale/codepage, despite the settings in the server-side and client-side character data binding parameters.
In partial Unicode databases (General.InternalCharEncoding=Raw), expect the data in wide character data type columns to be encoded in the console locale/codepage, despite the settings in the server-side and client-side character data binding parameters. Data in character data type columns is not converted.
See Using solidDB tools with Unicode for more information.
-M locale_name
In Unicode databases (General.InternalCharEncoding=UTF8), expect the data in character and wide character data type columns to be encoded in the specified locale/codepage.
In partial Unicode databases (General.InternalCharEncoding=Raw), expect the data in wide character data type columns to be encoded in the specified locale/codepage. Data in character data type columns is not converted.
The format of locale_name depends on the operating system.
For example, in Linux environments, the locale name for the code page GB18030 in Chinese/China is zh_CN.gb18030.
In Windows environments, the locale name for Latin1 code page in Finnish/Finland is fin_fin.1252.
See Using solidDB tools with Unicode for more information.
-o filename
Writes data definitions to this file
-O filename
Appends data definitions to this file
-p
Preserves case of schema and table names
-s schema_name
Lists definitions from this schema only
-u
▪ In Unicode databases (General.InternalCharEncoding=UTF8), expect the data in character and wide character data type columns to be encoded in UTF-8.
▪ In partial Unicode databases (General.InternalCharEncoding=Raw), expect the data in wide character data type columns to be encoded in UTF-8. Data in character data type columns is not converted.
See Using solidDB tools with Unicode for more information.
-x tableonly
Lists table definitions only
-x indexonly
Lists index definitions only
-x viewonly
Lists view definitions only
-x sequenceonly
Lists sequence definitions only
-x procedureonly
Lists procedure definitions only
-x publicationonly
Lists publication definitions only
-x eventonly
Lists event definitions only
-x triggeronly
Lists trigger definitions only
-x schemaonly
Lists schema definitions only
-x hiddennames
Lists internal constraint names only
-x pwdfile: filename
Reads password from the file
If the objectname parameter is provided with one of the -x options, the name is used to print only the definition of the named object.
The -t tablename option is still supported in order to keep old scripts valid.
Go up to
Command line options