Sybase Adaptive Server Anywhere - The Data Source Utility

Chapter 4 Database Administration Utilities
89
The Data Source utility
dbdsn [ modifier-switches ]
{ –l[ u ] [ s ]
| –d[ u | s ]
dsn
| –g[ u | s ] dsn
| –w[ u | s ] dsn [ details-switches;… ]
| –cl }
Major switch Description
–l[ u ] [ s ] List all user or list all system data sources. You can
also list both user and system data sources. User data
sources is the default.
–d[ u | s ] dsn Delete the named user or system data source. User
data sources is the default.
–g[ u | s ] dsn List (get) details of the named user or system data
source. User data sources is the default.
–w[ u | s ] dsn [ details-
switches ]
Create (write) a user or system data source
definition. User data sources is the default.
–cl
List available connection parameters
Modifier switch Description
–b
Brief. Print connection string for the data source
–q
Quiet. Do not print banner
–v
Verbose. Print connection parameters in tabular form
–y
Delete or overwrite data source without confirmation
Details-switch Description
–c "keyword=value;…" Supply database connection parameters
–ec
Encrypt all network packets
–o filename Write client message to filename
–p size Set maximum network packet size
–r
Disable multiple record fetching
–tl seconds Client liveness timeout period
–x list List network drivers to run
–z
Display debugging information
server-name Connect to named database server
Syntax
Parameters