iqdsn Database Administration Utility

The iqdsn utility is a cross-platform alternative to the ODBC Administrator.

On Windows operating systems, data sources are held in the Registry. On UNIX operating systems, data sources are held in the .odbc.ini file. Use the iqdsn utility for batch operations.

Syntax

iqdsn [ modifier-options ]
{ -l 
| -d dsn 
| -g dsn 
| -w dsn [details-options;...] 
| -cl }

Parameters

These tables list the available options for the iqdsn utility.

iqdsn Major Options
Major Option	Description
-l	Lists the available SAP Sybase IQ ODBC data sources. You can modify the list format using the -b or -v options.
-d `dsn`	Deletes the named data source. If you supply -y, any existing data source is overwritten without confirmation.
-g `dsn`	List the definition of the named data source. You can modify the format of the output using the -b or -v option.
-w `dsn` [ `details-options` ]	Creates a new data source, or overwrites one if one of the same name exists. If you supply -y, any existing data source is overwritten without confirmation.
-cl	This convenience option lists the connection parameters supported by the iqdsn utility.

iqdsn Modifier-Options
Modifier option	Description
-b	Brief. Format the output of the list as a single line connection string.
-or	Creates a data source for the SQL Anywhere 16 – Oracle ODBC driver when specified with the -c option. For example: dbdsn -w MyOracleDSN -or -c Userid=DBA;Password=sql;SID=abcd;ArraySize=500;ProcResults=y You can specify the -cl option with the -or option to obtain a list of the connection parameters for the SQL Anywhere 16 Oracle ODBC driver.
-q	Quiet. Do not print the informational banner.
-v	Verbose. Format the output of the list over several lines, as a table.
-va	Verbose All. Print connection parameters in same format as -v, but also include other hidden parameters. Use this option to display ODBC driver qualifier needed for remote data access on those UNIX platforms that support such access, or for some third-party driver managers.
-y	Automatically delete or overwrite each file without prompting you for confirmation.

iqdsn Details-Options
Details Option	Description
-c "keyword=`value`;..."	Specify connection parameters as a connection string. The connection string consists of a set of parameters, separated by semicolons.
-ec `encryption type`	Encrypt packets sent between the client application and the server. See Encryption Connection Parameter [ENC].
-o `filename`	Write output messages to the named file. By default, messages are written to the console. See LogFile Connection Parameter [LOG].
-p `size`	Set the maximum packet size for network communications, in bytes. The value must be greater than 500, and less than 16000. The default setting is 1460. See CommBufferSize Connection Parameter [CBSize].
-r	Disable multiple record fetching. By default, when the database server gets a simple fetch request, the application asks for extra rows. Use the -r option to disable this behavior. See DisableMultiRowFetch Connection Parameter [DMRF].
-tl `seconds`	Client liveness timeout period. Terminates connections when they are no longer intact. The value is in seconds. The default is the server setting, which in turn has a default of 120 seconds. See LivenessTimeout Connection Parameter [LTO].
-z	Provide diagnostic information on communications links on startup.
`server-name`	Connect to the named database server. Only the first 40 characters are used.

Usage

The iqdsn modifier options can occur before or after the major option specification. The order makes a difference only if you specify a connection parameter value more than once. In such a case, the last value specified is used.

Examples

This example writes a definition of the data source newdsn and does not prompt for confirmation if the data source already exists.

iqdsn -y tcpip -w newdsn -c "uid=DBA;pwd=sql" -v

Lists all known user data sources, one data source name per line:

iqdsn -l

Lists all data sources along with their associated connection string:

iqdsn -l -b

Reports the connection string for user data source MyDSN:

iqdsn -g MyDSN

Deletes the data source BadDSN, but first list the connection parameters for BadDSN and prompt for confirmation:

iqdsn -d BadDSN -v

Deletes the data source BadDSN without prompting for confirmation.

iqdsn -d BadDSN -y

Creates a data source named NewDSN for the database server MyServer:

iqdsn -w NewDSN -c "uid=DBA;pwd=sql;eng=bar"

If a NewDSN already exists, the utility asks you if you want to overwrite it.

The following example connects to the sample database server. The server name sample overrides the previous specified value of MyServer:

iqdsn -w NewDSN -c "uid=DBA;pwd=sql;eng=MyServer" sample

Lists all connection parameter names and their aliases:

iqdsn -cl