To configure a DirectConnect for z/OS data source
Start the ODBC Administrator by selecting the TDS icon from the Windows control panel.
Do one of the following:
If you are configuring an existing data source, select the source name and choose OK.
If you are configuring a new data source, choose Add to view the list of installed drivers, then select DirectConnect and choose OK.
Specify values for the data source using the information in the following table.
Property |
Description |
---|---|
DataSourceName |
A string that identifies this DirectConnect data source configuration in the ODBC.ini file. Examples include “Accounting” or “Sys11-Serv1.” |
Description |
An optional long description of a data source name. Examples include “My Accounting Database” or “DB2 via region DWS1.” |
ServerName |
The name of the DirectConnect server. |
Specify values for any optional properties that you require. The properties are listed in the following table.
Property |
Description |
---|---|
ServerList |
The list of servers that appear in the logon dialog box. Use commas to separate the server names. |
DatabaseName |
The name of the database to which you want to connect by default. If you do not specify a value, the default is the database defined for each user. |
DatabaseList |
The databases that appear in the logon dialog box. Use commas to separate the database names. |
DefaultLogonID |
The default logon ID used to connect to DB2. This ID is case sensitive. A logon ID is required only if security is enabled for the database to which you are connecting. Your ODBC application can override this value, or you can override this value in the logon dialog box or the connection string. |
InterfacesFile |
The path name of the interfaces file. The default is the normal Sybase interfaces file. |
Initialization String |
A string of commands that execute when the data source connection initializes. Use semicolons to separate multiple commands. |
ModifySQL Statement |
An instruction to the driver to convert a single- or two-part table name to a three-part format for create table SQL statements. Valid values are:
|
Password Encryption |
A number that determines whether password encryption can be performed from the Open Client Library to the server. Valid values are:
|
Charset |
The name of a character set corresponding to a subdirectory in Sybase_root\charsets. The default is the setting on the DirectConnect server. |
WorkstationID |
The workstation ID used by the client. |
Language |
The national language corresponding to a subdirectory in Sybase_root\locales. The default is U.S. English. |
ApplicationName |
The name used by the DirectConnect Server to identify your application. |
YieldProc |
A numeric value that determines whether you can work in other applications when the DirectConnect server is busy. Valid values are:
Sybase recommends that you use value 1. |
OptimizePrepare |
A value that determines whether stored procedures are created on the server for every call to SQLPrepare. Valid values are:
|
ArraySize |
The number of rows the driver retrieves from the server for each fetch. This is not the number of rows given to the user. The default is 10 rows. |
SelectMethod |
A value that determines whether database cursors are used for select statements. Valid values are:
|
ReuseFailed Cursor |
A value that determines whether the server attempts to reuse a cursor that contains an error. Valid values are:
|
PacketSize |
A number that determines the number of bytes per network packet transferred from the database server to the client. The correct setting of this attribute can improve performance. Valid values are:
To use this connection attribute, you must configure the System 11 or DirectConnect server for a maximum network packet size greater than or equal to the value of this property. The ODBC specification specifies a connect option sql_packet_size that offers this same functionality. To avoid conflicts with applications that can set both the connection string attribute and the ODBC connect option, both functions are defined as mutually exclusive. If PacketSize is specified, you receive the message “Driver Not Capable” if you attempt to call sql_packet_size. If you do not set PacketSize, the driver accepts application calls to sql_packet_size. |
Translate |
An instruction that displays the Select Translator dialog box, from which you can perform a data translation from one character set to another. Choose the INTERSOLV OEM ANSI translator to translate data from the IBM PC character set to the ANSI character set. |
Choose OK to write these values to the ODBC.ini file.
The values are now the default values when you connect to this data source.
To change the values, do one of the following:
Change the defaults by reconfiguring the data source.
Override the defaults by connecting to the data source using a connection string with alternate values.
Copyright © 2005. Sybase Inc. All rights reserved. |