The Data Source utility
90
"Working with ODBC data sources" on page 49 of the book ASA User’s
Guide
"Using ODBC data sources on UNIX" on page 57 of the book ASA User’s
Guide
The Data Source utility is a cross-platform alternative to the ODBC
Administrator for creating, changing, and deleting Adaptive Server
Anywhere ODBC data sources. On Windows operating systems, the data
sources are held in the registry. On UNIX operating systems, the data
sources are held in the
.odbc.ini
file. The utility is useful for batch operations.
The modifier switches can occur before or after the major switch
specification. The order makes a difference only when a connection
parameter value is specified more than once. In such a case, the last value
specified is used.
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 switches. You can modify the switch using the u (user) or s (system)
specifiers. The default specifier is
u.
Delete the named data source (–d ) Deletes the named data source.
You can modify the switch 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 data source. You can modify the format of the output using the
–b
or –v switches. You can modify the switch 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 switch
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 switch
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.
Print connection parameters in tabular form (–v) Format the output of
the list over several lines, as a table.
See also
Description
Major switches
Modifier switches
To Next Page
Loading...