ASA Database Administration Guide
Database Administration Utilities
The Data Source utility
Managing ODBC data sources using the dbdsn command-line utility
When you use the Data Source utility, you can choose from major options, modifier options, and details options.
List defined data sources (-l) Lists the available Adaptive Server Anywhere ODBC data sources. You can modify the list format using the -b or -v options. You can modify the option using the u (user) or s (system) specifiers. The default specifier is u.
Delete the named data source (-d) Deletes the named Adaptive Server Anywhere data source. You can modify the option using the u (user) or s (system) specifiers. U is the default specifier. If you supply -y, any existing data source is overwritten without confirmation.
List (get) details of the named data source (-g) List the definition of the named Adaptive Server Anywhere data source. You can modify the format of the output using the -b or -v options. You can modify the option using the u (user) or s (system) specifiers. U is the default specifier.
Create (write) a data source definition (-w) Creates a new data source, or overwrites one if one of the same name exists. You can modify the option using the u (user) or s (system) specifiers. U is the default specifier. If you supply -y, any existing data source is overwritten without confirmation.
List available connection parameters (-cl) This convenience option lists the connection parameters supported by the dbdsn utility.
Print connection string for the data source (-b) Format the output of the list as a single line connection string.
Do not print banner (-q) Suppress the informational banner.
Do not print banner or titles (-qq) Suppress both the informational banner and titles. This option can only be used with the -l and the -cl options.
Print connection parameters in tabular form (-v) Format the output of the list over several lines, as a table.
Delete or overwrite data source without confirmation (-y) Automatically delete or overwrite each data source without prompting you for confirmation.
Absolute filenames (-cw) Ensure that the DBF parameter (specified using -c) is an absolute filename. If the value of DBF is not an absolute filename, dbdsn will prepend the current working directory (CWD). This option is useful because some operating systems (Win 9x) do not have CWD information readily available in batch files.
Connection parameters (-c) Specify connection parameters as a connection string.
For more information, see Connection parameters.
The remainder of the details options are supplied for users familiar with the dbcli6.exe utility shipped with Adaptive Server Anywhere version 6.
Encrypt network packets (-ec) Encrypt packets sent between the client application and the server.
For more information, see Encryption connection parameter [ENC].
Log output messages to file (-o) Write output messages to the named file. By default, messages are written to the console.
For more information, see Logfile connection parameter [LOG].
Operate quietly (-q) Do not display output messages. This option is available only when you run this utility from the command prompt.
Set maximum network packet size (-p) The maximum packet size for network communications, in bytes. The value must be greater than 300, and less than 16000. The default setting is 1460.
For more information, see CommBufferSize connection parameter [CBSIZE].
Disable multiple-record fetching (-r) By default, when the database server gets a simple fetch request, the application asks for extra rows. You can disable this behavior using this option.
For more information, see DisableMultiRowFetch connection parameter [DMRF].
Set client liveness timeout (-tl) Terminates connections when they are no longer intact. The value is in seconds.
The default is server setting, which in turn has a default value of 120 seconds.
For more information, see LivenessTimeout connection parameter [LTO].
Set communications links (-x) A comma separated list of network drivers to run.
For more information, see CommLinks connection parameter [LINKS].
Display debugging information (-z) Provide diagnostic information on communications links on startup.
Server name Connect to the named server. Only the first 40 characters are used.
For more information, see The Database Server.