DSN aliases in CLPPlus
The CLPPlus interface supports connecting to DSN aliases defined in the IBM® data server driver configuration file . Before this support, only interactive connects were allowed in the CLPPlus interface.
The IBM data server driver configuration file is an XML file that contains a list of DSN aliases and their properties. It is used to store connection details in one place. The CLPPlus interface can use that information to automatically connect to a data source instead of interactively asking for all the connection details on every connect attempt.
If a configuration file is found and it is readable, the CLPPlus interface uses it on the subsequent connect attempts.
A user who attempts a connect is asked for a database name. That database name is treated as a DSN alias and searched in the configuration file. If that DSN alias is found, the connection attributes are read and a password is requested to complete the connection. If the DSN alias is not found, then the host name, port number, user name, and password are requested interactively to go with the original database name, and all information gathered is used to attempt a connection.
You can specify whether the ExtendedIndicators property is enabled or disabled during a database connection. By default, this property is disabled. For more information, see the Related reference.
Examples
<configuration>
<dsncollection>
<dsn alias="S" name="SAMPLE" host="9.121.221.159" port="50000">
<parameter name="ExtendedIndicators" value="0"/>
</dsn>
</dsncollection>
<databases>
<database name="SAMPLE" host="9.121.221.159" port="50000">
<parameter name="UserID" value="john"/>
</database>
</databases>
</configuration>
The following example shows a connection established with the contents of the IBM data server driver configuration file.
C:\>clpplus
CLPPlus: Version 1.1
Copyright (c) 2009, IBM CORPORATION. All rights reserved.
SQL> connect
Enter DATABASE NAME [SAMPLE]: S
Enter ID [john] :
Enter Password: ********
SQL>
SQL> connect
Enter DATABASE NAME [SAMPLE]: sample
Enter HOSTNAME [localhost]:
Enter PORT [50000]:
Enter ID : john
Enter Password: ********
SQL>
Since "sample" is not found
as a DSN alias in the configuration file, the remaining values are
requested interactively by the CLPPlus interface and then a connection
attempt is made.