ODBC Driver Implementation and Configuration › ODBC Connection Options › Connection Strings

Connection Strings

ODBC Connection strings may be required by your application to connect to a data source. You must specify the data source name that tells the driver which ODBC.INI section to use for the default connection information. Optionally, you can specify attribute=value pairs in the connection string to override the default values stored in the data source in ODBC.INI. These values are not written to ODBC.INI.

Specify either long or short names in the connection string. The connection string has the following format:

DSN=data_source_name;attribute=value;attribute=value;...

DSN=

Specifies a string (Data Source Name) that identifies a CA Datacom/DB data source configuration in ODBC.INI. Examples include Accounting and Datacom‑Serv1.

SERVER=

(Optional) Specifies the SERVERNAME= parameter in the server startup JCL.

SYSID=

Specifies the system ID name specified in the CAICCI startup JCL. It is the CAICCI system ID of the mainframe environment that the workstation connects to when a data source is selected.

APPLID=

Specifies the application ID parameter in the server startup JCL.

UID=

(Optional) Specifies your user ID.

PWD=

(Optional) Specifies your password.

TABLECACHE=

(Optional) Caches a table list retrieved from the mainframe on the PC. On subsequent calls for a table list, the list can be retrieved from the workstation.

HOSTNAME=

(Optional) Changes the host to which you connect. This field lets you override the values specified in the CCI Server Identification Name field in the CAICCI-PC properties panel if specified.

HOSTPORT=

(Optional) Allows you to programmatically change the host to which you connect. This field lets you override the values specified in the CCI Server Identification Port field in the CAICCI-PC properties panel if specified.

TABLLISTMASK=

(Optional) Specifies a mask for the list of tables and views presented for user selection.

TRANSTABLE=

(Optional) Specifies the name of an ASCII to EBCDIC translation table.

TCP_CCI_SW=

(Optional) Defaults to C for CCI, and must be set to T for a TCP/IP connection (z/OS only).

AUTOCOMMIT=Y/N

(Optional) Specifies if it is auto commit or manual commit mode.

Y

Enables auto commit mode for the connection. In auto commit mode, every database update is a transaction that is committed when performed. This is the default.

N

Specifies manual commit mode where the application must explicitly complete transactions by calling SQLEndTran to commit or rollback.

NEWPW=

(Optional) Allows you to programmatically change the password for the user ID specified in the UID= parameter. VERPW= must be coded along with this parameter. NEWPW= is ignored if LOGON=NO is specified in the mainframe option startup parameters.

VERPW=

(Optional) Allows you to programmatically verify the new password provided is NEWPW=. VERPW= is ignored if LOGON=NO and if NEWPW= is ignored. Required if NEWPW= is coded.

Example: Connection String for CA Datacom/DB

DSN=Datacom Server;SERVER=MUF1_SERVER; 
SYSID=CCISYSID;APPLID=MUF1_SERVER;UID=USER1; 
PWD=PASSWORD;TABLECACHE=N;HOSTNAME=;HOSTPORT=;
TABLLISTMASK=;TRANSTABLE=;AUTOCOMMIT=;TCP_CCI_SW=;NEWPW=;VERPW=;