Welcome  |  Sign in
Skip Navigation Links
Microsoft Developer Network
Printer Friendly Version      Send     
Click to Rate and Give Feedback
MSDN
MSDN Library
Data Integration
ADO Reference
 ActiveConnection Property Support U...
Microsoft Host Integration Server 2000
ActiveConnection Property Support Using the OLE DB Provider for DB2

The Microsoft® OLE DB Provider for DB2 also supports a number of provider-specific arguments, some of which have default values as specified in the tables below. The arguments supported by OLE DB Provider for DB2 supplied with Host Integration Server 2000 differ from the arguments supported by the earlier OLE DB Provider for DB2 included with SNA Server 4.0.

The arguments supported by the OLE DB Provider for DB2 supplied with Host Integration Server 2000 are as follows:

Argument Description
BinAsChar When this parameter is set to true, the OLE DB Provider for DB2 treats binary data type fields (with a CCSID of 65535) as character data type fields on a per-data source basis. The Host CCSID and PC Code Page values are required input and output parameters.

This parameter defaults to false.
CCSID The Code Character Set Identifier (CCSID) attribute indicates the character set used on the host.

If this argument is omitted, the default value is U.S./Canada (37).

DefSch The name of the default schema (collection/owner) where the system catalogs resides. This parameter can be QSYS2;SYSIBM;SYSTEM; CURLIB; or USERID depending on platform.

This parameter does not have a default value.
InitCat This parameter is used as the first part of a 3-part fully qualified table name. In DB2 (MVS, OS/390), this property is referred to as LOCATION. The SYSIBM.LOCATIONS table lists all the accessible locations. In DB2/400, this parameter is referred to as RDBNAM. The RDBNAM value can be determined by invoking the WRKRDBDIRE command from the console to the OS/400 system. If there is no RDBNAM value, then one can be created using the Add option. In DB2 Universal Database, this property is referred to as DATABASE.

This parameter has no default value.
LocalLU The name of the local LU alias configured in Host Integration Server.
ModeName The APPC mode (must be set to a value that matches the host configuration and Host Integration Server configuration).

Legal values for the APPC mode include QPCSUPP (5250), #NTER (interactive), #NTERSC (interactive), #BATCH (batch), #BATCHSC (batch), and custom modes.
NetAddr When TCP/IP has been selected for the Network Transport Library, this parameter indicates the IP address of the host.
NetPort When TCP/IP has been selected for the Network Transport Library, this parameter is the TCP/IP port used for communication with the source.

The default value is TCP/IP port 446.
NetLib This parameter determines whether TCP/IP or SNA APPC is used for network communication. The possible values for this parameter are TCPIP or SNA.

This value defaults to SNA.
PCCodePage The character code page to use on the PC. If this argument is omitted, the default value is set to Latin 1 (1252).
PkgCol The name of the DRDA target collection (AS/400 library) where the OLE DB Provider for DB2 should store and bind DB2 packages. This could be same as the Default Schema.

The Microsoft OLE DB Provider for DB2 uses packages to issue dynamic and static SQL statements. The OLE DB Provider will create packages dynamically in the location to which the user points using the Package Collection parameter.

RemoteLU The name of the remote LU alias configured in Host Integration Server.
TPName The Transaction Program (TP) Name parameter represents the default transaction program name for the DB2 DRDA application server (AS) which is 07F6DB (DB2DRDA). However, some DB2 installations may be configured to use an alternate TP name.

Host Integration Server 2000 uses the alternate TP name in the off-line demo configuration (DRDADEMO.UDL). In that case, TPName is set to 0X07F9F9F9.
UOW This parameter determines whether two-phase commit is enabled. The possible values for this parameter are DUW (distributed unit of work) or RUW (remote unit of work).

This value defaults to RUW.

When this parameter is set to RUW, two-phase commit is disabled.

When this parameter is set to DUW, two-phase commit is enabled in the OLE DB Provider for DB2. Distributed transactions are handled using Microsoft Transaction Server, Microsoft Distributed Transaction Coordinator, and the SNA LU 6.2 Resync Service. This option works only with DB2 for OS/390 v5R1 or later. This option also requires that SNA (LU 6.2) service is selected as the network transport and Microsoft Transaction Server (MTS) is installed.
Note   Not all of these parameters are required. The user can also be prompted for this information.

The arguments supported by the OLE DB Provider for DB2 supplied with SNA Server 4.0 are as follows:

Argument Description
BinAsChar When this parameter is set to true, the OLE DB Provider for DB2 treats binary data type fields (with a CCSID of 65535) as character data type fields on a per-data source basis. The Host CCSID and PC Code Page values are required input and output parameters.

This parameter defaults to false.
BindType This parameter indicates the bind type to be used when creating packages. Legal values for the package binding type are as follows.

NORM—normal binding.

FAST—create all 64 package sections optimally in a single network flow.

NOSP—reserved for future use and currently not supported.

The default value for this parameter is NORM.

This parameter is not supported by the ODBC Driver for DB2 supplied with Host Integration Server 2000.

This parameter is supported by the OLE DB Provider for DB2 supplied with the Japanese version of the OLE DB Provider for DB2 client included with SNA Server 4.0 with Service Pack 2, and by the OLE DB Provider for DB2 client included with all versions of SNA Server 4.0 with Service Pack 3 or later.
CCSID The Code Character Set Identifier (CCSID) attribute indicates the character set used on the host.

If this argument is omitted, the default value is U.S./Canada (37).

Commit This parameter indicates whether changes to data will be automatically committed or require a separate manual commit request.

This parameter defaults to true (auto commit).
DefSch The name of the default schema (collection/owner) where the system catalogs resides. This parameter can be QSYS2;SYSIBM;SYSTEM; CURLIB; or USERID depending on platform.

