INF: ????? ????? ?????? ????? DB OLE Microsoft DB2

?????? ????????? ?????? ?????????
???? ???????: 218590 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????? ????

???? ???? ??? ???? DB OLE Microsoft ?? DB2

???????? ???? Microsoft OLE DB ?? DB2 ?? ????? ?????? OLE DB ??? ???;
  • ?? ?????? ??? ?????? ?????? Microsoft (UDL) ?? ??????? ??? ?? ??????? ????? ??.

    - ?? -
  • ????? ?????? ???? ??????? ????? ????? ????? ??? ??????.
Microsoft Data Access Components (MDAC) 2.0 ?????????? ?????? ????? "???????? ????????" ????? ??? ????? ? ????? ??????? ??? ????? ?????? OLE DB. ???? ???????? ???????? ????? ????? ?? ????????? ???????? ????? ?????? OLE DB ????????. ?????? ??? ??????? ?????? ??? ??????? UDLs ???????? ??? ????? ????? ????? OLE DB ???????? ???????? ????? ????? ADO ???? "??????? OLE DB ?????? ?? DB2" ?? ????? SDK ???? SNA ??? ??????.

???????? ???????? DB OLE

??? ???? ????? ??????? ???? ???????? ??? ???? ???? ???????? ?????? ??? ?????? ???? ???????? ???? OLE DB ?? DB2. ??? ??????? ???????? ?????????? ???? OLE DB ?? DB2 ????? ???????? ??? ??? ????? ??? ???????? ??? ????? ??? ???? ???????? ???? ?????. ????? ???????? ???????? ????? ????? ?????? ???? ?????? OLE DB ????? ?????? ???????? ?????? ?? ????? ????? UDL. ?????????? ??? ??? ????? RowsetViewer ??????? ?? SDK ???? SNA ????? ????? UDL ???? ????? ????? ??????? ??????? ??? ???? OLE DB ?? DB2 ?? ??? ???????.

????? ?? ????? ?????? ????????

??? ?? ???? ?????? "?????? ????????" ?????? ?????? ???? ???????? OLE DB. ????? ????? "?????? ????????" ?????? ?????? ??? ???????? ?? ?????? ?????? Access Server\Data SNA. ???? ????? ????? ??? "???????? ????????" ?? ???? ??? ????? ?? ?????? Windows. ?????? ??? ???????? ????????:

?? Windows NT

  1. ?? ??????? "????" ? ??? ?????? ??????? Microsoft Server SNA.
  2. ??? ?????? ??????? "?????? ??? ????????".
  3. ??? ???? OLE DB ?????? ????. ???? ?????? "????? ?????? ????????".
  4. ????? ??????? ???? ?????? ?????? ??????. ???? ??? ??????? ?????? ??? ???? ?? ?????????.
  5. ???? ??? ????? ???? Data Link.

Windows 95/98

  1. ?? ??????? "????" ? ??? ?????? ??????? Microsoft Server SNA.
  2. ??? ?????? ??????? "?????? ??? ????????".
  3. ??? ???? OLE DB ?????? ????. ???? ?????? "????? ?????? ????????".
  4. ????? ??????? ???? ?????? ?????? ??????. ???? ??? ??????? ?????? ??? ???? ?? ?????????.
  5. ???? ??? ????? ???? Data Link.
?????????? ??? ????? "???????? ????????" ?? ?????? Links DB\Data Files\System\OLE Files\Common ???????. ??? ???? ????? ????? "?????? ????????" ?? ?? ???? ?????? ??? ?????? ????? ?????? ?????? ???????? Microsoft ???? ?? ??????? ??? ????? ???? "????? ???????? ????????".

??????? OLE DB Data Sources

