PDF《DB2》

ICZKP&

CLr~qwDYw53r2~=(# `XEn: v Z

84 3D:,S/Pw;

v Z

82 3D:,SX;

v Z

3 3D:DB2 Connect;

v Z

24 3D:DB2 Connect MBq&

m`Sw;

v Z

18 3D:DB2 Connect M Web &

CLr;

`XND TP `SwD DCS ?JOdv}]xr# ,,

,,

,,

,,

BIDI= KN}GZEv;

CN},ICKN}48(CZ2G1!~ qw}]b BiDi CCSID D0+r1(BiDi) CCSID#}g: BIDI=xyz dP xyz m>

CCSID 2G# `XEn: v Z

29 3D:|B}]b?ZP;

C'

1^(hCBZ(j6Dms SQLCODE ,e CLI0106E 4xP,S# CLI0197E ,S;

GIE,S# CLI0124E a)D5PJb#kliC5Gq*Ur+$HH# CLI0196E ,Sf0h9P;

C'

D$w%*#*kP;

C'

,,

S;

(;

\ZBqP# 2. (}GJmKIE73DIE73*sza)+P;

ADZ(j6D\k,qrC Y w G I ! D ) w C S Q L S e t C o n n e c t A t t r / }

4 h C SQL_ATTR_TRUSTED_CONTEXT_PASSWORD tT#+dhC*BZ(j6D\ k# rc = SQLSetConnectAttr( conn, SQL_ATTR_TRUSTED_CONTEXT_PASSWORD, passwd, SQL_NTS );

//lims kqXlimsM/f,b)msM/fPZm m

6 Mm m

7 P# m 7. 8>

ZP;

C'

1^(hC\kDms SQLCODE ,e CLI0198E P4hCtT SQL_ATTR_TRUSTED_CONTEXT_USERID# 3. 4U#f,SD==Lx4P#g{z}Z9C XA Bq\mw,rZB;

Nks

1 TC'

P;

;

qr,+Zt/CJ}]bDB;

v/}wC(}g: SQLExecDirect)0 TP;

C'

#ZNN;

VivB,}KxP#fDmsM/ fli,9kqXli m

8 PPvDms#m

8 PDms8>

C'

P;

'

\# m 8. 8>

P;

C'

'

\Dms SQLCODE ,e SQL1046N JmKIE,SDIE73;

P;

dC*Jm P;

=zTzms -20361 D SQL0969N 3)}]b6pk 5.1 }x;

Vv?&

\,|\;

'

V)92 +Tzk#8()92+T+a)=SoO,}g,}K-rkTb,9+a) (PASSWORD EXPIRED)HE # *{CKv?&

\,&

C+CZ)92+TD DB2 (C}]b z/OS M OS/390 f ZPARM 20N}D5hC* YES#9C DB2 (C}]b z/OS M OS/390 f20fe DSN6SYSP 4hC EXTSEC=YES#9IT9C DDF fe 1(DSNTIPR)4hC|#1 !5G EXTSEC=NO#Z\k=Z1,9C DB2 Connect D Windows Linux UNIX M Web &

CLr+SU= SQL30082 ms{ # Qi$ TCP/IP 2+T: tka)T DB22+T!n AUTHENTICATION=CLIENT D'

V,r&

9C DB2 (C} ]b z/OS M OS/390 f20fe DSNTIP4(DDF fe 2)4+ TCP/IP Q-i$D 2+ThC* YES# @f ODBC M Java &

CLr2+T: $w>

ODBC M Java &

CLr9C/, SQL#bZ3)20ivBI\DiO# O$hCZ DB2 Connect ~

46 C'

8O qwD}]b?20 DB2 Connect D_- }/w,INSTHOME m>

DB2 Connect 5}Dw?c|B bBnJCZ1 m>

b)J'

D}]I=v;

,D}]b~qw\m1Div# DB2 z7T`>

c|Ba)+fD'

V#K'

VICZ9C#f SQL * D&

CLr T09CBq&

m`Sw(TP `Sw)5V X/Open XA SZf6D&

CLr#by D TP `Swz7D>

}|( IBM TxSeries(CICS M Encina) IBM Message and Queuing 5P IBM Component Broker 5P IBM San Francisco Project T0 Microsoft Transaction Server(MTS) BEA Tuxedo M8vd{z7#20hswP;

,,

b! vZG9C>

z SQL `>

c|B,9G9C TP `Sw`>

c|B# >

z SQL M TP `Sw`>

c|BLrz SQL `>

c|B1,Xk9C}#D SQL COMMIT M ROLLBACK# TP `Sw`>

c|BIT-wCJ DB2 MG DB2 J4\mw(}g Oracle Informix r SQLServer)DBq#>

z SQL `>

c|BvJCZ DB2 ~qw# *9`>

c|BBqpwC,NkVc|B;

v Z

54 3D:9CXFPDbT`>

c|B;

9CXFPDtC`>

c|B IT9C0XFPD14a)`>

c|B# }L: *tC`>

c|B: 1. t/0XFPD1 # 2. %w [+] ET9*wNSc|B ―>

dCK%n#0`>

c|Brc|B ―>

bTK%!n#0bT` >

c|B10Zr*# 2. ZICDPmrP,SICD}]bP!qzk*bTD}]b#IT9CPdD =r4%(>

M >

>

)Z!qDPmrPFxMFv!q#9IT(}Z!qDPm rP1S`-!qDC'

j6M\k4|D|G# 3. 1zjI!q1,%w7(#0`>

c|BbTa{10Zr*# 4. 0`>

c|BbTa{10ZT>

y!qD}]bD)|BbTI&

,D)'

\# C0Z+T>

'

\D}]bD SQL zkMms{ #%wXUTXUC0Z# 5. %wXUTXU0bT`>

c|B10Z#

54 C'

8O `XEn: v Z

53 3D:`>

c|B;

`XNq: v Z

54 3D:9CXFPDtC`>

c|B;

`>

c|BM,=c\mw wzM iSeries }]b~qw*s DB2 Connect Nkp4Z Linux Windows UNIX M Web &

CLrDV c|B=8Gqh* DB2 Connect TS Intel? zwr S UNIX zwCJwzr iSeries#TZ`>

c|B,g{}Z9C TP `Sw,r DB2 Connect D SPM i~GXhD# m 10. h* SPM C TCP/IP D`>

c|B=8 Gq9CBq&