iqdsn Database Administration Utility

The iqdsn utility is a data source utility you use for creating, changing, deleting, describing, and listing Sybase IQ ODBC data sources.

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 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 iAnywhere Solutions Oracle 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 iAnywhere Solutions Oracle driver. See MobiLink - Server Administration > MobiLink Reference > iAnywhere Solutions ODBC drivers for MobiLink > iAnywhere Solutions 12 - 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. See System Administration Guide: Volume 1 > Connection and Communication Parameters.
-ec `encryption type`	Encrypt packets sent between the client application and the server. See System Administration Guide: Volume 1 > Connection and Communication Parameters > Connection Parameters > Encryption Connection Parameter [ENC].
-o `filename`	Write output messages to the named file. By default, messages are written to the console. See System Administration Guide: Volume 1 > Connection and Communication Parameters > Connection Parameters > 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 System Administration Guide: Volume 1 > Connection and Communication Parameters > Connection Parameters > 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 System Administration Guide: Volume 1 > Connection and Communication Parameters > Connection parameters > 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 System Administration Guide: Volume 1 > Connection and Communication Parameters > Connection Parameters > LivenessTimeout Connection Parameter [LTO].
-x `list`	List network drivers to run.
-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 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

You can also change the order of options:

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

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