?????????? ??? ????? "???????? ????????" ?? ?????? Links DB\Data Files\System\OLE Files\Common ???????. ??? ????? ?????? ?? ???????? ?????? Microsoft Server SNA. ??????? ????? ????????:
  1. ?? ??????? "????" ? ??? ?????? ??????? Microsoft Server SNA.
  2. ??? ?????? ??????? "?????? ??? ????????".
  3. ????? ??????? ???? OLE DB ????????. ??? ??? ????? ???????? ???????? ???????? ?? ?????? ?????????.

????? OLE DB ???? ???????? ??????? DB2 ???????? "???????? ????????"

???? ????? ??????? ???? ???????? ?? ????? ???? OLE DB (????? ??? ????) ??????? ?? ??? UDL ??? ?? ????? ?????? OLE DB ????????. ???? ???? DB OLE Microsoft ?? DB2.

????? ??????? ????? ???? ???????? ????? ??????? ???????? ???????? ??????? ????? ??????. ?????? ??? ???? OLE DB ?? DB2 ? ????? ????? ??????? ????? ???????:

???? ????????: ?? ???? ???????? ????? ???????? ???? ????????? ???? ???? ????????. ??? ????? ?????? ????? "???????? ????????" ?? ???? ?????? ???? SNA ????? ??? ???? ????????. ??? ??????? ??? ????? ??? ??? UDL ???? ?? ?????? ?? ?????? DB\Data Files\System\OLE Files\Common ???????.

??? ????????: ??? ?????? ???? ????? ???? ?????? ??? ???????? ??? DB2. ???? ???????? ???? ?? ????? ??? ?????? ?? "?????? ????????". ?????? ???? OLE DB ???????? ?? ??? ??????? ?????? ???? ???? ?????. ???????? ??? ???? ???? ???? ?????? ?????? ???????? ?????? ??? ???????? ??????? ?? "?????? ????????".

AS / 400 ????????? ????? ?? ????? ??? ???? ???????? ????? ??????. AS / 400 ???? DB2/400 ???? ???????? ????? ?????? ?? ??????. ????? (?? ??? ??? ??????? DB2/400 ????? ?????? ??? ????? ???? OLE DB ???? ????? ???????? ? ??? ???? ???????? ????? ?????? ?? ??????.)

????? ????????? ???????? ??? ???? ???? ??????. ???? ???? ?? ??? ????? ????????? ???????? "? ????? ????? DB2 ???? ???????? ????? ?????? ?? ?? ??????. ???? ???? OLE DB ??? ????? ?? ??????.

DB2 UDB ?? Windows NT ???? ????? ??????. ??? ????? ???? ???????? ?? ??????. ??? ????? ???? ?????? ?? ???? ???? ??????. ??? ??? ???????? ????? ???? ?????? ?? ???? ?????? ???????. ???? ???? OLE DB ???? ?????? ?????? ?? ???? ????????. ?? ???? ????? ???????? ??? ?????? Windows NT ??? ???? Windows NT.

???? ??????: ???? ???? ????? ?????? ???? ?????? ??? ???????? ??? DB2. ???? ???????? ????? ?????? ??? ???? ?????? ?? ??? UDL ?? ???? ????? ???? ???????? ?????? ???? ???? ??????.

?????: ??? ?????? ??????? ??????? ???????? ???????? ???? ?????? ???? ??? UDL.

???????? ??????: ??? ??????? ??? OLE DB ??????? ????? ????? ?? ??? ???? ???? ???? ???? ????? ?????.

?? DB2 (MVS ? OS/390) ? ??? ??????? ??? ??? ??????? ??? LOCATION. ???? ?????? SYSIBM.LOCATIONS ???? ??????? ???? ?? ?????? ?????. ????? ?? ????? DB2 ??? ??????? ???? ?? ????? ????? ?? DSNTINST Clist TSO ??? ??????? DDF. ??? ????? ??? ????????? ?? ???? DSNTIPR ?? ???? ??????? DB2.

?? DB2/400 ??? ??????? ??? ??? ??????? ??? RDBNAM. ????? ????? ???? RDBNAM ??????? ????? WRKRDBDIRE ?? ???? ?????? ??? ???? OS/400. ?? ???? ??? ???? ???? RDBNAM ?? ????? ???? ????? ???????? ?????? ?????.

?? ?????? ???????? DB2, ??? ??????? ??? ??? ??????? ??? ????? ??????.
????? ????? ??????? "???????" ????? ?? ?????? ??????? ???? ???????? ??????? ?????? ???????. ????? ?????? ??????? ??? ????? ???? ???????? ????????. ??? ????? ??? ??? ???? ??? ????? ???? ??? ??? ?????? ?????? DB2 ???????? ???? OLE DB ?? DB2.

????? ??????? ???? ???? ???????? ????? ????? ?????? ????????? ?? ??????? ????? ??????. ??? ??????? ?? ????? ??????? ???? ??????. ?? ???? ????? ??? ??????? ?????? ????? ????? ?? ??????? ???????? ????? ????? ????. ?????? ??? ???? Microsoft OLE DB ?? DB2 ? ????? ??? ??????? ????? ???????:
??? TP ??????: ??? ??????? ??? ???????? ??? ??????? ?? SQL/DS (DB2/VM ?? DB2/VSE) ????? ???? ??????? ????????? ?? ???.

??? ?????? LU ?????? APPC: ??? ?????? LU ?????? ????? ?? ???? SNA.

??? ??? APPC: ??? APPC ?????? ?? ????? ?????? ?????? ???? SNA. ????? ????? ????????? ???? APPC QPCSUPP (??????? ?????? ???????) ? #INTER (????) #INTERSC (???????? ?? ???? ?????? ???? ???????) ? #BATCH (???????) ? #BATCHSC (?????? ?? ???? ?????? ???? ???????) #IBMRDB (?????? ?????? ????? ?????? DB2).

??? ?????? LU ?????? APPC: ??? ?????? LU ?????? ????? ?? ???? SNA.

??? ????? ??????: ???? ??? ??????? ???????? ????? ??? ???? ??? SQL. ?? "????? ????? ??????" ?? ?? ????? ????? ???????? ?????? ?? ???????? ??? ??? ?????. ???? ??? ????? ?????? ????????? ??????? ???? ????? ?? ????? SQL ?????. ??? ?? ??????? ?????? ?? ????? ????? ??? ?????????. ??? ?????? ?? ????? ??? ??????? "??? ????? ??????". ????????? ?? True.

?????? ????? ??????? ??????: ????? ???? ???? ???????? ???? ???? ?? ?????? ??? ????? ??????? ?????? ??????? ???????? ????? ??? ???? ???? ?? ????? ??????? ???? ??????. ????????? ?? False.

????? ??? ?????????: ??? ???? ????? ????? ?????? ?? ??????? ????????? ?????? ??? ???????? DB2 ?????? ????????? ??????. ????????? ?? NC. ??????? ??????? ??????:
CS   Cursor Stability. 
     In DB2/400, this corresponds to COMMIT(*CS). 
     In ANSI, this corresponds to Read Committed (RC).

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

UR   Uncommitted Read. 
     In DB2/400, this corresponds to COMMIT(*CHG). 
     In ANSI, this corresponds to Read Uncommitted. 

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

RR   Repeatable Read. 
     In DB2/400, this corresponds to COMMIT(*RR). 
     In ANSI, this corresponds to Serializable (Isolated).
					
?????? ?????????: ??? ?????? ??? ???? ?????? ?? ??????? ????????. ?????? ???? OLE DB ???? ??????? ????? ??????? ????? ?????? ??????? ??? ????? ????? ??????? ?? ?????? ??? (??? ???? ??????? OLE DB IDBSchemaRowset DBSCHEMA_TABLES). ???????? ??? ???? ?????? ???? OLE DB ???? ??????? ?????? ????? SQL SELECT ?????? IOpenRowset::OpenRowset. ?????? ??? ??????? ?????? ??? "?????? ?????????" ?????? ????? ??????? ??????? ?? "????? ??????? ?? Microsoft:
217757INF: ???? ??????? ???? ????????? ?? ?????? ????? ODBC DB2 ? ???? OLE DB ?? DB2
????? ?????: ????? ?????? ????? ?????? ????? ?????. ??? ?? ???? ????? ?????? ?????? ??????? ???? ?? ??????? ?? ???? ??? ??????? ?? ??? ????? ?????? ?????? ?? ???? ???? ??????? ????????.

CCSID ??????: ????? (CCSID) ????? ???????? DB2 ????? ????? ??? ????????? ?????? ?????? ??? ?????. ??? ??????? ?????????? ???????? ???????/???? (37). ????? CCSID ?????? ??? ?????? ???????? ???????? ??????? ???. ?? ?? ??? ????? ???? ?????? ????? ??? ?????? ??? ??? ????? ???????? ???????? ??? DB2 ?????? CCSID ? ????????? ANSI ???? ??????.

????? ??????: ??? ??????? ??? ??????? ?????? ???? ????????? ????? DB2 ????? TCP/IP ?? TCP/IP ?????? ???/???????? ???????? ?????? DRDA ???? ???. ????? ????? ???? ??????? ??? ??????? ?? TCP/IP.

???? ???? ???????: ??? ??????? ??? ??????? ?????? ???? ????? DRDA DB2 ???? ?????? ??? ?????? ??? ??????? ?? TCP/IP. ????????? ?? ????? ?????? DRDA ???????? 446.

????? ??? ???? ???????: ??? ???? ??????? ?? ????? ????? ????? ?????? ???? ??? ?? ??? ??? ??????? ?????? ?? ???? LU6.2 SNA ?? TCP/IP. ?????? ?????????? ?? SNA. ??? ?? ????? TCP/IP ?? ??? ????? ?????? ? ???? ?????? ??????. ??? ??? ????????? SNA ?????? ?? ?????? ??? ??? ?????? LU ?????? APPC ? ??? ??? APPC ? Alias LU ?????? APPC ??????.

?????? ??????: ??? ?????? DRDA ??? ???? ?? ???? ?????? ??????? ??? ????? ??? ??? DB2. ?? ???? ??? ??? "?????? ?????????". ??? ????? ??????. ?????? ??? ???? ?? ?????????? ?????? ????? ??????? ??????? ?? "????? ??????? ?? Microsoft:
216810????? ??? ????????? ?? ?????? ??????? ODBC DB2 ? OLE DB ???? ?? DB2
????????? ??????: ??? ??????? ?????? ??? ?????? ???????? ???????? ??????? ???. ?? ?? ??? ????? ???? ?????? ????? ??? ?????? ??? ??? ????? ???????? ???????? ??? ???? ???? ANSI ????????? ????? ?? Windows. ?????? ?????????? ???? ??????? ?? 1 ????????? (1252).

????? ??????? ??????: ???? ???????? ????? ?????? ??? ???? ?????? ?? ??? UDL ?? ???? ????? ???? ???????? ?????? ???? ???? ??????.

?????: ??? ?????? ??????? ??????? ???????? ???????? ???? ?????? ???? ??? UDL.

????? ?????? ??? ??????: ???? ?????? ????? (CCSID 65535) treats ??? ?????? ?????? ? ???? ??? ?????? ?????? ??? ???? ???? ?? ??????. Pag ??? ????????? e CCSID ?????? ???? ??????? ??????? ???? ????? ??????.

??????? ???: ????? ???? ?????? ??????? ???. ???????? ???? ?? ?????? ??????? ??? ??? ?????? ??? ??????? ? ?? ???? ?????? ?????? ?????? ??? INSERT UPDATE ? ?? DELETE.

?????

MVS OS/390 OS/400

???????

???? ???????: 218590 - ????? ??? ??????: 16/????/1426 - ??????: 1.2
????? ???
  • Microsoft OLE DB Provider for DB2
????? ??????: 
kbmt kbinfo KB218590 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????218590

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com