This parameter does not have a default value.
GCCSID The graphics character code set identifier (GCCSID) matching the DB2 character data as represented on the remote host computer. This parameter is required when accessing DB2 databases configured to support mixed single-byte (SBCS) and double-byte (DBCS) data. This parameter only applies when accessing DB2 for OS/390 or DB2 for MVS.

The following values for GCCSID are supported by the OLE DB Provider for DB2: 300, 834, 835, 837, or 4396.

This parameter defaults to 0 indicating that mixed CCSID conversions are not supported.

This parameter is not supported by the ODBC Driver for DB2 supplied with Host Integration Server 2000.

This parameter is supported by the OLE DB Provider for DB2 supplied with the Japanese version of the OLE DB Provider for DB2 client included with SNA Server 4.0 with Service Pack 2, and by the OLE DB Provider for DB2 client included with all versions of SNA Server 4.0 with Service Pack 3 or later.
InitCat This parameter is used as the first part of a 3-part fully qualified table name. In DB2 (MVS, OS/390), this property is referred to as LOCATION. The SYSIBM.LOCATIONS table lists all the accessible locations. In DB2/400, this parameter is referred to as RDBNAM. The RDBNAM value can be determined by invoking the WRKRDBDIRE command from the console to the OS/400 system. If there is no RDBNAM value, then one can be created using the Add option. In DB2 Universal Database, this property is referred to as DATABASE.

This parameter has no default value.
IsoLvl This parameter determines the isolation level provided for this data source. Legal values for the default isolation level are the following:

CS—Cursor Stability. In DB2/400, this isolation level corresponds to COMMIT(*CS). In ANSI, this isolation level corresponds to Read Committed (RC).

NC—No Commit. In DB2/400, this isolation level corresponds to COMMIT(*NONE). In ANSI, this isolation level corresponds to No Commit (NC).

UR—Uncommited Read. In DB2/400, this isolation level corresponds to COMMIT(*CHG). In ANSI, this isolation level corresponds to Read Uncommited.

RS—Read Stability. In DB2/400, this isolation level corresponds to COMMIT(*ALL). In ANSI, isolation level this corresponds to Repeatable Read.

RR—Repeatable Read. In DB2/400, this isolation level corresponds to COMMIT(*RR). In ANSI, this isolation level corresponds to Serializable (Isolated).

This parameter defaults to NC.

This parameter is not supported by the ODBC Driver for DB2 supplied with Host Integration Server 2000.
LocalLU The name of the local LU alias configured in Host Integration Server.
MCCSID The mixed character code set identifier (MCCSID) matching DB2 character data as represented on the remote host computer. This parameter is required when accessing DB2 databases configured to support mixed single-byte (SBCS) and double-byte (DBCS) data. This parameter only applies when accessing DB2 for OS/390 or DB2 for MVS.

The following values for MCCSID are supported by the OLE DB Provider for DB2: 930, 931, 933, 935, 937, 939, 5026, or 5035.

This parameter defaults to 0 indicating that mixed CCSID conversions are not supported.

This parameter is not supported by the ODBC Driver for DB2 supplied with Host Integration Server 2000.

This parameter is supported by the OLE DB Provider for DB2 supplied with the Japanese version of the OLE DB Provider for DB2 client included with SNA Server 4.0 with Service Pack 2, and by the OLE DB Provider for DB2 client included with all versions of SNA Server 4.0 with Service Pack 3 or later.
ModeName The APPC mode (must be set to a value that matches the host configuration and Host Integration Server configuration).

Legal values for the APPC mode include QPCSUPP (5250), #NTER (interactive), #NTERSC (interactive), #BATCH (batch), #BATCHSC (batch), and custom modes.
NetAddr When TCP/IP has been selected for the Network Transport Library, this parameter indicates the IP address of the host.
NetPort When TCP/IP has been selected for the Network Transport Library, this parameter is the TCP/IP port used for communication with the source.

The default value is TCP/IP port 446.
NetLib This parameter determines whether TCP/IP or SNA APPC is used for network communication. The possible values for this parameter are TCPIP or SNA.

This value defaults to SNA.
PCCodePage The character code page to use on the PC. If this argument is omitted, the default value is set to Latin 1 (1252).
PkgCol The name of the DRDA target collection (AS/400 library) where the Microsoft OLE DB Provider for DB2 should store and bind DB2 packages. This could be same as the Default Schema.

The Microsoft OLE DB Provider for DB2 uses packages to issue dynamic and static SQL statements. The OLE DB Provider will create packages dynamically in the location to which the user points using the Package Collection parameter.

ReadOnly When the Read Only parameter is set to true (ReadOnly=1), the OLE DB Provider for DB2 creates a read-only data source. A user has read access to objects such as tables, and cannot do update operations (INSERT, UPDATE, or DELETE, for example).

This parameter is not supported by the ODBC Driver for DB2 supplied with Host Integration Server 2000.
RemoteLU The name of the remote LU alias configured in Host Integration.
TPName The Transaction Program (TP) Name parameter represents the default transaction program name for the DB2 DRDA application server (AS) which is 07F6DB (DB2DRDA). However, some DB2 installations may be configured to use an alternate TP name.
Note    Not all of these parameters are required. The user can also be prompted for this information.

A sample ConnectionString using the OLE DB Provider for DB2 follows:

Conn.Provider="DB2OLEDB"
Conn.ConnectionString = "User ID=USERNAME;Password=password",&_
  "LocalLU=LOCAL;RemoteLU=DATABASE",&_
  "ModeName=QPCSUPP;CCSID=37;PcCodePage=437"
Conn.Properties("PROMPT")=adPromptNever
Conn.Open
The &_ character combination is used for continuing long lines in Visual Basic.
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker