ibm informix .net provider - cnblogs.com...oibm informix dynamic server s Ωt dynamic server f...
TRANSCRIPT
IBM Informix
IBM Informix .NET Provider ΓU
3.0
G251-3002-00
IBM Informix
IBM Informix .NET Provider ΓU
3.0
G251-3002-00
NG
bΩTΣΣúºeA²\ B-1yNzñΩTC
σ≤]t IBM MQΩTCσ≤bvXUúAⁿ@vkO@CΓUtΩTú]t⌠≤úOAP
ΓUñú⌠≤n]°pC
ϕzeΩT IBM AYϕzP IBM DMvQA IBM oHΣAϕΦíGΩTAL∩
ztdC
© Copyright International Business Machines Corporation 2003, 2007. All rights reserved.
²
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viie . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii÷≤ΓU . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viiIBM Informix .NET Provider 3.0 sWS . . . . . . . . . . . . . . . . . . . . . . . . viiσ≤D . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viiiLΩD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viiiSBú¡xO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ixyk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ixíXdD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xii
ΣLσ≤ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xii≤Uuπ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiiiX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiiiIBM w∩zúNú . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
1 IBM Informix .NET Provider º[ . . . . . . . . . . . . . . . . . . . . 1-1≤ .NET ProviderH . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-1Σí]p⌠ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-1ΣΩw . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2Visual Studio ΩsΣ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2Σ IPv6 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2w IBM Informix .NET Provider . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2Ωw°A . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3.NET Provider Owº[ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3ú¼⌡µⁿw . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4WíD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4sΩw . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4 DataSet ≤PΩw≤@P . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-5suxs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-6]w FullTrust \iv . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-6 ? O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-7C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-7Isxs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-7 IfxProviderFactory ½≤ gPΩwL÷íX . . . . . . . . . . . . . . . . . . . . 1-7íµ÷ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-7ADO.NET @≥ªO@δgíΦí . . . . . . . . . . . . . . . . . . . . . . . . 1-8Tº . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-8l . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-8
2 ∩MΩ¼ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-1e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-1Ω . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-1]wΩ¼ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-2FLOATBDECIMAL MONEY Ω¼πµí . . . . . . . . . . . . . . . . . . . . . 2-2
3 ¼ΩT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-1Σ .NET . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-6Σ .NET ≥ªO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-6¼yk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-7IfxBlob O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-8
IfxBlob íσ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-8 IfxBlob . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-8
© Copyright IBM Corp. 2003, 2007 iii
IfxBlob e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-9IfxBlob Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-10
IfxClob O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-12IfxClob íσ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-12 IfxClob . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-13IfxClob e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-13IfxClob Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-14
IfxCommand O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-17 IfxCommand . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-17IfxCommand e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-17IfxCommand Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-18IfxCommand d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-19
IfxCommandBuilder O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-20 IfxCommandBuilder . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-20IfxCommandBuilder e . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-20IfxCommandBuilder Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-21IfxCommandBuilder d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-21
IfxConnection O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-22 IfxConnection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-22IfxConnection e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-22IfxConnection Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-25IfxConnection ≤ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-26d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-26
IfxConnectionStringBuilder O . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-27 IfxConnectionStringBuilder . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-27IfxConnectionStringBuilder e . . . . . . . . . . . . . . . . . . . . . . . . . . 3-27IfxConnectionStringBuilder Φk . . . . . . . . . . . . . . . . . . . . . . . . . . 3-27
IfxDataAdapter O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-28 IfxDataAdapter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-28IfxDataAdapter e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-29IfxDataAdapter Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-30IfxDataAdapter d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-30
IfxDataReader O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-31IfxDataReader e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-32IfxDataReader Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-32IfxDataReader d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-34
IfxDataSourceEnumerator O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-34 IfxDataSourceEnumerator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-35IfxDataSourceEnumerator e . . . . . . . . . . . . . . . . . . . . . . . . . . 3-35IfxDataSourceEnumerator Φk . . . . . . . . . . . . . . . . . . . . . . . . . . 3-35
IfxDateTime c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-35 IfxDateTime . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-36IfxDateTime e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-37IfxDateTime Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-38
IfxDecimal c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-42 IfxDecimal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-42IfxDecimal e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-43IfxDecimal Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-43
IfxError O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-47IfxError e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-48
IfxErrorCollection O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-48IfxErrorCollection e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-48IfxErrorCollection Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-48
IfxException O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-48IfxException e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-48
IfxMonthSpan c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-49
iv IBM Informix .NET Provider ΓU
IfxMonthSpan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-49IfxMonthSpan e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-49IfxMonthSpan Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-50
IfxParameter O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-53 IfxParameter O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-54IfxParameter e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-55IfxParameter d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-55
IfxParameterCollection O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-56 IfxParameterCollection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-56IfxParameterCollection e . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-57IfxParameterCollection Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-57
IfxProviderFactory O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-58IfxProviderFactory Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-58
IfxSmartLOBCreateTimeFlags C . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-60IfxSmartLOBFileLocation C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-60IfxSmartLOBLocator O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-60IfxSmartLOBLockMode C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-61IfxSmartLOBOpenMode C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-61IfxSmartLOBWhence C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-61IfxTimeSpan c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-62 IfxTimeSpan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-62IfxTimeSpan e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-63IfxTimeSpan Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-64
IfxTimeUnit C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-67IfxTransaction O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-68
IfxTransaction e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-68IfxTransaction Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-68IfxTransaction d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-68
IfxType C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-69
4 dí . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1dí . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1µ@ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1hεC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-2⌡µúΩ]úµ÷ SQL . . . . . . . . . . . . . . . . . . . . . . . . . 4-3NΩ DataSet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-3 IfxCommandBuilder ½≤ ≤PΩw≤@P . . . . . . . . . . . . . . . . . . . 4-4Isxs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-5íµ÷ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-6N CLOB gJ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-7
². ≤Uuπ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . A-1aIpyk. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . A-1
N . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . B-1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . B-2
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . X-1
² v
vi IBM Informix .NET Provider ΓU
e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii÷≤ΓU . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viiIBM Informix .NET Provider 3.0 sWS . . . . . . . . . . . . . . . . . . . . . . . . viiσ≤D . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viiiLΩD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viiiSBú¡xO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ixyk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ixp≤¬ⁿOµyk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . x÷ΣrI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiiID PW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xii
íXdD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiiΣLσ≤ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xii≤Uuπ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiiiX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiiiIBM w∩zúNú . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
e
úΓUñΩTº[AíΣDC
÷≤ΓU
ΓU]tnΩTA²ziH IBM® Informix® .NET Provider s@
IBM Informix ΩwñΩCΓU]zw⌠x Microsoft® .NET WµB½≤
Ví]phH IBM Informix °AMΩwC
Microsoft b⌠Wwú .NET í]p÷ΩTCp IBM Informix
Dynamic Server ÷ΩTA\°Aσ≤ñJΓUC
Windows® .NET O Microsoft Corporation bⁿΩ () ΣLΩaU
C
IBM Informix .NET Provider 3.0 sWS
IBM Informix .NET Provider 3.0 úUCsWS
v X ADO.NET 2.0 WµA²zbH .NET Framework SDK 2.0 oíA
iH IBM Informix .NET ProviderCUCmiΣ ADO.NET 2.0 sWS
KníG
http://msdn2.microsoft.com/en-us/library/ex6y04yf.aspx
H .NET 1.1 Wµ≥ª ADO.NET íAiHN .NET 2.0 [cϕ
@⌡µ[cAú½ssC
© Copyright IBM Corp. 2003, 2007 vii
v ϕ 1 CX IDS .NET Provider Ω@ ADO.NET 2.0 SC
ϕ 1. ≤s Informix .NET O
Informix .NET O ADO.NET 2.0 ≥ªO ADO.NET 1.1
IfxConnection DbConnection IDbConnection
IfxCommand DbCommand IDbCommand
IfxDataReader DbDataReader IDataReaderBIDataRecord
IfxTransaction DbTransaction IDbTransaction
IfxParameter DbParameter IDbParameter
IfxParameterCollection DbParameterCollection IDbParameterCollection
IfxDataAdapter DbDataAdapter IDbDataAdapter
IfxCommandBuilder DbCommandBuilder IDbCommandBuilder
IfxDataPermision DbDataPermision IDbDataPermision
v ϕ 2 πs Informix .NET OC
ϕ 2. s Informix .NET O
Informix .NET OBADO.NET 2.0 ≥
ªO í
IfxProviderFactory, DbProviderFactory Nϕ@ΦkAziH úΩ@Ω
OΩC
I f x C o n n e c t i o n S t r i n g B u i l d e r ,
DbConnectionStringBuilder
i²íoHí]pΦímMsΦs
urΩC
I f x D a t a S o u r c e E n u m e r a t o r ,
DbDataSourceEnumerator
i²íoHí]pΦís SQLHOST
C
σ≤D
íΓUDCoD²z≤÷≤qσ≤ño@UΣLU¼
ΩTC
íUCDG
v LΩD
v ΣLD
v yk
v ⁿOµD
v íXdD
LΩD
ΓUUCD sNyBí⌡πBíⁿOykÑÑC
D Nq
÷Σr SQLBSPL ΣL@í]pyÑ÷ΣrúOHjgr serif r¼
πC
viii IBM Informix .NET Provider ΓU
D Nq
Θr bσAsNyjrHΘrπCbykíXdAzn
ⁿwHΘrπC
Θr íΩΘ (pOB≤ϕµ) WB⌠B⌠WAH
(pB\αϕ÷s) HΘrπC
ÑerΘ úπΩTHzΘJΩTHÑerΘπC
÷Σ zn÷U÷ΣHjgr sans serif r¼πC
> oϕ\αϕCpAu∩uπ > ∩vϕquπ\αϕ∩
∩C
nZ: ϕⁿzuΘJvru⌡µvⁿOAbΘJßY÷ RETURNCⁿz
uΣJvσru÷vΣLΣAú÷ RETURNC
SBú¡xO
SBú¡xOO]tSSBúS¡xSΩTºq¿C
OídpUG
Dynamic Server
O IBM Informix Dynamic Server SΩT
Dynamic Server F
Windows M
O Windows ⌠SΩT
Windows M F
OiM@q@ (t) HWq¿CϕπqMSwú¡x
AªQODσr@íApG
ϕµ (Linux®)
yk
ΓUHUC≤mykA í»zíthⁿOHⁿOº
ykC
bUCΦAyz SQL ⁿOµ»zíykw≤∩G
v »zíYbYC
v ykqY½uC
v íjΘiH½AOXbí⌠WΦC
v yk»zí°YWL@µAbU@µ≥πC
v íú°≤S⌠AOXbí⌠WΦC
v ∩≤ΣLykqíµ¼πAO≥b
qWßC
Uϕíyk≤C
ix
PDF ñe≤ HTML ñe≤ Nq
>>---------------------- »zílC
-----------------------> »zíbU@µ≥C
>----------------------- qW@µ≥»zíC
----------------------->< »zí⌠C
--------SELECT---------- nC
--+-----------------+---’------LOCAL------’
i∩C
---+-----ALL-------+---+--DISTINCT-----+’---UNIQUE------’
t∩nCú
@C
---+------------------+---+--FOR UPDATE-----+’--FOR READ ONLY--’
DµUπi∩∩
AziHⁿwΣñ@C
.---NEXT---------.----+----------------+---
+---PRIOR--------+’---PREVIOUS-----’
DµUOi∩Az
ⁿwΣñ@CpGzS
ⁿwA≤o@µW
N@w]C
.-------,-----------.V |---+-----------------+---
+---index_name---+’---table_name---’
i∩Ce\F
C@½eúem
@rIC
>>-| Table Reference |->< ykqC
Table Reference
|--+-----view--------+--|+------table------+’----synonym------’
ykqC
p≤¬ⁿOµyk
UCⁿOµykWϕµñCíC
Lα½u@
x IBM Informix .NET Provider ΓU
onpladm create job job-p project
-n -d device -D database
-t table
(1)]w⌡µí
-S server -T target
:
1 \ Z-1
ñGµWu]w⌡µívqAzAq
≤ Z-1 CpGoOΩµ¼AhziHbu² Zv@Σo
qCºAoqXbUCqñCNAqlM
⌠≤C
]w⌡µí:
-fdpa
lc
u n N
FAp≤ TcⁿOAqDn¬WñlcⁿOCϕkΣ
A]AznCñ ííykAHjpgC
ΣLyk¼ (p SQL) hújpgC
uLα½u@víUCBJG
1. ΘJ onpladm create jobAMßAΘJu@WC
2. ∩aΘJ -pAMßAΘJMWC
3. ΣJUCnG
v -n
v -d MmW
v -D MΩwW
v -t MϕµW
4. ziH∩a∩UC@ (t) HWA⌠N½ªG
v -S M°AW
v -T M°AW
v ⌡µíCpGn]w⌡µíAϕu]w⌡µívqΘJ -fA∩aΘJ dBp aAMßA∩aΘJ l uC
5. ϕεC
zw¿C
xi
÷ΣrI
÷ΣrO»zíthⁿOHⁿOOdµrCϕ÷ΣrXbyk
ñAªOHjgrπCϕzbⁿOñ÷ΣrAziHjgpgr
gUªA²Oz≈g÷ΣrPykñX÷Σr@C
b»zíⁿOñ⌠≤I]PykñπI@C
ID PW
@ykdñ ID MWmOdC°WUσúPAziH⌠
NWBID σrNC Nϕb[ykñiíykC
ϕXbykBdσrñAªOHpgΘπC
UCyk íµ SELECT »zí@δíC
SELECT column_name FROM table_name
ϕzgoí SELECT »zíAHSwµϕµWN
column_name table_nameC
íXdD
ΓUσñHiú SQL íXdCútµºAíXúM≤⌠≤
µ@ IBM Informix íouπC
pGdñuCX SQL »zíAhúH[HwCpAziαUCd
ñíXG
CONNECT TO stores_demo...
DELETE FROM customerWHERE customer_num = 121
...
COMMIT WORKDISCONNECT CURRENT
Yn∩Swú SQL íXAz∩úMykWhCpAYn
DB–AccessAzHjh»zíCpGz SQL APIAhbC@
»zíY EXEC SQLA]nbC@»zí (ΣLAϕ
wr)C
nZ: íXdññIⁿXbπíñN[J≤híXA²OSnNªiX Hí bQºC
pbSwíouπ SQL API ñ SQL »zíⁿA\ú
ΓUC
ΣLσ≤
p÷ΩTA\uWúσ≤w⌠A⌠O http://www.ibm.com/software/data/
informix/pubs/library/C
xii IBM Informix .NET Provider ΓU
≤Uuπ
IBM ²Hhα≈sσ≤Cú HTML µíyAHKiH
Qp⌡¬nΘUN sªCΓUñúaIpµíy
kAoµíOubz⌡¬ αisµíCpaIp
µíΩTA\u≤Uuπv²C
X
uⁿΩΩa (ANSI)vuΩ (ISO)vwF@ucdy
Ñ (SQL)vC IBM Informix SQL ¼úX SQL-92 Entry Level (X
s ANSI X3.135-1992)AΣP ISO 9075:1992 PCAIBM Informix Ω
w°A\hSúX SQL-92 Intermediate and Full Level X/Open SQL Com-
mon Applications Environment (CAE) C
IBM w∩zúNú
NÑz∩ΓU⌠≤ⁿßMAH≤U∩i
CWUCΩTG
v z bΓUºWM
v X
v ÷ΓU
NNúHUCqll≤G
Odoqll≤A@°iσ≤ñM¿óºCpND
YíApuIBM NΣHvCp÷ⁿAyX IBM Informix
NΣ⌠A⌠O http://www-306.ibm.com/software/data/informix/support/
contact.htmlC
PzC
xiii
xiv IBM Informix .NET Provider ΓU
1 IBM Informix .NET Provider º[
≤ .NET ProviderH . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-1Σí]p⌠ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-1ΣΩw . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2Visual Studio ΩsΣ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2Σ IPv6 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2w IBM Informix .NET Provider . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2Ωw°A . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3.NET Provider Owº[ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3ú¼⌡µⁿw . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4WíD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4sΩw . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4 DataSet ≤PΩw≤@P . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-5suxs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-6]w FullTrust \iv . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-6 ? O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-7C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-7Isxs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-7 IfxProviderFactory ½≤ gPΩwL÷íX . . . . . . . . . . . . . . . . . . . . 1-7íµ÷ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-7ADO.NET @≥ªO@δgíΦí . . . . . . . . . . . . . . . . . . . . . . . . 1-8Tº . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-8l . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-8
≤ .NET ProviderHIBM Informix .NET Provider O@ .NET ≤Ai² .NET ísM@ IBM
Informix ΩwñΩC@kWOb Microsoft .NET Framework ñΩ@A
oi sΩwñΩC
IBM Informix .NET Provider ±zLUCΓΦk s IBM Informix Ωw
≤vG
v P Microsoft .NET Framework Data Provider for ODBC P IBM Informix ODBC
Driver
v P Microsoft .NET Framework Data Provider for OLE DB P IBM Informix
OLE DB Provider
Σí]p⌠
Microsoft .NET Framework i⌡µ⌠≤íúiH IBM Informix .NET Pro-
viderCUCMµ]t@í]pyÑdAoyÑiXoh
íG
v Visual BASIC .NET
v Visual C++ .NET
v Visual J++ .NET
v ASP.NET
© Copyright IBM Corp. 2003, 2007 1-1
IBM Informix .NET Provider iHbúπ .NET Σ Microsoft Windows ¡
xW⌡µCpGznΩ@ ADO.NET 2.0 IBM Informix .NET ProviderAz
tWw Microsoft .NET Framework 2.0 ≤sCCSDK 3.0 P≤s
ñwúΩ@ ADO.NET 2.0 IBM Informix .NET ProviderC
ztWw Microsoft .NET Framework SDK 1.1 ≤sCzw
IBM Informix Client SDK 2.9 ≤sC
ΣΩw
ziH IBM Informix .NET Provider sUCΩw°AG
v IBM Informix Dynamic Server (IDS) 7.31 B9.x ≤sC
v IBM Informix Extended Parallel Server (XPS) 8.4 ≤sC
Visual Studio ΩsΣ
pGz Microsoft Visual StudioAhw Client SDK w IBM Informix
.NET Provider íC Visual Studio 2005 íuH≤ CSDK ñCIConnect
úú]toíCbuπcuΩvñMΣuπAouπi
²zH°Φí tmUC IBM Informix .NET Provider ¼G
v IfxConnection
v IfxCommand
v IfxDataAdapter
Σ IPv6IBM Informix .NET Provider iHu⌠⌠⌠qT≤w 6 v(IPv6) u⌠
⌠⌠qT≤w 4 v(IPv4) C
pGzt IPv6AhzbsurΩñD≈WAún IPv6 µí
IP CúºAúnΣLSϕ@C
w IBM Informix .NET ProviderIBM Informix .NET Provider wb≤ (GAC) ñn²Γ¬πW
≤CDLL WO IBM.Data.Informix.dllCIBM Informix .NET Provider 2.0 Frameowrk
≤P 1.1 Framework ≤úPC IBM Informix .NET Provider 1.1 Frame-
work ≤Tw 2.81.0.0 C
τu.NET ≤v TΦkOd\¡ΩTA@kObW÷@
U½kΣB∩uevAMß°ANiH CSDK Cb
C:\windows\assembly UAziH IBM.Data.Informix O 2.81.0.0 C
pGzíúObúñ⌡µAhb GAC ñMΣwn²≤C
1-2 IBM Informix .NET Provider ΓU
ϕ 1-1 π IBM Informix .NET Framework ≤mG
ϕ 1-1. .NET Framework ≤m
≤Ω@ Framework m
IBM Informix .NET Provider 1.1 Framework %INFORMIXDIR%\bin\netf11
IBM Informix .NET Provider 2.0 Framework %INFORMIXDIR%\bin\netf20
≥≤ .NET w≈εtGAbúñ⌡µzíAzWzΣñ@
Aúα GAC CpGz Microsoft Visual Studio .NETA¿U
CBJ sWG
1. buΦv°íñA½kΣ÷@UC
2. ÷@Us²s²≤C≤WO IBM.Data.Informix.dllCznú
Aq %INFORMIXDIR%\bin\netf20 %INFORMIXDIR%\bin\netf11 Ω¿ñ
∩C
3. ∩≤AMß÷@UC
4. ÷@UTwC
Ynτu.NET ≤vA½kΣ÷@UAMß∩eC
Ωw°A
b IBM Informix .NET Provider sSwΩw°AWΩwAz
²H informix ¡∩°AW sysmaster Ωw⌡µ cdotnet.sql ScriptC
.NET Provider Owº[
IBM Informix .NET Provider Σs IBM Informix Ωw .NET
OM≥ªOC 3-6yΣ .NET zπΣ½≤BeΦ
kC 3-6yΣ .NET ≥ªOzπΣ≥ªOCpi@B
ΩTA\ Microsoft .NET Framework SDK σ≤C
b .NET Framework ñA∩Ω ΣΩsO ADO.NET O Bz
(ADO.NET Nϕ .Net ¡xWuActiveX Ω½≤v)C .NET Framework O@
.NET íú⌡µ⌠A MíC ADO.NET ]tΓDn≤GΩ
OM .NET úOC
DataSet ½≤NϕOΘñΩ (bu¼AU)C .NET í DataSet
@ΩCDataTable M DataColumn Nϕ ϕµΣµCDataRelation
Nϕhϕµºí÷YApWUNC
ϕzqΩwΩANq°AπGAMßb±J DataSet ñºe
²α½¿ XMLCπGxsbßWC]AΩOUpUnCpG
únΩAOob SELECT »zíñ MAX ROWSC
úΩsDn IBM Informix .NET Provider OpUG
v IfxConnection-- sΩwzµ÷C
v IfxCommand-- Xo SQL ⁿOC
v IfxDataReader-- ¬VΩO²ΩyC
1 IBM Informix .NET Provider º[ 1-3
v IfxTransaction-- εµ÷C
v IfxDataAdapter-- NΩ±JΩΩ≤PΩw≤@PC
UC .NET Provider Oi²z 2.0 [c .NET Provider oPúL÷
íXG
v DbProviderFactory
v DbConnectionStringBuilder
v DbCommand
IfxDataReader ½≤iHtqΩwΩCúLAΩO¬AzbGñuα
@@ºO²aVeCúP≤ DataSet ½≤AIfxDataReader ½≤úsϕ
µ OsΩAHOΘC
pGΩbßWw≤Aziα µNo≤MΩwCziHQΩ
wϕµDnΣ TObϕµñ≤s TεCCpGu≤sµ@ϕµAziH
IfxCommandBuilder O Ω≤PΩw≤@P (\ 1-5
y DataSet ≤PΩw≤@Pz)Cp IfxCommandBuilder O÷Ω
TA\ 3-20yIfxCommandBuilder OzC
ú¼⌡µⁿw
u IBM Informix .NET Provider ¼RA¿ πw⌡µⁿSC²P
qh⌡µⁿiµIsAúO⌠≤¼Ω@wwC
WíD
IBM Informix .NET Provider WíOGIBM.Data.InformixCoϕ IBM Informix
.NET Provider ñπ½≤WúOH IBM.Data.Informix YCpAIfxConnection
πWO IBM.Data.Informix.IfxConnectionC
YúQnΘJC@½≤πWíAziHJWíCT@k°z
í]pyÑwCC++ yÑ÷Σr usingCpGOH C++ ]píAziH
bY[Jo@µ WíG
using IBM.Data.Informix;
sΩw
ziH IfxConnection ½≤ Open Φk sΩwC znNsurΩ
IfxConnection ½≤AHwqp≤sΩwΦ÷ΩT (pAΩwb
≈M°A)CsurΩµípUG
attribute=value[;attribute=value]...
ΦA ([]) Mñ (...) úOrΩ@íCªϕ@u/t∩vºß
ΣL/t∩úO∩ABiH[J⌠Nqt∩CH
ju/t∩vC
3-22 yIfxConnection Oz@ñπCXiαAΣñ]í
IfxConnection ¼ΣΦkPeC
1-4 IBM Informix .NET Provider ΓU
pGz Microsoft Visual StudioAhiHzL°Φí suG
1. quπcuΩvñN IfxConnection Σñ@ϕµWC
2. ÷@Us IfxConnection ½≤ ConnectionString eC
3. ÷@U ConnectionString σrñXñ (...) ÷sCo∩C
4. ±g∩ úsuΩTC÷@U∩uív÷s o∩
kC
UCqπ∩≤W testserver IBM Informix °AW@W testdb Ω
wísuA°A≤W berry ≈WG
IfxConnection conn=new IfxConnection("Host=berry; Service=9401;Server=testserver;User ID=informix; password=ifxtest;Database=testdb");
conn.Open();
úF ConnectionString eºAIfxConnection ½≤]iHq Setnet í⌠
n²ñ Mwsue (pAoiHMw DELIMIDENT M OPTOFC )Cp
GsurΩñ]weAh IfxConnection ½≤oCpGbsurΩñ
]weAh⌠]wC∩≤]w⌠≤eAIfxConnection ½≤
Setnet n²ñC
: FXúAúDzN DELIMIDENT ∩] NAh IBM Informix
.NET Provider w DELIMIDENT O] YC
ϕíúAΩwA÷¼suApUCqG
conn.Close();
: surΩWújpgA²ΣqjpgC
DataSet ≤PΩw≤@P
pGz IfxDataAdapter ½≤qΩwΩAMß≤ΩñΩAh
IfxCommandBuilder Oi²zú INSERTBDELETE UPDATE ⁿOAo
≤PΩw≤@PC 4-3yNΩ DataSetz ñddp≤
IfxDataAdapter ½≤C 4-4y IfxCommandBuilder ½≤ ≤PΩw
≤@Pzñddp≤ IfxCommandBuilder ½≤C
ϕzHzn⌡µ SELECT »zí ]w IfxDataAdapter ½≤ SelectCommand
eANlúΩ@P SQL »zíCMßAϕz
IfxCommandBuilder ½≤ANú≤µ@ϕµ≤s SQL »zíAΩ
≤PΩw≤@PCIfxCommandBuilder ½≤@P IfxDataAdapter ½≤÷
p (@∩@÷Y)C
z SelectCommand e⌡µ SELECT »zíA@DnΣ
@µCpGΓúúsbAh InvalidOperation º¼pA]úú@
PⁿOC
IfxCommandBuilder ½≤]z⌡µ SELECT »zí IfxCommand
ConnectionBCommandTimeout Transaction e (H SelectCommand e ]w)C
1 IBM Informix .NET Provider º[ 1-5
pG∩Σñ⌠≤eA≤½ SELECT »zí¡AhzIs
IfxCommandBuilder.RefreshSchema ΦkChAInsertCommandBUpdateCommand
DeleteCommand eOdlC
IfxCommandBuilder.Dispose Φkú IfxCommandBuilder ½≤P IfxDataAdapter ½
≤÷pA]úAúⁿOC
I f x C o m m a n d B u i l d e r ½≤iαúú S Q L »zíCziH
GetDeleteCommandBGetInsertCommand GetUpdateCommand Φk °½≤ú
ⁿOC
IfxCommandBuilder ½≤UC¡εG
v SELECT »zíbdñ@DnΣ@µC
v SELECT »zíµ@ϕµFúα]t JOIN BΓlxs°C
v SELECT »zí\¬g@µC
v IfxCommandBuilder ½≤úB]úú⌠≤≈ε q SELECT »zíñúΘ
XC
v pGd CommandTextBConnectionBCommandTimeout Transaction ew
≤Ahz⌡µ IfxCommandBuilder.RefreshSchema ΦkC
v IfxCommandBuilder ½≤ú UPDATE M DELETE ⁿOAú≤b
SELECT ¬Ωºß≤Ωwñw∩⌠≤εCC
v I f xCommandBu i l d e r ½≤O Bzµ@Bú÷ϕµCzúα
IfxCommandBuilder ½≤ ≤sπDnΣ/íΣ÷YϕµC
v pG SELECT ⁿOñµ]tSϕrApµByIBDrA
hzúα IfxCommandBuilder ½≤AúDbúdñϕµMµWWA
QuotePrefix M QuoteSuffix e ⁿwwrC
3-1 3 , y¼ΩTzñíHd IfxDataAdapterB
IfxCommandBuilder ΣLOC
suxs
suxs≈εi²ßí½suAúbC IBM Informix .NET
Provider nsΩwssuC
F²su±xsHAϕzíúAsuAz÷¼s
uCYn½AsueO¼AA²Ms°AC
ziH PoolingBMax Pool SizeBConnection Life Time Min Pool Size sur
Ω εsuxsC
]w FullTrust \iv
F IBM Informix .NET ProviderAIsí]w FullTrust \ivC
1-6 IBM Informix .NET Provider ΓU
? O
ziH (?) SQL »zíxsñmC] IBM Informix
.NET Provider LksoWAHzH T C
IfxParameter ½≤sW IfxParameterCollection ½≤∩m
Od ? mCziH ParameterCollection.Add ΦkNsWXC
C
IBM Informix .NET Provider Σ UPDATE M INSERT »zíñΘJCC
oi²íµ@ⁿO ⁿw@CABoiH@íe°
AC
Isxs
YnbíñxsAb IfxCommand ½≤ñ]wUCeG
v CommandText - ]xsW
v CommandType - ] StoredProcedure
ziH IfxCommandBuilder.DeriveParameters Φk xs÷ΩTC
pGxs@AhzíNsW IfxCommand ½≤
XñC
4-5yIsxsz@ñdπp≤⌡µxs¬⌠≤
GC
IfxProviderFactory ½≤gPΩwL÷íX
q .NET Provider 2 lAziH IfxProviderFactory O gPΩwL
֒XC
p IfxProviderFactory O÷ΩTA\ 3-58C
íµ÷
unN Enlist surΩ] trueByes 1AzíNiHNsuCJ
íµ÷Cbíµ÷AnN Pooling surΩ] trueByes 1C
4-6yíµ÷zdíp≤bíñíµ÷C
: zL Microsoft Distributed Transaction Coordinator (MS DTC) iΣíµ
÷CMS DTC ≤nIs@ⁿzíXAovTiwhA
]iαCαC
1 IBM Informix .NET Provider º[ 1-7
ADO.NET @≥ªO@δgíΦí
.NET Framework 2.0 ú@W System.Data.Common WíAW
íú@≥ªOA⌠≤ .NET Ωúúi@OCoU≤¿@δ
ADO.NET ΩwíoΦkAúí]pC Informix .NET Data
Provider for .NET Framework 2.0 ñDnO System.Data.Common ≥ª
OC]A@δ ADO.NET ízL Informix .NET Data Provider
Dynamic Server ΩwC
UC C++ íXdΩwsu@δΦkC
DbProviderFactory factory = DbProviderFactories.GetFactory("IBM.Data.Informix");DbConnection conn = factory.CreateConnection();DbConnectionStringBuilder sb = factory.CreateConnectionStringBuilder();
if( sb.ContainsKey( "Database" ) )
sb.Remove( "database" );sb.Add( "database", "SAMPLE" );
conn.ConnectionString = sb.ConnectionString;
conn.Open();
DbProviderFactory ½≤O@δ ADO.NET íICo½≤ .NET
Ωú½≤@δΩApsuBΩtBⁿOΩ¬Ai B
zSwΩwúCbWzdñAJ GetFactory Φkñ "IBM.Data.Informix"
rΩTⁿw Informix .NET Data ProviderAHl]w DbProviderFactory Ω
Informix .NET Data Provider MΩwú½≤ΩCN
IfxConnection ½≤@ (ΩWO DbConnection)ADbConnection ½≤]iH
s Dynamic Server ΩwCziH DbConnectionStringBuilder O MwΩ
úsurΩ÷ΣrAúqsurΩCWzdíXd Informix
.NET Data Provider ñOXW "database" ÷ΣrApGAhús
urΩ s SAMPLE ΩwC
Tº
IBM Informix °ATºOH IBM Informix .NET Provider º¼p ϕ
C
l
íiH]w IFXDOTNETTRACE ⌠ lC
]w Nq
0 úl
1 QX l API iJM⌠
2 QX l API iJM⌠Al API
v 0--úl
v 1--QX l API iJM⌠
v 2--QX l API iJM⌠Al API
1-8 IBM Informix .NET Provider ΓU
lΩTgJzH IFXDOTNETTRACEFILE ⌠]wñC
1 IBM Informix .NET Provider º[ 1-9
1-10 IBM Informix .NET Provider ΓU
2 ∩MΩ¼
e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-1Ω . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-1]wΩ¼ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-2FLOATBDECIMAL MONEY Ω¼πµí . . . . . . . . . . . . . . . . . . . . . 2-2
e
í IBM Informix ΩwM .NET Framework ºí∩MΩ¼ΦíCª]AG
v IfxDataReader M IfxDataAdapter ½≤qΩwΩAp≤∩MΩ¼
v p≤∩MΩ¼ ( IfxParameter ½≤)
Ω
ϕ 2-1 πC@ Informix Ω¼B xsΩ¼¼AHAX
.NET Framework Ω¼CzL IfxDataReader sΩA¼C
AX .NET ¼Oⁿ IfxDataAdapter ½≤±J DataSet ½≤¼C
ziHUC¼HΣL¼ApAziH IfxDataReader.GetString Φk
oixsb IBM Informix Ωwñ⌠≤Ω¼C¼Bú
n≤C
ϕ 2-1. IBM Informix Ω¼AX¼
Informix Ω¼ ¼ AX .NET Ω¼
BLOB IfxBlob Byte[]
BOOLEAN Boolean Boolean
BYTE Byte[] Byte[]
CHAR String String
CHAR(1) String String
CLOB IfxClob Byte[]
DATE IfxDateTime DateTime
DATETIME IfxDateTime DateTime
DECIMAL(p<=28) Tw IfxDecimal Decimal
DECIMAL (p<=28) BI IfxDecimal Double
DECIMAL (p>28) IfxDecimal String
DOUBLE Double Double
FLOAT Double Double
INTEGER Int32 Int32
INT8 Int64 Int64
INTERVALA-δ IfxMonthSpan String
INTERVALAΘ-p IfxTimeSpan TimeSpan
LVARCHAR String String
© Copyright IBM Corp. 2003, 2007 2-1
ϕ 2-1. IBM Informix Ω¼AX¼ (≥)
Informix Ω¼ ¼ AX .NET Ω¼
MONEY IfxDecimal P≤ DecimalAδTP
NCHAR String String
REAL Float Float
SERIAL nt32 Int32
SERIAL8 Int64 Int64
SMALLFLOAT Float Float
TEXT String String
VARCHAR String String
: p I fxDa taReade r .Ge tS t r ing Φk In fo rmix Ω¼
(DECIMALBMONEYBDATETIME INTERVAL) µíA\ IBM
Informix Guide to SQL: Syntax ñ÷≤uσrεCvqC
: ROW M TEXT ¼X¼ (LISTBMULTISETBSET) iH∩MrΩσ
r .NET Framework ¼ABiH IfxDataReader.GetString Φk sC
IBM Informix Guide to SQL: Syntax ñ÷≤uσrεCvqírΩ
µíC
F≤µaϕF⌠≤¼rΩσrArΩñúemC ROW ¼t⌠
≤rΩσrµ (úO) @YMCoOFK@
w ID y¿VcC
]wΩ¼
bzíñ¿qN¼] Informix ¼ ( IfxParameter c
l IfxType )C 3-69yIfxType Czπ IfxType CC
ziH∩N¼ⁿw .NET DbTypeAIBM Informix .NET Provider µ
Informix ¼C.NET DbType iHⁿw .NET Framework Ωú Param-
eter ½≤Ω¼C DbType ¼ (p GUID) ∩M⌠≤ Informix ¼A
HC DbType ¼ (p AnsiString) iH∩M Informix ¼A
p VARCHARBTEXT BLOBFzNGIBM Informix .NET Provider ú@
w∩z µΩ¼C
pGúⁿw Informix Ω¼ .NET DbTypeAh IBM Informix .NET Provider
q¡ Informix Ω¼C±ΦíApG 4AhúN∩M
INTEGER Ω¼Cαo∩MiαPLkwGC
FLOATBDECIMAL MONEY Ω¼πµí
Informix FLOATBDECIMAL MONEY Ω¼πµíOH DBMONEY
CLIENT_LOCALE ⌠ ⁿwC
DBMONEY ⌠u²≤ CLIENT_LOCALE ⌠CpGú]w DBMONEYA
hyÑ⌠]w (CLIENT_LOCALE) µíCw]ADBMONEY
2-2 IBM Informix .NET Provider ΓU
]⌠M@I ($.)A CLIENT_LOCALE ]ⁿíσ (en_us.CP1252)C±
ΦíApG]w DBMONEY=PtAhj¿rI (,)Cp 169.0 HrI
µíG169,0C
Informix .NET Provider UCu² MwπµíG
1. surΩ
2. ⌠
3. n² (SetNet ]w)
surΩñm½ΣL]wCp÷ΩTA\ IBM Informix Guide to
SQL: ReferenceC
2 ∩MΩ¼ 2-3
2-4 IBM Informix .NET Provider ΓU
3 ¼ΩT
Σ .NET . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-6Σ .NET ≥ªO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-6¼yk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-7IfxBlob O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-8
IfxBlob íσ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-8 IfxBlob . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-8
IfxBlob cl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-8IfxBlob e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-9IfxBlob Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-10
IfxBlob.Close . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-10IfxBlob.FromFile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-10IfxBlob.GetLocator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-10IfxBlob.Lock. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-10IfxBlob.Open . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-10IfxBlob.Read. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-11IfxBlob.Release . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-11IfxBlob.Seek . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-11IfxBlob.ToFile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-11IfxBlob.Truncate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-12IfxBlob.Unlock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-12IfxBlob.Write . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-12
IfxClob O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-12IfxClob íσ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-12 IfxClob . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-13
IfxClob cl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-13IfxClob e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-13IfxClob Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-14
IfxClob.Close . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-14IfxClob.FromFile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-14IfxClob.GetLocator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-15IfxClob.Lock. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-15IfxClob.Open . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-15IfxClob.Read. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-15IfxClob.Release . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-15IfxClob.Seek . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-16IfxClob.ToFile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-16IfxClob.Truncate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-16IfxClob.Unlock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-16IfxClob.Write . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-16
IfxCommand O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-17 IfxCommand . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-17
IfxCommand cl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-17IfxCommand e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-17IfxCommand Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-18
IfxCommand.Cancel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-18IfxCommand.CreateParameter . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-18IfxCommand.ExecuteNonQuery . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-18IfxCommand.ExecuteReader . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-18IfxCommand.ExecuteScalar . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-19IfxCommand.Prepare . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-19
© Copyright IBM Corp. 2003, 2007 3-1
IfxCommand d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-19IfxCommandBuilder O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-20 IfxCommandBuilder . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-20
IfxCommandBuilder cl . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-20IfxCommandBuilder e . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-20IfxCommandBuilder Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-21
IfxCommandBuilder.DeriveParameters . . . . . . . . . . . . . . . . . . . . . . . . . 3-21IfxCommandBuilder.GetDeleteCommand . . . . . . . . . . . . . . . . . . . . . . . . 3-21IfxCommandBuilder.GetInsertCommand . . . . . . . . . . . . . . . . . . . . . . . . 3-21IfxCommandBuilder.GetUpdateCommand . . . . . . . . . . . . . . . . . . . . . . . . 3-21IfxCommandBuilder.RefreshSchema . . . . . . . . . . . . . . . . . . . . . . . . . 3-21
IfxCommandBuilder d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-21IfxConnection O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-22 IfxConnection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-22
IfxConnection cl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-22IfxConnection e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-22
ConnectionString e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-23UserDefinedTypeFormat e . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-25
IfxConnection Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-25IfxConnection.BeginTransaction . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-25IfxConnection.ChangeDatabase . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-26IfxConnection.Close . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-26IfxConnection.CreateCommand . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-26IfxConnection.GetIfxBlob . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-26GetIfxClob . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-26IfxConnection.EnlistTransaction . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-26IfxConnection.Open . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-26
IfxConnection ≤ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-26d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-26
IfxConnectionStringBuilder O . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-27 IfxConnectionStringBuilder . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-27IfxConnectionStringBuilder e . . . . . . . . . . . . . . . . . . . . . . . . . . 3-27IfxConnectionStringBuilder Φk . . . . . . . . . . . . . . . . . . . . . . . . . . 3-27
IfxConnectionStringBuilder.Add . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-27IfxConnectionStringBuilder.AppendKeyValuePair . . . . . . . . . . . . . . . . . . . . . 3-28IfxConnectionStringBuilder.Clear . . . . . . . . . . . . . . . . . . . . . . . . . . 3-28IfxConnectionStringBuilder.ContainsKey . . . . . . . . . . . . . . . . . . . . . . . . 3-28IfxConnectionStringBuilder.EquivalentTo . . . . . . . . . . . . . . . . . . . . . . . . 3-28IfxConnectionStringBuilder.Remove . . . . . . . . . . . . . . . . . . . . . . . . . 3-28IfxConnectionStringBuilder.ToString . . . . . . . . . . . . . . . . . . . . . . . . . 3-28IfxConnectionStringBuilder.TryGetValue . . . . . . . . . . . . . . . . . . . . . . . . 3-28
IfxDataAdapter O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-28 IfxDataAdapter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-28
IfxDataAdapter cl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-28IfxDataAdapter e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-29IfxDataAdapter Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-30
IfxDataAdapter.Fill . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-30IfxDataAdapter.FillSchema . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-30IfxDataAdapter.GetFillParameters . . . . . . . . . . . . . . . . . . . . . . . . . . 3-30IfxDataAdapter.Update. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-30
IfxDataAdapter d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-30IfxDataReader O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-31
IfxDataReader e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-32IfxDataReader Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-32
IfxDataReader.Close . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-32IfxDataReader.GetBoolean . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-32
3-2 IBM Informix .NET Provider ΓU
IfxDataReader.GetByte . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-32IfxDataReader.GetBytes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-32IfxDataReader.GetChar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-32IfxDataReader.GetChars . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-32IfxDataReader.GetData . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-32IfxDataReader.GetDateTime . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-32IfxDataReader.GetDataTypeName . . . . . . . . . . . . . . . . . . . . . . . . . . 3-32IfxDataReader.GetDecimal . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-32IfxDataReader.GetDouble . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.GetFieldType . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.GetFloat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.GetGuid . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.GetInt16 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.GetInt32 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.GetInt64 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.GetName . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.GetOrdinal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.GetSchemaTable . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.GetString . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.GetTimeSpan . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.GetValue . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.GetValues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.IsDBNull . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.NextResult . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-33IfxDataReader.Read . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-34
IfxDataReader d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-34IfxDataSourceEnumerator O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-34 IfxDataSourceEnumerator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-35IfxDataSourceEnumerator e . . . . . . . . . . . . . . . . . . . . . . . . . . 3-35IfxDataSourceEnumerator Φk . . . . . . . . . . . . . . . . . . . . . . . . . . 3-35
IfxDataSourceEnumerator.GetDataSources . . . . . . . . . . . . . . . . . . . . . . . . 3-35IfxDateTime c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-35 IfxDateTime . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-36
IfxDateTime cl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-36IfxDateTime e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-37IfxDateTime Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-38
IfxDateTime.Add . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-38IfxDateTime.AddDays . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-38IfxDateTime.AddMilliseconds . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-38IfxDateTime.AddMinutes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-38IfxDateTime.AddMonths . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-39IfxDateTime.AddSeconds . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-39IfxDateTime.AddYears . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-39IfxDateTime.Compare . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-39IfxDateTime.CompareTo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-40IfxDateTime.DaysInMonth . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-40IfxDateTime.Equals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-40IfxDateTime.GetHashCode . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-40IfxDateTime.GreaterThan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-40IfxDateTime.GreaterThanOrEqual . . . . . . . . . . . . . . . . . . . . . . . . . . 3-40IfxDateTime.LessThan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-41IfxDateTime.LessThanOrEqual . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-41IfxDateTime.NotEquals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-41IfxDateTime.Parse . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-41IfxDateTime.ToString . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-42
IfxDecimal c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-42
3 ¼ΩT 3-3
IfxDecimal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-42IfxDecimal cl. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-42
IfxDecimal e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-43IfxDecimal Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-43
IfxDecimal.Abs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-43IfxDecimal.Add . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-43IfxDecimal.Ceiling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-43IfxDecimal.Clone . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-44IfxDecimal.Compare . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-44IfxDecimal.CompareTo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-44IfxDecimal.Divide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-44IfxDecimal.Equals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-44IfxDecimal.Floor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-44IfxDecimal.GetHashCode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-45IfxDecimal.GreaterThan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-45IfxDecimal.GreaterThanOrEqual . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-45IfxDecimal.LessThan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-45IfxDecimal.LessThanOrEqual. . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-45IfxDecimal.Max . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-45IfxDecimal.Min . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-45IfxDecimal.Modulo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-46IfxDecimal.Multiply . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-46IfxDecimal.Negate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-46IfxDecimal.NotEquals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-46IfxDecimal.Parse . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-46IfxDecimal.Remainder . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-46IfxDecimal.Round . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-46IfxDecimal.Subtract . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-47IfxDecimal.ToString . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-47IfxDecimal.Truncate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-47
IfxError O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-47IfxError e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-48
IfxErrorCollection O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-48IfxErrorCollection e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-48IfxErrorCollection Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-48
IfxErrorCollection.GetEnumerator . . . . . . . . . . . . . . . . . . . . . . . . . . 3-48IfxException O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-48
IfxException e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-48IfxMonthSpan c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-49 IfxMonthSpan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-49
IfxMonthSpan cl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-49IfxMonthSpan e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-49IfxMonthSpan Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-50
IfxMonthSpan.Add . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-50IfxMonthSpan.Compare . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-50IfxMonthSpan.CompareTo . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-50IfxMonthSpan.Divide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-51IfxMonthSpan.Duration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-51IfxMonthSpan.Equals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-51IfxMonthSpan.GetHashCode . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-51IfxMonthSpan.GreaterThan . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-51IfxMonthSpan.GreaterThanOrEqual . . . . . . . . . . . . . . . . . . . . . . . . . . 3-51IfxMonthSpan.LessThan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-51IfxMonthSpan.LessThanOrEqual. . . . . . . . . . . . . . . . . . . . . . . . . . . 3-52IfxMonthSpan.Multiply . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-52IfxMonthSpan.Negate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-52
3-4 IBM Informix .NET Provider ΓU
IfxMonthSpan.NotEquals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-52IfxMonthSpan.Parse . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-52IfxMonthSpan.Subtract. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-53IfxMonthSpan.ToString . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-53
IfxParameter O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-53 IfxParameter O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-54
IfxParameter cl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-54IfxParameter e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-55IfxParameter d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-55
IfxParameterCollection O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-56 IfxParameterCollection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-56IfxParameterCollection e . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-57IfxParameterCollection Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-57
IfxParameterCollection.Add . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-57IfxParameterCollection.Clear . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-57IfxParameterCollection.Contains . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-57IfxParameterCollection.CopyTo . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-57IfxParameterCollection.GetEnumerator . . . . . . . . . . . . . . . . . . . . . . . . . 3-58IfxParameterCollection.IndexOf . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-58IfxParameterCollection.Insert . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-58IfxParameterCollection.Remove . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-58IfxParameterCollection.RemoveAt . . . . . . . . . . . . . . . . . . . . . . . . . . 3-58
IfxProviderFactory O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-58IfxProviderFactory Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-58
IfxProviderFactory.CreateConnectionStringBuilder . . . . . . . . . . . . . . . . . . . . . 3-58IfxProviderFactory.CreateConnection . . . . . . . . . . . . . . . . . . . . . . . . . 3-58IfxProviderFactory.CreateCommand. . . . . . . . . . . . . . . . . . . . . . . . . . 3-59IfxProviderFactory.CreateParameter . . . . . . . . . . . . . . . . . . . . . . . . . . 3-59IfxProviderFactory.CreateCommandBuilder . . . . . . . . . . . . . . . . . . . . . . . 3-59IfxProviderFactory.CreateDataAdapter . . . . . . . . . . . . . . . . . . . . . . . . . 3-59IfxProviderFactory.CreateDataSourceEnumerator . . . . . . . . . . . . . . . . . . . . . . 3-59IfxProviderFactory.CreatePermission ( PermissionState ) . . . . . . . . . . . . . . . . . . . 3-59
IfxSmartLOBCreateTimeFlags C . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-60IfxSmartLOBFileLocation C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-60IfxSmartLOBLocator O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-60IfxSmartLOBLockMode C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-61IfxSmartLOBOpenMode C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-61IfxSmartLOBWhence C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-61IfxTimeSpan c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-62 IfxTimeSpan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-62
IfxTimeSpan cl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-62IfxTimeSpan e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-63IfxTimeSpan Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-64
IfxTimeSpan.Add . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-64IfxTimeSpan.Compare . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-64IfxTimeSpan.CompareTo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-64IfxTimeSpan.Divide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-64IfxTimeSpan.Duration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-65IfxTimeSpan.Equals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-65IfxTimeSpan.GetHashCode . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-65IfxTimeSpan.GreaterThan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-65IfxTimeSpan.GreaterThanOrEqual . . . . . . . . . . . . . . . . . . . . . . . . . . 3-65IfxTimeSpan.LessThan. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-65IfxTimeSpan.LessThanOrEqual . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-65IfxTimeSpan.Negate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-66IfxTimeSpan.NotEquals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-66
3 ¼ΩT 3-5
IfxTimeSpan.Parse . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-66IfxTimeSpan.ToString . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-66
IfxTimeUnit C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-67IfxTransaction O . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-68
IfxTransaction e . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-68IfxTransaction Φk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-68
IfxTransaction.Commit. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-68IfxTransaction.Rollback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-68
IfxTransaction d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-68IfxType C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-69
íOú≤Wí IBM.Data.InformixCpAIfxConnection O
πO IBM.Data.Informix.IfxConnectionC
Σ .NET
3-7ϕ 3-2 π IBM Informix .NET Provider (A≤ 1.1 .NET Framework M
2.0 .NET Framework) Ω@ Microsoft .NET C
p Microsoft MOi@BΩTA\ Microsoft .NET Framework SDK
σ≤CpG IBM Informix .NET Provider úΣSw .NET OΦkAhO
ΦkΩ@¿L@C
ϕ 3-1. IBM Informix .NET Provider OΩ@
O í
IfxCommand IDbCommand NϕϕísΩw⌡µdⁿO
IfxCommandBuilder DbCommandBuilder úµ@ϕµ INSERTBDELETE UPDATE ⁿ
OAOΩ≤P÷p IBM Informix
Ωw≤@P
IfxConnection IDbConnection NϕíPYΩ ºíMÑq@
IfxDataAdapter IDbDataAdapter i²í∩Ωw⌡µ SQL ⁿOB±JΩ
Ω≤PΩw≤@P
IfxDataReader IDDataReader e\HVB¬Φí sΩwΩΩy
IfxError Nϕ IBM Informix ΩwúiΩ
IfxErrorCollection ICollection Nϕ IfxException ½≤ñ@ IfxError ½≤
IfxException Nϕϕ IBM Informix Ωwiú
º¼p
IfxParameter IDbDataParameter Ω@ⁿOAN∩MΩµ
IfxParameterCollection IDbParameterCollection Ω@ⁿOhANo∩MΩ
µ
IfxTransaction IDbTransaction Nϕµ÷
Σ .NET ≥ªO
ϕ 3-1 π IBM Informix .NET Provider (.NET 2.0 Framework ) Ω@ Microsoft
.NET ≥ªOC
3-6 IBM Informix .NET Provider ΓU
p Microsoft Oi@BΩTA\ Microsoft .NET Framework SDK σ≤C
pG IBM Informix .NET Provider úΣSw .NET ≥ªOAhOΩ@¿
L@C
ϕ 3-2. IBM Informix .NET Provider OΩ@≥ªO
O ≥ªO í
IfxCommand DbCommand NϕϕísΩw⌡µdⁿO
IfxCommandBuilder DBCommandBuilder úµ@ϕµ INSERTBDELETE UPDATE ⁿ
OAOΩ≤P÷p IBM Informix
Ωw≤@P
IfxConnection DbConnection NϕíPYΩ ºíMÑq@
IfxConnectionStringBuilder DbConnectionStringBuilder ú≤l¬¼surΩm
(OdbcConnectionStringBuilder M
SQLconnectionStringBuilder) ≥ªOC
IfxDataAdapter DbDataAdapter i²í∩Ωw⌡µ SQL ⁿOB±JΩ
Ω≤PΩw≤@P
IfxDataReader DbDataReader e\HVB¬Φí sΩwΩΩy
IfxDataSourceEnumerator DbDataSourceEnumerator i²ΩúoΩ MµC
IfxParameter DbParameter Ω@ⁿOAN∩MΩµ
IfxParameterCollection DbParameterCollection Ω@ⁿOhANo∩MΩ
µ
IfxProviderFactory DbProviderFactory Nϕ@ΦkAziH úΩ@Ω
OΩC
IfxTransaction DbTransaction Nϕµ÷
¼yk
] IBM Informix .NET Provider ½≤i≤\húPí]pyÑñAH
ΓUΩX ϕΦk¼CΩXykpUG
.-,-----------------------.V |
>>-+--------+--returntype--methodname--(----+---------------------+-+--)-><’-static-’ ’-parmtype--parmlabel-’
returntype
oO½≤¼CpGΦk⌠≤Ah voidC
methodname
ΦkWC
parmtype
MµñbmWw½≤¼C
parmlabel
WCuOΦK≤σrñϕCW@HΘπ (Ybσr
ñ]@)C
pG static ÷ΣrAhϕúOΩNiHIsΦkCO¡W
NOΩCb Visual Basic ñAo Shared ΦkCb C++ ñAo
static ΦkC
3 ¼ΩT 3-7
dG: pG IfxDecimal.Floor ΦkO staticAhⁿµ@ IfxDecimalCoϕpG mydec
O IfxDecimal ΩAhziH∩ΣIs floorApGIfxDecimal.Floor
(mydec)C²úαoIsGmydec.Floor(mydec)C
cl¼ykPWzykPAtOub≤ static M returntypeC
IfxBlob O
IfxBlob Nϕ BLOBABLOB O@iH≈sej¼GiΩ⌠CjPWA
BLOB iH°@tCziHbñ¬gJYmA²ú¬g
JmºeΩC
BLOB M CLOB úOz¼j¼½≤¼CoΓ¼@\hPΦkC BLOB
P CLOB tOb≤ CLOB ñΩQ°σrrA² BLOB ñΩhú°
σrrC BLOB ñΩQ°GiΩAϕΩJ/XΩw°AAú
⌡µ⌠≤¼α½C
IfxBlob íσ
C@ IfxBlob ú@íⁿⁿV BLOB ñ@mCbΓUñNΩ
σC
I f x B l o b ½≤σm°íwC 3 - 6 1
yIfxSmartLOBOpenMode Cz@CXiαíC
b¬gJºßAσ@vTß@rß@rC
IfxBlob.Seek Φki²zTa]wσmC
IfxBlobziHoΦk o IfxBlob ½≤G
v IfxConnection.GetIfxBlob
v IfxDataReader.GetIfxBlob
z]iHcl IfxBlobC
IfxBlob cl
v IfxBlob( IfxConnection connection )
@P connection ÷ps IfxBlobC
3-8 IBM Informix .NET Provider ΓU
IfxBlob e
UCO IfxBlob ½≤eC
ϕ 3-3. IfxBlob e
e ¼ s í
EstimatedSize System.Int64 o]ww⌠ BLOB j
pCpGziHTw⌠j
pAhiH]weCºßA
Ωw°AuπNi
HQoΩTC
úDzTwjpAh
]weCNe]
jP÷OΩw°A
WΩC
ExtentSize System.Int32 o]wϕΩw°Atm
BLOB íN
U@d≥jpC
xsΘqípY½
í n]wtmd≥j
pC
Flags System.Int32 o]w BLOB XC
∩
IfxSmartLOBCreateTimeFlags C
¿ CpΩ
TA\ 3 - 6 0
yIfxSmartLOBCreateTimeFlags C
zC
IsNull System.Boolean ¬ pGΩOAh trueF
h falseC
IsOpen System.Boolean ¬ pGΩwAh trueF
h falseC
LastAccessTime System.Int32 ¬ Ωw°AWes BLOB
tí (¡Jϕµ)C
Flags eñ]w
KeepAccessTimeA iH
ΩTC
LastChangeTime System.Int32 ¬ Ωw°AWe≤ BLOB
¼Atí (¡Jϕµ
)C
≤sB≤v≤
Ñ≤¼A≤C
LastModificationTime System.Int32 ¬ Ωw°AWegJ BLOB
tí (¡Jϕµ)C
MaxBytes System.Int64 o]w BLOB jpW
¡CΩw°Aú\ BLOB
j≤C
3 ¼ΩT 3-9
ϕ 3-3. IfxBlob e (≥)
e ¼ s í
Null IfxBlob ¬
RA
π IfxBlob ½≤C
Position System.Int64 BLOB ñµσmC
Oq BLOB @
ΓC
ReferenceCount System.Int32 ¬ Ωwñet BLOB
εCC
SBSpace System.String o]wxs BLOB sbspace
WC
Size System.Int64 ¬ o BLOB µjp (H
µ)C
IfxBlob Φk
IfxBlob.Closev void IfxBlob.Close()
÷¼ΩC
IfxBlob.FromFilev void IfxBlob.FromFile( System.String filename, System.Boolean
appendToSmartLOB, IfxSmartLOBFileLocation fileLocation )
N@t filename gJ BLOBCpG appendToSmartLOB O trueAhg
J BLOB CpGO falseAh∩g BLOB µeC
fileLocation ⁿX filename ñϕ≤ß°AWCeúΣ°A
C
IfxBlob.GetLocatorv IfxSmartLOBLocator IfxBlob.GetLocator()
PΩ÷p IfxSmartLOBLocatorC
IfxBlob.Lockv void IfxBlob.Lock( System.Int64 smartLOBOffset, IfxSmartLOBWhence whence,
System.Int64 range, IfxSmartLOBLockMode lockMode )
Φk Ωw BLOB @íCΩw¼ (W@) lockMode MwC
Ωw]wb° range @s≥WCΩwd≥I
smartLOBOffset1 M whence MwCo¼Φíí≤ 3-61
yIfxSmartLOBWhence Cz@ñC
IfxBlob.Openv void IfxBlob.Open( IfxSmartLOBOpenMode mode )
3-10 IBM Informix .NET Provider ΓU
²Φk IfxBlob ΩºßA α¬gJΩCmode M
w\H≤í s CLOBCpUííA\ 3-61
yIfxSmartLOBOpenMode CzC
IfxBlob.Readv System.Int64 IfxBlob.Read( char[] buff )
v System.Int64 IfxBlob.Read( char[] buff, System.Int64 buffOffset, System.Int64
numBytesToRead, System.Int64 smartLOBOffset, IfxSmartLOBWhence whence )
NΩNϕ BLOB ñr¬J buff ñCrNϕhwQ¬
J buff ñC
pGuw buffAhq 0 l ¬J BLOBCo@ΦkbgJúWX
buff CC°j≤w BLOB QIC¬q BLOB ñµσ
mlC
pGúΣLAhq buffOffset lANΦn numBytesToRead
¬J buff ñCpGnDΦk gJC¡ºAhC
bl¬ºeA² whence M smartLOBOffset σCo¼
Φíí≤ 3-61yIfxSmartLOBWhence Cz@ñC
IfxBlob.Releasev void IfxBlob.Release()
pGΩú¬gJΩwAΦk ±ΩΩw°A
ΩCpG BLOB wgJΩwAw]¬Ωw BLOBAIsΦ
kC
IsΦkºßAAΩC
IfxBlob.Seekv System.Int64 IfxBlob.Seek( System.Int64 offset, IfxSmartLOBWhence whence )
≤ BLOB σmCOσZ≈ BLOB YsmC
σsm offset M whence MwCo¼Φíí≤ 3-61
yIfxSmartLOBWhence Cz@ñC
IfxBlob.ToFilev System.String IfxBlob.ToFile( System.String filename, System.IO.FileMode mode,
IfxSmartLOBFileLocation fileLocation )
N BLOB egJ@t filename ñCfileLocation MwNgJß
°ACeúΣ°AC
mode MwΘXΦíCpiíΩTAd\ .NET Frame-
work Owñ System.IO.FileModeC
3 ¼ΩT 3-11
IfxBlob.Truncatev void IfxBlob.Truncate( System.Int64 offset )
b BLOB ñRúm offset ß@eC
IfxBlob.Unlockv void IfxBlob.Unlock( System.Int64 smartLOBOffset, IfxSmartLOBWhence whence,
System.Int64 range )
Φk ú BLOB ñbSwd≥WΩwCúΩwd≥jpO
range C
smartLOBOffset M whence Mwd≥ICo¼Φíí≤ 3-61
yIfxSmartLOBWhence Cz@ñC
IfxBlob.Writev System.Int64 IfxBlob.Write( char[] buff )
v System.Int64 IfxBlob.Write( char[] buff, System.Int64 buffOffset, System.Int64
numBytesToWrite, System.Int64 smartLOBOffset, IfxSmartLOBWhence whence )
N buff ñgJΩNϕ BLOB ñCrNϕwQgJh
C
pGuw buffAhq BLOB µσmlNπCgJ BLOB ñC
pGúΣLAhqC buffOffset lAN buff ñΦn numBytesToWrite
rgJ CLOB ñCpG buffOffset WXC¡AhC
b⌡µgJºeA² whence M smartLOBOffset σCo¼
Φíí≤ 3-61yIfxSmartLOBWhence Cz@ñC
pGgJIWL BLOB µAhqµgJIºí± 0
C
IfxClob O
IfxClob Nϕ CLOBACLOB O@iH≈sej¼rΩ⌠CjPWA
CLOB iH°@tCziHbñ¬gJYmA²ú¬g
JmºeΩC
CLOB M BLOB úOz¼j¼½≤¼CoΓ¼@\hPΦkC CLOB
P BLOB tOb≤ CLOB ñΩ°rDCoϕ CLOB ⁿε≤r
Xα½uyyÑtv(GLS) ΣL\αCpGhrAhb
CLOB ñiαnh ϕ@rC
IfxClob íσ
C@ IfxClob úl@ⁿV CLOB ñYmíⁿCoΩσC
IfxClob ½≤σm°íwCpiαíMµA\
3-61yIfxSmartLOBOpenMode CzC
3-12 IBM Informix .NET Provider ΓU
b¬gJºßAσ@vTß@rßU@rC
IfxClob.Seek Φki²zTa]wσmC
IfxClobziHoΦk o IfxClob ½≤G
v IfxConnection.GetIfxClob
v IfxDataReader.GetIfxClob
z]iHcl IfxClobG
IfxClob cl
v IfxClob( IfxConnection connection )
@P connection ÷ps IfxClobC
IfxClob e
UCO IfxClob ½≤eC
ϕ 3-4. IfxClob e
e ¼ s í
EstimatedSize System.Int64 o]ww⌠ CLOB j
pCpGziHTw⌠j
pAhiH]weCºßA
Ωw°AuπNi
HQoΩTC
úDzTwjpAh
]weCNe]
jP÷OΩw°A
WΩC
ExtentSize System.Int32 o]wϕΩw°Atm
BLOB íN
U@d≥jpC
xsΘqípY½
í n]wtmd≥j
pC
Flags System.Int32 o]w CLOB XC
∩
IfxSmartLOBCreateTimeFlags C
¿ CpΩ
TA\ 3 - 6 0
yIfxSmartLOBCreateTimeFlags C
zC
IsNull System.Boolean ¬ pGΩOAh trueF
h falseC
IsOpen System.Boolean ¬ pGΩwAh trueF
h falseC
3 ¼ΩT 3-13
ϕ 3-4. IfxClob e (≥)
e ¼ s í
LastAccessTime System.Int32 ¬ Ωw°AWes CLOB
tí (¡Jϕµ)C
Flags eñ]w
KeepAccessTimeA iH
ΩTC
LastChangeTime System.Int32 ¬ Ωw°AWe≤ CLOB
¼Atí (¡Jϕµ
)C
≤sB≤v≤
Ñ≤¼A≤C
LastModificationTime System.Int32 ¬ Ωw°AWegJ CLOB
tí (¡Jϕµ)C
MaxBytes System.Int64 o]w CLOB jpW¡
(Hµ)CΩw°A
ú\ CLOB j≤C
Null IfxBlob ¬
RA
π IfxBlob ½≤C
Position System.Int64 CLOB ñµσmC
Oq CLOB @
ΓC
ReferenceCount System.Int32 ¬ Ωwñet CLOB
εCC
SBSpace System.String o]wxs BLOB sbspace
WC
Size System.Int64 ¬ o BLOB µjp (H
µ)C
IfxClob Φk
IfxClob.Closev void IfxClob.Close( IfxSmartLOBOpenMode mode )
÷¼ΩC
IfxClob.FromFilev void FromFile( System.String filename, System.Boolean appendToSmartLOB,
IfxSmartLOBFileLocation fileLocation )
N@t filename gJ CLOBCpG appendToSmartLOB O trueAhg
J CLOB CpGO falseAh∩g CLOB µeC
fileLocation ⁿX filename ñϕ≤ß°AWCeúΣ°A
C
3-14 IBM Informix .NET Provider ΓU
IfxClob.GetLocatorv IfxSmartLOBLocator GetLocator()
PΩ÷p IfxSmartLOBLocatorC
IfxClob.Lockv void Lock( System.Int64 smartLOBOffset, IfxSmartLOBWhence whence, System.Int64
range, IfxSmartLOBLockMode lockMode )
Φk Ωw CLOB @íCΩw¼ (W@) lockMode MwC
Ωw]wb° r a n g e r@s≥rWCΩwd≥I
smartLOBOffset1 M whence MwCo¼Φíí≤ 3-61
yIfxSmartLOBWhence Cz@ñC
IfxClob.Openv void IfxClob.Open( IfxSmartLOBOpenMode mode )
²Φk IfxClob ΩºßA α¬gJΩC mode M
w\H≤í s CLOBCpUííA\ 3-61
yIfxSmartLOBOpenMode CzC
IfxClob.Readv System.Int64 IfxClob.Read( char[] buff )
v System.Int64 IfxClob.Read( char[] buff, System.Int64 buffOffset, System.Int64
numCharsToRead, System.Int64 smartLOBOffset, IfxSmartLOBWhence whence )
NΩNϕ CLOB ñr¬J buff ñCrNϕhwQ¬
J buff ñC
pGuw buffAhq 0 l ¬J CLOBCo@ΦkbgJúWX
buff CC°j≤w CLOB QIC¬q CLOB µσ
mlC
pGúΣLAhq buffOffset lANΦn numCharsToRead r¬
J buff ñCpGnDΦk gJC¡ºAhC
bl¬ºeA² whence M smartLOBOffset σCo¼
Φíí≤ 3-61yIfxSmartLOBWhence Cz@ñC
IfxClob.Releasev void IfxClob.Release()
pGΩú¬gJΩwAΦk ±ΩΩw°A
ΩCpG CLOB wgJΩwAw]¬Ωw CLOBAIsΦ
kC
IsΦkºßAAΩC
3 ¼ΩT 3-15
IfxClob.Seekv System.Int64 IfxClob.Seek( System.Int64 offset, IfxSmartLOBWhence whence )
≤ CLOB σmCO IfxClob.Position sC
σsm offset M whence MwCo¼Φíí≤ 3-61
yIfxSmartLOBWhence Cz@ñC
IfxClob.ToFilev System.String IfxClob.ToFile( System.String filename, System.IO.FileMode mode,
IfxSmartLOBFileLocation fileLocation )
N CLOB egJ@t filename ñCfileLocation MwNgJß
°ACeúΣ°AC
mode MwΘXΦíCpiíΩTAd\ .NET Frame-
work Owñ System.IO.FileModeC
IfxClob.Truncatev void IfxClob.Truncate( System.Int64 offset )
q CLOB YRú offset @eC
IfxClob.Unlockv void IfxClob.Unlock( System.Int64 smartLOBOffset, IfxSmartLOBWhence whence,
System.Int64 range )
Φk ú CLOB ñbSwrd≥WΩwCúΩwd≥jpO
range rC
smartLOBOffset M whence Mwd≥ICo¼Φíí≤ 3-61
yIfxSmartLOBWhence Cz@ñC
IfxClob.Writev System.Int64 IfxClob.Write( char[] buff )
v System.Int64 IfxClob.Write( char[] buff, System.Int64 buffOffset, System.Int64
numCharsToWrite, System.Int64 smartLOBOffset, IfxSmartLOBWhence whence )
N buff ñrgJΩNϕ CLOB ñCrNϕwQgJhrC
pGuw buffAhqµσmlNπCgJ CLOB ñC
pGúΣLAhqC buffOffset lAN buff ñΦn numCharsToWrite
rgJ CLOB ñCpG buffOffset WXC¡AhC
b⌡µgJºeA² whence M smartLOBOffset σCo¼
Φíí≤ 3-61yIfxSmartLOBWhence Cz@ñC
pGgJIWL CLOB µAhqµgJIºí± 0 C
3-16 IBM Informix .NET Provider ΓU
IfxCommand O
IfxCommand ONϕnbΩwñ⌡µ SQL »zíC
IfxCommandziHclΣL½≤UCΦk IfxCommandG
v IfxConnection.CreateCommand (\ 3-26 @C)
YngPúL÷íXAziH D b P r o v i d e r F a c t o r y O
CreateCommand() Φk úS DbCommand ΩC.NET 2.0 Framework w
]t\αC
IfxCommand cl
v IfxCommand()
v IfxCommand( System.String cmdText )
v IfxCommand( System.String cmdText, IfxConnection connection )
v IfxCommand( System.String cmdText, IfxConnection connection, IfxTransaction
transaction )
pGw cmdTextAh@ⁿO SQL »zíC⌡µⁿO connection
M transaction (pGww)C
IfxCommand e
Uϕπ IfxCommand OeC
ϕ 3-5. IfxCommand e
e ¼ í
CommandText System.String o]wn∩Ω ⌡µσrⁿOC
CommandType e≤oeCIBM Informix
ODBC Driver Σ ODBC ESC CykA
IBM Informix .NET Provider ]PΣC
CommandTimeout System.Int32 o]wbε⌡µⁿOMúºe
ÑíC
CommandType System.Data.CommandType ⁿX CommandText eΦíCϕµßí
CommandType eiαC
Connection IfxConnection o]w I f x C o m m a n d ½≤
IfxConnection ½≤C
Parameters IfxParameterCollection o IfxParameterCollection ½≤C
Transaction IfxTransaction o]w⌡µ IfxCommand ½≤µ÷C
UpdatedRowSource System.Data.UpdateRowSource o]wp≤NⁿOGM
IfxDataAdapter.Update Φk DataRowCϕµ
ßí UpdatedRowSource eiαC
CommandType eiHUC⌠≤G
v StoredProcedure--xsWC
v TableDirect--ϕ CommandType e] TableDirect ACommandText e]
nsϕµWCp⌠≤ϕµW]tSϕrAhziαnúo
3 ¼ΩT 3-17
rAp⌡≈ryk[W¡wrCϕzIs IfxCommand O
ExecuteNonQueryBExecuteScalar ExecuteReader ΦkANπWϕµ
εCMµCYnshϕµAHrIjMµ (Lµd)A
tnsϕµWCϕ CommandText eⁿwhϕµANoϕµ
XC
v Text--SQL σrⁿO (w])
UpdatedRowSource eiHUC⌠≤G
v Both--ΘXP@εCú∩M DataSet ½≤ñ≤εCC
v FirstReturnedRecord--@εCñΩ∩M DataSet ½≤ñ≤εCC
v None--ñ⌠≤εCC
v OutputParameters--ΘX∩M DataSet ½≤ñ≤εCC
IfxCommand Φk
IfxCommand.Cancelv void IfxCommand.Cancel()
°⌡µⁿOCpG°ó Aúúº¼pC
IfxCommand.CreateParameterv IfxParameter IfxCommand.CreateParameter()
IfxParameter ½≤sΩC
IfxCommand.ExecuteNonQueryv System.Int32 IfxCommand.ExecuteNonQuery()
∩ IfxConnection ½≤⌡µ SQL »zíCY UPDATEBINSERT DELETE »z
íAhOⁿvTεCF≤ΣL⌠≤»zíAúO -1CpGsuús
bAh InvalidOperationException C
IfxCommand.ExecuteReaderv IfxDataReader IfxCommand.ExecuteReader()
v IfxDataReader IfxCommand.ExecuteReader( System.DataCommandBehavior behav-
ior )
∩ IfxConnection ½≤⌡µ CommandText eñⁿOm IfxDataReader ½≤C
IfxDataReader ½≤ behavior ñⁿOµ mG
v CloseConnection--⌡µⁿOºßA÷¼÷ IfxDataReader ½≤A]÷¼
IfxConnection ½≤C
v Default--diαhGC⌡µdvTΩw¼ACw]ú]w
CommandBehavior XC
v KeyInfo--dµMDnΣΩTC⌡µdúΩw∩εCC
v SchemaOnly--duµΩTAúvTΩw¼AC
v SequentialAccess--² IfxDataReader ½≤α≈Bztj¼GiµεCC
SequentialAccess i² IfxDataReader ½≤HΩyµí ⁿJΩAúⁿJπ
3-18 IBM Informix .NET Provider ΓU
εCCMßAziH IfxDataReader.GetBytes IfxDataReader.GetChars Φk
ⁿwl⌡µ¬@mABΩⁿw@¡εw
jpCⁿw SequentialAccess iHúµ ¬µCMA
bΩΩyñ¬WLYmºßANLkAq IfxDataReader ½≤ñ¬
mmºeΩC
v SingleResult--dµ@GC⌡µdvTΩw¼AC
v SingleRow--wdµ@εCC⌡µdvTΩw¼ACpGzw SQL
»zíu@εCAhⁿw SingleRow iHúíαC
IfxCommand.ExecuteScalarv System.Object IfxCommand.ExecuteScalar()
⌡µdAMßdGñ@εC@µCNñB
µεCC
IfxCommand.Preparev void IfxCommand.Prepare()
∩Ωw (sL) ⁿOC pG CommandType e]
TableDirectAhΦkS@C
IfxCommand d
UCd±JΩBsWßΩTO²AMßN≤≤sΩwC
IfxDataAdapter idap = new IfxDataAdapter("select * from customer",con);
DataSet ds = new DataSet("customer");
idap.Fill(ds,"customer");
DataRow drow = ds.Tables["customer"].NewRow();
drow["lname"]="";
ds.Tables["customer"].Rows.Add(drow);
idap.InsertCommand = new IfxCommand();
idap.InsertCommand.CommandType = CommandType.Text;
idap.InsertCommand.CommandText = "execute procedure add_cust(?,?,?)";
idap.InsertCommand.Connection = con;
IfxParameter iparam1 = idap.InsertCommand.CreateParameter();
IfxParameter iparam2 = idap.InsertCommand.CreateParameter();
IfxParameter iparam3 = idap.InsertCommand.CreateParameter();
iparam1.ParameterName = "fname";
iparam1.Value = "Hoopla";
iparam2.ParameterName = "lname";
iparam2.Value = "MAuie";
iparam3.ParameterName = "company";
iparam3.Value = "Fredonia";
idap.InsertCommand.Parameters.Add(iparam1);
idap.InsertCommand.Parameters.Add(iparam2);
idap.InsertCommand.Parameters.Add(iparam3);
3 ¼ΩT 3-19
//Inform the command object that the update
//results in data being returned and it must be
//updated against the changed row in the
//dataset. The source of the data is in the
//first returned row
idap.InsertCommand.UpdatedRowSource= UpdateRowSource.FirstReturnedRecord;
idap.RowUpdated += new IfxRowUpdatedEventHandler(OnRowUpdated);
idap.InsertCommand.Connection.Open();
idap.Update(ds,"customer");
IfxCommandBuilder O
IfxCommandBuilder Oúµ@ϕµ INSERTBDELETE UPDATE ⁿOA
Ω≤P IBM Informix Ωw÷pΩ≤@PC
IfxCommandBuilder ½≤@P IfxDataAdapter ½≤÷p (@∩@÷Y)C
IfxDataAdapter ½≤ IfxCommand ½≤ ∩Ωw⌡µ SQL ⁿOB±JΩA
HΩ≤PΩw≤@PCun]w IfxDataAdapter ½≤ SelectCommand
eANlúΩ@P SQL »zíC SelectCommand eo
]wn∩Ωw⌡µ SQL SELECT »zíCMßAϕz IfxCommandBuilder
½≤ANú≤µ@ϕµ≤s SQL »zíAΩ≤PΩw
≤@PC(IfxCommandBuilder ½≤¡n²¿ÑAHÑ IfxDataAdapter ½≤
RowUpdating ≤C)
p IfxCommandBuilder ½≤÷ΩTA\ 1-5y DataSet ≤P
Ωw≤@PzC
IfxCommandBuildercl IfxCommandBuilderC
IfxCommandBuilder cl
v IfxCommandBuilder()
v IfxCommandBuilder( IfxDataAdapter adapter )
l]w IfxCommandBuilder OsΩ (∩aP IfxDataAdapter ½≤÷p)C
IfxCommandBuilder e
Uϕπ IfxCommandBuilder OeC
ϕ 3-6. IfxCommandBuilder e
e ¼ í
ConflictOption ⁿw IfxCommandBuilder n ConflictOptionC
DataAdapter IfxDataAdapter o]wnú SQL »zí IfxDataAdapter ½≤C
QuotePrefix System.String o]wϕⁿw IBM Informix °A½≤W (pAϕµµ)
lrFWñi]tµÑrC QuotePrefix uα]
Aúα]JBrΩC
3-20 IBM Informix .NET Provider ΓU
ϕ 3-6. IfxCommandBuilder e (≥)
e ¼ í
QuoteSuffix System.String o]wϕⁿw IBM Informix °A½≤W (pAϕµµ)
rFWñi]tµÑrC QuoteSuffix uα]
Aúα]JBrΩC
IfxCommandBuilder Φk
IfxCommandBuilder.DeriveParametersv void IfxCommandBuilder.DeriveParameters( IfxCommand command )
b IfxCommand ½≤ⁿwxsW÷ΩTAHoΩT ∩g
IfxParameterCollection ½≤C
IfxCommandBuilder.GetDeleteCommandv IfxCommand IfxCommandBuilder.GetDeleteCommand()
oϕíIs IfxDataAdapter.Update ΦkúbΩwW⌡µRú
IfxCommand ½≤C
IfxCommandBuilder.GetInsertCommandv IfxCommand IfxCommandBuilder.GetInsertCommand()
oϕíIs IfxDataAdapter.Update ΦkúbΩwW⌡µíJ
IfxCommand ½≤C
IfxCommandBuilder.GetUpdateCommandv IfxCommand IfxCommandBuilder.GetUpdateCommand()
oϕíIs IfxDataAdapter.Update ΦkúbΩwW⌡µ≤s
IfxCommand ½≤C
IfxCommandBuilder.RefreshSchemav void IfxCommandBuilder.RefreshSchema
½sπz ú INSERTBUPDATE DELETE »zíΩw⌡ΩTC
IfxCommandBuilder d
@dπp≤ IfxCommandBuilder ½≤ ⌡µ≤sC
// IfxConnection -- con
DataSet ds = new DataSet();
string sql = "select fname, lname from customer";
IfxDataAdapter da = new IfxDataAdapter(sql,con);
//Build new CommandBuilder
IfxCommandBuilder ifxbuilder = new IfxCommandBuilder(da);
Con.Open();
Da.Fill(ds,"customer");
3 ¼ΩT 3-21
//code to modify data in DataSet goes here
ds.Tables[0].Rows[0].ItemArray[0] = "William";
//the following line will fail without the IfxCommandBuilder
//as we have not explicitly set an UpdateCommand in the DataAdapter
da.Update(ds,"customer");
dπp≤xs÷ΩTC
// IfxConnection - con
IfxCommand cmd = new IfxCommand("SP_GETUSERINFO",con);
IfxCommandBuilder cb = new IfxCommandBuilder();
Con.Open();
Cb.DeriveParameters(cmd);
foreach (IfxParameter param in cmd.Parameters)
Console.WriteLine(param.ParameterName);
con.Close();
IfxConnection O
IfxConnection ONϕPΩ ºíMÑq@ApAs IBM Informix °
A⌠⌠suCLkOC
IfxConnectionΣL½≤@Φk⌠ta IfxConnection ½≤CYnTaA½≤
Σñ@clC
YngPúL÷íXAziH DbProviderFactory O
CreateConnection() Φk úS DbCommand ΩC.NET 2.0 Framework
w]t\αC
IfxConnection cl
v IfxConnection( )
v IfxConnection( System.String connectionString )
connectionString ñΩT (pGú) l]w IfxConnection O
sΩC
IfxConnection e
Uϕπ IfxConnection OeC
ϕ 3-7. IfxConnection e
e ¼ í
ClientLocale System.String o]wíyÑ⌠C
ConnectionString System.String o]w ΩwrΩCp÷ΩTA
\ 3-23yConnectionString ezC
3-22 IBM Informix .NET Provider ΓU
ϕ 3-7. IfxConnection e (≥)
e ¼ í
ConnectionTimeout System.Int32 oϕsubεMúºe
Ñí (Hϕµ)C
Database System.String oµΩwWsußnΩw
WC
DatabaseLocale System.String oΩwyÑ⌠C(pGsuAhL
C)
FetchBufferSize System.Int32 o]wHsuⁿOw]Ω
ΘwjpC]woeúvTwⁿ
OC
PacketSize System.Int32 P≤ FetchBufferSizeCoΓ]wyNPFΣñ@
]w≤Mbt@]wñC
ServerVersion System.String o@rΩAtßs IBM Informix °
AΩC
State System.Data.Connection.State osuµ¼AC
UserDefinedTypeFormat System.String Nwq¼∩M] DbType.Str ing
DbType.BinaryCp÷ΩTA\ 3-25
yUserDefinedTypeFormat ezC
ConnectionString e
ConnectionString eO@surΩAtzsu ΩwWM
Cw]OrΩCb⌠≤ípUA@nO ServerC
UϕπsurΩC
ϕ 3-8. surΩ
í w]
Client LocaleBClient_Locale bDq[csußWyÑ⌠C en_us.CP1252 (Win-
dows)
Connection Lifetime ϕsuxsA±suíPµíAp
GííZ (Hϕµ) WL connection lifetime ⁿwA
hsuC
0
DatabaseBDB °AΩΩwWCpGⁿwΩwAh°
AMsuCziH ChangeDatabase ΦkN°AM
su≤∩ΩwsuCpG DATABASE... CRE-
ATE DATABASE... »zíAzvz»zí⌡µΦ
íA] IBM Informix .NET Provider úδ≤oX
oⁿOCo»zíApGúzANPL
kwßGC
Database LocaleBDB_LOCALE ΩwyÑ⌠CpGⁿwAhúV°AdΩ
wyÑ⌠C
DELIMIDENT ϕ] true y (ϕ yes) A (″) ⌠≤rΩ
° IDAµ (’) ⌠≤rΩ°rΩσrC
’y’
Enlist bíµ÷ñCJCunⁿw Enlist=false
surΩAYiµ÷ñCJC
true
3 ¼ΩT 3-23
ϕ 3-8. surΩ (≥)
í w]
ExclusiveBXCL EXCLUSIVE ÷ΣrHWíΩwAúFµ
ºATεΣL⌠≤HsCpGt@wΩ
wAh WsAA]úΩwC
NoB0BYes 1C
No
Host ⌡µ Informix °A≈W IP CnC localhost
Max Pool Size xsñe\suW¡C 100
Min Pool Size xsñe\suU¡C 0
Opt imize OpenFe tchCloseB
OPTOFC
εGd≡°ACubVΩ
ípUC
Packet SizeBFetch Buffer SizeB
FBS
NΩJ/X°Awjp (Hµ)C 32767
PasswordBPWD P User ID ÷pKXCpGD≈úH⌠ß≈
bßAhnCpGw User IDAhTεC
Persist Security Info ϕ] false ApGsuw@B≤¼AAhú
bsuWw≈KΩTApKXC½]surΩ½
]surΩA]AKXC
’false’
Pooling ϕ] true ANqAϕxsX IfxConnection ½≤A
bnsWAϕxsC
’true’
ProtocolBPRO b IBM Informix .NET Provider PΩw°Aºíq
T≤wC
Server ns Informix °AΩWOWCnC
Service °A ÑsunDA íW≡C
User IDBUID nJbßCúDD≈H⌠ß≈AhnC
uαbsuw÷¼]w ConnectionString eCísurΩ∩¬eC
b]wsurΩAúDAhoeí≤sCbípUAú
≤s⌠≤eC IfxConnection e ConnectionString ]t]wAHqO
B¼w]C
b÷¼suW½] ConnectionString ½]surΩ÷eA]AKXC
±ΦíApGz]wt ″Database=superstores″ surΩAMßNsurΩ½]″Server=myServer″Ah Database eNúA] superstoresC
surΩb]wºßYiµσRCpGbσRoykAh⌡µ
º¼p ArgumentExceptionCΣLubsu XCpG@
WbsurΩñXhAhß@XC
IBM Informix .NET Provider ConnectionString P IBM Informix ODBC surΩúPC
surΩP]wsurΩPCúO ODBC ’Driver’ OLE
DB ’Provider’ AΓúⁿΣC
pGN Persist Security Info ] false (w])Aϕsu@úAs
urΩNút⌠≤wΩTCpGsuAhú Persist Security Info ]w
≤AsurΩ@w]twΩTCpGN Persist Security Info ] trueA
hsurΩ]twΩTC
3-24 IBM Informix .NET Provider ΓU
UserDefinedTypeFormat e
IfxConnection M IfxCommand UserDefinedTypeFormat eNwq¼
∩M] DbType.String DbType.BinaryCoe N
FetchExtendedTypesAsC
YnNwq¼ϕ String ½≤ sAN UserDefinedTypeFormat
UserDefinedTypeFormat e] stringB"" CUDT µM∩M
DbType.StringCYg UDTFormat ]OsurΩCo]wújpgC
YnNwq¼ϕ Byte[] ½≤ sAN UserDefinedTypeFormat
UserDefinedTypeFormat e] bytesCUDT µM∩M DbType.BinaryC
µ IfxType eúⁿvTC
Uϕπ IfxDataReader sΦk GetBytes() M GetString() (°
UserDefinedTypeFormat e]ww)C
ϕ 3-9. UserDefinedTypeFormat ]wP IfxDataReader sΦkG
UserDefinedTypeFormat ]w @ G
string GetBytes() jεα¼Lº¼p
string GetString() rΩ
bytes GetBytes()
bytes GetString() HQirΩGi
ϕ IfxCommand ½≤ssuA½≤su UserDefinedTypeFormat eC
yß≤esu]wúvT IfxCommand ½≤CUCΣñ@ΦkA²
ⁿOPsuú÷pG
v IfxConnection.CreateCommand()
v IfxCommand.Connection_set()
v IfxCommand.DbConnection_set()
v IfxCommand(string cmdText, IfxConnection connection)
v IfxCommand(string cmdText, IfxConnection connection, IfxTransaction transaction)
ziHµW]w IfxCommand UserDefinedTypeFormat eAΣPsu
UserDefinedTypeFormat eL÷A²úαbUCí]wG
v ⌡µⁿO
v b Is IfxDataReader.Read() ΦkP÷¼Ω¬ºíC
IfxConnection Φk
IfxConnection.BeginTransactionv IfxTransaction IfxConnection.BeginTransaction()
v IfxTransaction IfxConnection.BeginTransaction( System.Data.IsolationLevel
isoLevel )
lΩwµ÷C
3 ¼ΩT 3-25
IfxConnection.ChangeDatabasev void IfxConnection.ChangeDatabase( System.String value )
≤ IfxConnection ½≤µΩwC
IfxConnection.Closev void IfxConnection.Close()
÷¼ΩwsuC
IfxConnection.CreateCommandv IfxCommand IfxConnection.CreateCommand()
Psu÷p IfxConnection ½≤C
IfxConnection.GetIfxBlobv IfxBlob IfxConnection.GetIfxBlob()
su IfxBlob cC
GetIfxClobv IfxClob IfxConnection.GetIfxClob()
su IfxClob cC
IfxConnection.EnlistTransactionv void IfxConnection.EnlistTransaction()
Nⁿwµ÷CJíµ÷C
IfxConnection.Openv void IfxConnection.Open()
IfxConnection ½≤ ConnectionString eⁿw]w ΩwsuC
IfxConnection ≤
Uϕπ IfxConnection O≤C
ϕ 3-10. IfxConnection ≤
≤ í
Disposed sW≤Bzí Ñ≤W Disposed ≤C
InfoMessage ϕú°AiTºoC
StateChange ϕsu¼A≤oC
d
UC C++ dπp≤cl ]wsurΩC
3-26 IBM Informix .NET Provider ΓU
IfxConnection conn = new IfxConnection("User Id=me;Password=myPassword;" +"Host=ajax;Server=myServer;" +"Service=9401;Database=superstores");
IfxConnectionStringBuilder O
ú≤l¬¼surΩm≥ªOCO
DbConnectionStringBuilder OCziH IfxConnectionString Ω csur
Ω
IfxConnectionStringBuilderYn IfxConnectionStringBuilderAΣñ@clC
YnoPúL÷íXAziHqúS DbProviderFactory OΩ
ñ CreateConnectionStringBuilder() ΦkAúS
DbConnectionStringBuilder OΩC
IfxConnectionStringBuilder e
Uϕπ IfxConnectionStringBuilder OeC
ϕ 3-11. IfxConnectionStringBuilder e
e í
Count IfxConnectionStringBuilder Ω @surΩ
ΣC
ConnectionString o]wP IfxConnectionStringBuilder ÷psur
ΩCHjMµ IfxConnectionStringBuilder
@XñxsΣCC@]tHÑj
ΣPC
IsFixedSize ⁿX IfxConnectionStringBuilder OTwjpCtrue
ϕ IfxConnectionStringBuilder TwjpC
IsReadOnly ⁿX IfxConnectionStringBuilder O¬Ctrue ϕ
IfxConnectionStringBuilder O¬C¬XTεb
XºßsWBú∩C
Keys ICollectionAt IfxConnectionStringBuilder ñ
ΣC
ICollection ]tⁿwA²P Values e
ICollection ñ÷pPC
Values o ICollectionAt DbConnectionStringBuilder ñC
ICollection ]t DbConnectionStringBuilder ñC
ICollection ]tⁿwA²P Keys e
ICollection ñ÷pPC
IfxConnectionStringBuilder Φk
IfxConnectionStringBuilder.AddNπⁿwΣMsW IfxConnectionStringBuilderC
3 ¼ΩT 3-27
IfxConnectionStringBuilder.AppendKeyValuePairNΣM[ StringBuilder ½≤C
IfxConnectionStringBuilder.ClearMú IfxConnectionStringBuilder ΩeC
IfxConnectionStringBuilder.ContainsKeyⁿX IfxConnectionStringBuilder ½≤O]tSwΣC
IfxConnectionStringBuilder.EquivalentTo±o IfxConnectionStringBuilder ½≤ñsuΩTPt@½≤ñsuΩTC
IfxConnectionStringBuilder.Removeq IfxConnectionStringBuilder ΩñúⁿwΣC
IfxConnectionStringBuilder.ToStringPo IfxConnectionStringBuilder ½≤÷psurΩC
IfxConnectionStringBuilder.TryGetValueqo IfxConnectionStringBuilder ½≤ñ∩≤úΣC
IfxDataAdapter O
IfxDataAdapter ½≤ IfxCommand ½≤ ∩Ωw⌡µ SQL ⁿOB±JΩA
HΩ≤PΩw≤@PC
IfxDataAdapterYn IfxDataAdapterAΣñ@clC
IfxDataAdapter cl
v IfxDataAdapter()
v IfxDataAdapter( IfxCommand selectCommand )
v IfxDataAdapter( System.String selectCommandText, IfxConnection
selectConnection )
v IfxDataAdapter( System.String selectCommandText, System.String
selectConnectionString )
H .NET ¼rΩµíúiεCMΩwsu SQL dC
selectCommandText OH SQL gdCselectConnectionString O
IfxConnection ½≤clsurΩC
3-28 IBM Informix .NET Provider ΓU
IfxDataAdapter e
Uϕπ IfxDataAdapter OeC
ϕ 3-12. IfxDataAdapter e
e í
AcceptChangedDuringFill o]w@AⁿXb⌠≤ Fil l @íAϕ
DataRow sW DataTable ºßAOb DataRow WI
s AcceptChangesC
AcceptChangesDuringUpdate o]wOb Update íIs AcceptChangesC
DeleteCommand o]w qΩwRúO² SQL »zíC
FillLoadOption o]w LoadOptionALoadOption iMwtq
DbDataReader ±g DataTable ΦíC
InsertCommand o]w NsO²íJΩw SQL »zíC
MissingMappingAction ϕeJΩStϕµµΩn
@CⁿXⁿw∩M ϕµµO@
eΣ WAK≤LooXC
MissingMappingAction eiH MissingMappingAction
C⌠≤ApϕµßzC
MissingSchemaAction ⁿXⁿw ϕµBµΣ÷Y≥OnsW
Ω⌡BHñC MissingSchemaAction
eiH⌠≤ MissingSchemaAction CApϕµß
zC
ReturnProviderSpecifictypes o]w Fill ΦkúS@δ CLS
eC
SelectCommand o]w bΩwñ∩O² SQL »zíC
TableMappings ⁿX ϕµ∩MΩϕµΦíC DataTable w
]ϕµWO TableCw] DataTable Ww]
DataTableMapping ]O TableC
UpdateBatchSize o]w@ σBzΣAHⁿ
wiHb@σñ⌡µⁿOC
UpdateCommand o]w bΩwñ≤sO² SQL »zíC
MissingMappingAction eiHUCG
v Error--ú SystemExceptionC
v Ignore--ñS∩MµϕµC
v Passthrough--sb²wsW DataSet ñ µMϕµCoOw]C
MissingSchemaAction eiHUCG
v Add--sW¿⌡⌠≤µC
v AddWithKey--sW¿⌡µMDnΣΩTCw]AúDⁿw
oeAhúb DataSet ñDnΣC]woiHTO≤s¼
O² (XO²) D[A][iαPP@εCXh≈C
v Error--ú SystemExceptionC
v Ignore--ñBµC
3 ¼ΩT 3-29
IfxDataAdapter Φk
IfxDataAdapter.Fill DataSet Wb DataSet ñsW½sπzεCAHXΩwñεCA
W Table DataTableC
IfxDataAdapter.FillSchemaN DataTable sWⁿw DataSetAⁿw SchemaTypeAtm⌡ XΩ
wñ DataSetC
IfxDataAdapter.GetFillParametersob⌡µ SQL SELECT »zí]wC
IfxDataAdapter.Update∩≤ DataTable bⁿw DataSet ñíJB≤sRúC@εCAIsO
INSERTBUPDATE DELETE »zíC
IfxDataAdapter d
@dd TableMappings M MissingMappingAction ekC
// IfxConnection -- con
DataSet ds = new DataSet();
string sql = "select fname from customer";
IfxDataAdapter da = new IfxDataAdapter(sql,con);
// Default -- MissingMappingAction set to Passthrough.
// Database Column name is used as Data Set Column Name. This
//is the default setting
//da.MissingMappingAction = MissingMappingAction.Passthrough;
// MissingMappingAction set to Ignore// The column or table not having a mapping is ignored. Returns a
// null reference . Will return error while accessing DataRow
da.MissingMappingAction = MissingMappingAction.Ignore;
// MissingMappingAction set to Error
// DataColumnMapping & DataTableMapping is not done
// then DataAdapter.Fill returns Exception
da.MissingMappingAction = MissingMappingAction.Error;
// If set to Error, DataColumnMapping and DataTableMapping has to
// be done
DataColumnMapping dcFnm = new DataColumnMapping("fname", "FirstName");
DataTableMapping dtCus = new DataTableMapping ("customer","CustomerTable");
dtCus.ColumnMappings.Add(dcFnm);
// Activates the Mapping
da.TableMappings.Add(dtCus);
da.Fill(ds,"customer");
foreach(DataRow dr in ds.Tables["CustomerTable"].Rows)
3-30 IBM Informix .NET Provider ΓU
Console.WriteLine(dr["FirstName"]);
//Close Connection
U@ddp≤@ FillSchema ΦkM MissingSchemaAction eC
// IfxConnection -- con
DataSet ds = new DataSet();
string sql = "select fname from customer";
IfxDataAdapter da = new IfxDataAdapter(sql,con);
//MissSchemaAction is set to error so Fill will return
// exception if Data Set and Customer table schema
// do not match
da.MissingSchemaAction = MissingSchemaAction.Error;
// Fills Data Set Schema with the customer table schema
da.FillSchema(ds,SchemaType.Source,"customer");
da.Fill(ds,"customer");
foreach(DataRow dr in ds.Tables["customer"].Rows)
Console.WriteLine(dr["fname"]);
//Close Connection
UCdí SelectCommand M UpdateCommand ekC
IfxDataAdapter adpt = new IfxDataAdapter();
adpt.SelectCommand = new IfxCommand("SELECT CustomerID, Name FROM CustomersWHERE Country = ? AND City = ?", conn);
IfxParameter ifxp1 = new IfxParameter("Country",DbType.String);
IfxParameter ifxp2 = new IfxParameter("City",DbType.String);
Adpt.SelectCommand.Parameters.Add(ifxp1);
Adpt.SelectCommand.Parameters.Add(ifxp2);
//similarly for an UpdateCommand
//adpt.UpdateCommand.Parameters.Add("CustomerName",DbType.String);
adpt.UpdateCommand.Parameters.["CustomerName"] = "xyz";
IfxDataReader O
IfxDataReader ½≤OⁿVeσA\H¬ΦísqΩwΩCϕ
ís IfxDataReader ½≤AΩ suOb@ñC
@δÑA IfxDataReader ½≤α¬≤ IfxDataAdapter ½≤C
3 ¼ΩT 3-31
IfxDataReader e
Uϕπ IfxDataReader OeC
ϕ 3-13. IfxDataReader e
e ¼ í
Depth System.Int32 @ 0C
FieldCount System.Int32 oµεCµC
IsClosed System.Boolean o@ ⁿX IfxDataReader ½≤Ow÷¼C
RecordsAffected System.Int32 o⌡µ SQL »zí≤BíJRúεC
C
VisibleFieldCount System.Int32 o DbDataReader ñD⌠µC
IfxDataReader Φk
IfxDataReader.Close÷¼ IfxDataReader ½≤C
IfxDataReader.GetBooleanH Boolean µí oⁿwµC
IfxDataReader.GetByteYX NotSupported º¼pC
IfxDataReader.GetBytesqⁿwµ¬ΩyAMßHCµíqwwlgJw
C
IfxDataReader.GetCharoⁿwµrC
IfxDataReader.GetCharsqⁿwµ¬rΩyAMßHCµíqwwlgJw
C
IfxDataReader.GetDataYX NotSupported º¼pC
IfxDataReader.GetDateTimeoⁿwµΘMíΩC
IfxDataReader.GetDataTypeNameoⁿwµΩ¼ΩTC
IfxDataReader.GetDecimaloⁿwµTwmC
3-32 IBM Informix .NET Provider ΓU
IfxDataReader.GetDoubleoⁿwµδBIC
IfxDataReader.GetFieldTypeo GetValue ½≤ Type ΩTC
IfxDataReader.GetFloatoⁿwµµδBIC
IfxDataReader.GetGuidⁿwµ GUID C
IfxDataReader.GetInt16oⁿwµ 16 a tπC
IfxDataReader.GetInt32oⁿwµ 32 a tπC
IfxDataReader.GetInt64oⁿwµ 64 a tπC
IfxDataReader.GetNameonMΣµWC
IfxDataReader.GetOrdinalπWµC
IfxDataReader.GetSchemaTable@ DataTable ½≤A½≤í IfxDataReader ½≤µ meta ΩC
IfxDataReader.GetStringoⁿwµrΩC
IfxDataReader.GetTimeSpanoⁿwµííZC
IfxDataReader.GetValueⁿwµC
IfxDataReader.GetValuesoXñµO²µC
IfxDataReader.IsDBNullϕⁿwµO]C
IfxDataReader.NextResultϕ¬σ SQL »zíGAN IfxDataReader ½≤VeU@GC
3 ¼ΩT 3-33
IfxDataReader.ReadN IfxDataReader ½≤VeU@ºO²C
IfxDataReader d
UCddp≤ IfxDataReader OeMΦkC
// IfxConnection - con
string sql = "select stock_num,manu_code,description from stock";
con.Open();
IfxCommand selectCommand = new IfxCommand(sql,con);
IfxDataReader reader = selectCommand.ExecuteReader(CommandBehavior.Default);
//schema for Dataset can be created by GetSchemaTable()
DataTable schema = reader.GetSchemaTable();
//read to use reader properties.reader.Read();
Console.WriteLine("Depth is ");
Console.WriteLine(reader.Depth);
Console.WriteLine("Number of Columns are");
Console.WriteLine(reader.FieldCount);
Console.WriteLine("Number of Rows Changed");
Console.WriteLine(reader.RecordsAffected);
Console.WriteLine("Is Data Reader Closed ?");
Console.WriteLine(reader.IsClosed);
do
while (reader.Read())
Int32 num = reader.GetInt32(0);
Console.WriteLine(num );
String string1 = reader.GetString(1);
Console.WriteLine(string1);
String string2 = reader.GetString(2);
Console.WriteLine(string2);
while (reader.NextResult());
reader.Close();
//Close Connection
IfxDataSourceEnumerator O
IfxDataSourceEnumerator i² .NET íHí]pΦí ¬ Informix SQLHOST
CSetnet32 O SQLHOST ú GUI íC
3-34 IBM Informix .NET Provider ΓU
IfxDataSourceEnumeratorziHUCΦk IfxDataSourceEnumeratorG
v DbDataSourceEnumerator enum = factory.CreateDataSourceEnumerator();
ΣñAfactory OúS DbProviderFactory ΩC
IfxDataSourceEnumerator e
Uϕπ IfxDataSourceEnumerator OeC
ϕ 3-14. IfxDataSourceEnumerator e
e í
Instance CC
IfxDataSourceEnumerator Φk
IfxDataSourceEnumerator.GetDataSources DataTableCDataTable ñC@ DataRecord NϕqúWtm@ß°A
C
ϕ 3-15. System.Data.DataTable µ
µW m í
IfxDatabaseServer 0 °AΩWCµ@°A
WiHsbhΩC
HostComputer 1 SQLHOSTS ñD≈C
UserName 2 sΩwW
C
PasswordOption 3 zL SetNet32 D≈xsK
X∩C
Password 4 rΩC
Protocol 5 ≤qTqT≤wC
Service 6 A íWC
Option 7 SetNet32 ñ∩µC
IfxDateTime c
IfxDateTime Nϕq 0001/01/01 ] 9999/12/31 U 11:59:59.99999 oííZ
µ@ΦC
IfxDateTime w]UCUíµj¿G
v
v δ
v Θ
v
v
v ϕ
3 ¼ΩT 3-35
v ϕp
ziHuWzíµl IfxDateTimeCoOFΩw°A
DATETIME Ω¼µCb IfxDateTime ñíµú⌠≤
OΘíC
IfxDateTime jíµlíµC IfxDateTime píµ
⌠íµClíµB⌠íµΓºííµ IfxDateTime
d≥C
d: pG IfxDateTime BδBΘíAhlíµOA⌠íµO
ΘAd≥hOΘC
IfxDateTime d≥ñ]tíµ]πUϕCw]C
ϕ 3-16. IfxDateTime ½≤ñíµw]
íµ w]
1200
δ 1
Θ 1
0
0
ϕ 0
p 0
b IfxDateTime A IfxTimeUnit C¿ ⁿwíµCpC
ΩTA\ 3-67 yIfxTimeUnit CzC
IfxDateTimeíµñDΦA°µbΩΘñϕkC
d: pGz 13 δ≈AhoA]@uQGδC13 úα
½¿@S@δC
IfxDateTime cl
v IfxDateTime( System.Int64 ticks )
sΩ]wÑ≤q 0001/01/01 ]l ticks ΦC@ϕ 10 000 000
ΦC
sΩd≥O Year Fraction5C
: Φ± Fraction5 ≤δTCΦkMBΓlñhlδC
v IfxDateTime( System.DateTime dt )
sΩ]Ñ≤ dt CsΩd≥O Year Fraction5C
v IfxDateTime( System.Int32 numUnits, IfxTimeUnit unit )
Ωd≥q unit unitC] 0001/01/01 ]Lß numUnits µC
3-36 IBM Informix .NET Provider ΓU
v IfxDateTime( System.Int32 numUnits1, System.Int32 numUnits2, IfxTimeUnit end
)
v IfxDateTime( System.Int32 numUnits1, System.Int32 numUnits2, System.Int32
numUnits3, IfxTimeUnit end )
v IfxDateTime( System.Int32 numUnits1, System.Int32 numUnits2, System.Int32
numUnits3, System.Int32 numUnits4, IfxTimeUnit end )
v IfxDateTime( System.Int32 numUnits1, System.Int32 numUnits2, System.Int32
numUnits3, System.Int32 numUnits4, System.Int32 numUnits5, IfxTimeUnit end
)
v IfxDateTime( System.Int32 numUnits1, System.Int32 numUnits2, System.Int32
numUnits3, System.Int32 numUnits4, System.Int32 numUnits5, System.Int32
numUnits6, IfxTimeUnit end )
v IfxDateTime( System.Int32 numUnits1, System.Int32 numUnits2, System.Int32
numUnits3, System.Int32 numUnits4, System.Int32 numUnits5, System.Int32
numUnits6, System.Int32 numUnits7, IfxTimeUnit end )
pGw numUnits1 numUnits7A]líµ] YearAHS
start FhAsΩd≥O start endC end íµMwpíδ
AH@wOnC
d≥ñµúúCnumUnits1 líµCΣl
d≥ñΣLíµC
IfxDateTime e
UCO IfxDateTime ½≤eC
ϕ 3-17. IfxDateTime e
e ¼ s í
Date IfxDateTime ¬ PΩP²d≥O Year Day
IfxDateTimeC
Day System.Int32 ¬ ΘíC
EndTimeUnit IfxTimeUnit ¬ Ω⌠íµC
Hour System.Int32 ¬ píC
MaxValue IfxDateTime ¬
RA
π IfxDateTime ñjiα
IfxDateTimeCIfxDateTime d≥O
Year Fraction5C
Millisecond System.Int32 ¬ Ωpíñπ@ϕrC@
ϕ 1000 @ϕC
MinValue IfxDateTime ¬
RA
π IfxDateTime ñpiα
IfxDateTimeCIfxDateTime d≥O
Year Fraction5C
Minute System.Int32 ¬ íC
Month System.Int32 ¬ δíC
Now IfxDateTime ¬
RA
]µΘMíBd≥O Year
Fraction5 IfxDateTimeC
3 ¼ΩT 3-37
ϕ 3-17. IfxDateTime e (≥)
e ¼ s í
Null IfxDateTime ¬
RA
] IfxDateTimeC
Second System.Int32 ¬ ϕíC
StartTimeUnit IfxTimeUnit ¬ ΩlíµC
Ticks System.Int64 ¬ q 0001/01/01 ]Ωñí
εΦC@ϕ 10 000 000 Φ
C
Today IfxDateTime ¬
RA
]µíBd≥O Year Day
IfxDateTimeC
Year System.Int32 ¬ íC
IfxDateTime Φk
IfxDateTime.Addv IfxDateTime IfxDateTime.Add( IfxTimeSpan ifxTS )
v IfxDateTime IfxDateTime.Add( IfxMonthSpan ifxMS )
s IfxDateTimeAB]ΩA[WH ifxTS ifxMS ϕíqCs
IfxDateTime d≥PΩPCΩ¡úC
[W IfxMonthSpan úÑP≤[WTwqííZA]Cδú@wC[
W IfxMonthSpan Au∩ IfxDateTime Mδí⌡µsW@CΣLí
µúPΩñPC
IfxDateTime.AddDaysv IfxDateTime IfxDateTime.AddDays( System.Double days )
s IfxDateTimeAB]P≤oΩA[W days ñCdays i
HOtC\pCΩ¡úC
s IfxDateTime d≥PΩPCpGúΘúbd≥ANúC
IfxDateTime.AddMillisecondsv IfxDateTime IfxDateTime.AddMilliseconds( System.Double milliseconds )
s IfxDateTimeAB]P≤oΩA[W milliseconds ñ@ϕCmil-
liseconds iHOtCj≤ -1 000 000 000 Bp≤ 1 000 000 000C\
pCΩ¡úC
s IfxDateTime d≥PΩPCpGúΘúbd≥ANúC
IfxDateTime.AddMinutesv IfxDateTime IfxDateTime.AddMinutes( System.Double minutes )
s IfxDateTimeAB]P≤oΩA[W minutes ñCminutes
iHOtCj≤ -1 000 000 000 Bp≤ 1 000 000 000C\pC
3-38 IBM Informix .NET Provider ΓU
s IfxDateTime d≥PΩPCΩ¡úCpGúΘúbd≥AN
úC
IfxDateTime.AddMonthsv IfxDateTime IfxDateTime.AddMonths( System.Double months )
s IfxDateTimeAB]P≤oΩA²bδí[W months Cmonths
iHOtCΩ¡úC
: oúÑP≤[WTwqííZA]Cδ°úTwCp≤δµúⁿsW@vTC
s IfxDateTime d≥PΩPCpGúΘúbd≥ANúCp
GúΘLAp 2 δ 31 ΘAh@oC
IfxDateTime.AddSecondsv IfxDateTime IfxDateTime.AddSeconds( System.Double seconds )
s IfxDateTimeAB]P≤oΩA[W seconds ñϕCseconds
iHOtCj≤ -1 000 000 000 Bp≤ 1 000 000 000C\pC
Ω¡úC
s IfxDateTime d≥PΩPCpGúΘúbd≥ANúC
IfxDateTime.AddYearsv IfxDateTime IfxDateTime.AddYears( System.Int32 years )
s IfxDateTimeAB]P≤oΩA²bí[W years Cyears
iHOtCΩ¡úC
: oúÑP≤[WTwqííZA]C°úTwCp≤µúⁿsW@vTC
s IfxDateTime d≥PΩPCpGúΘúbd≥ANúCp
GúΘO¡ 2 δ 29 ΘAh@oC
IfxDateTime.Comparev static IfxDateTime IfxDateTime.Compare( IfxDateTime ifxDT1, IfxDateTime ifxDT1
)
ifxDT1 M ifxDT2 ∩ G
Nq
-1 ifxDT1 ¡≤ ifxDT2
0 ifxDT1 M ifxDT2 OPí
1 ifxDT1 ≤ ifxDT2
: IBM Informix .NET Provider ñ½≤NΓ°ÑC]N°p
≤⌠≤DC
3 ¼ΩT 3-39
⌠NΓ IfxDateTime ½≤iiµ±Cúb IfxDateTime d≥⌠≤íµú
w]Cpw]A\ 3-36ϕ 3-16C
IfxDateTime.CompareTov System.Int32 IfxDateTime.CompareTo( System.Object obj )
½≤ obj O IfxDateTimeC
oÑP≤NoΩϕ@ ifxDT1 N obj ϕ@ ifxDT2 Is IfxDateTime.CompareC
IfxDateTime.DaysInMonthv static System.Int32 IfxDateTime.DaysInMonth( System.Int32 year, System.Int32
month )
year month δC
IfxDateTime.Equalsv static System.Boolean IfxDateTime.Equals( IfxDateTime ifxDT1, IfxDateTime
ifxDT2 )
pG IfxDateTime.Compare( ifxDT1, ifxDT2 ) 0AhΦk trueCpGúOA
h falseC
IfxDateTime.GetHashCodev System.Int32 IfxDateTime.GetHashCode()
Ω°ΩXC
⌠NΓπP IfxDateTime ½≤P°ΩXA²ΓπúP
IfxDateTime ½≤]iαP°ΩXC
p°ΩXΩTA\ .NET Framework Owñ Object.GetHashCode Φ
kíC
IfxDateTime.GreaterThanv static System.Boolean IfxDateTime.GreaterThan( IfxDateTime ifxDT1, IfxDateTime
ifxDT2 )
pG IfxDateTime.Compare( ifxDT1, ifxDT2 ) 1AhΦk trueCpGúOA
h falseC
IfxDateTime.GreaterThanOrEqualv static System.Boolean IfxDateTime.GreaterThanOrEqual( IfxDateTime ifxDT1,
IfxDateTime ifxDT2 )
pG IfxDateTime.Compare( ifxDT1, ifxDT2 ) 0 1AhΦk trueCp
GúOAh falseC
3-40 IBM Informix .NET Provider ΓU
IfxDateTime.LessThanv static System.Boolean IfxDateTime.LessThan( IfxDateTime ifxDT1, IfxDateTime
ifxDT2 )
pG IfxDateTime.Compare( ifxDT1, ifxDT2 ) -1AhΦk trueCpGúOA
h falseC
IfxDateTime.LessThanOrEqualv static System.Boolean IfxDateTime.LessThanOrEqual( IfxDateTime ifxDT1,
IfxDateTime ifxDT2 )
pG IfxDateTime.Compare( ifxDT1, ifxDT2 ) 0 -1AhΦk trueCp
GúOAh falseC
IfxDateTime.NotEqualsv static System.Boolean IfxDateTime.NotEquals( IfxDateTime ifxDT1, IfxDateTime
ifxDT2 )
pG IfxDateTime.Compare( ifxDT1, ifxDT2 ) 1 -1AhΦk trueCp
GúOAh falseC
IfxDateTime.Parsev static IfxDateTime IfxDateTime.Parse( System.String dateTimeString )
v static IfxDateTime IfxDateTime.Parse( System.String dateTimeString,
IfxTimeUnit start, IfxTimeUnit end )
v static IfxDateTime IfxDateTime.Parse( System.String dateTimeString,
System.String format, IfxTimeUnit start, IfxTimeUnit end )
dateTimeString s IfxDateTimeCpGw formatAh dateTimeString
rΩOUCµíG
Y-M-DD hh:mm:ss.f
Y ϕπC
M δ≈Ad≥q 1 12C
D δC
h @pAd≥q 0 23C
m pAd≥q 0 59C
s ϕAd≥q 0 59C
f ϕpíCñWL 5 pδC
s IfxDateTime d≥O start endCpGw start M endAhd≥O Day
Fraction5C
d≥ñíµsb≤ dateTimeString ñAYs]@CpGú for-
matAhWXd≥íµ¿∩CYsb]QñCpGú for-
matAhúe\WXd≥íµC
3 ¼ΩT 3-41
format rΩykP DBTIME ⌠PCpykΩTA\ IBM
Informix Guide to SQL: Reference ñ DBTIME ⌠íC
IfxDateTime.ToStringv System.String IfxDateTime.ToString()
v System.String IfxDateTime.ToString ( System.String format )
HrΩµíΩCpGS formatAhµíG
YYYY-MM-DD hh:mm:ss.f
YYYY
MM
Γδ
DD
ΓΘ
hh ΓpAd≥q 00 23
mm
Γ
ss Γϕ
f ϕpí
rΩútWXΩd≥íC
pGú formatAhHrΩñⁿwΦí µíΘXC format rΩyk
P DBTIME ⌠PCpykΩTA\ IBM Informix Guide to SQL:
Reference ñ DBTIME ⌠íC
IfxDecimal c
IfxDecimal ½≤Nϕhπ 32 QiCd≥q 10-129
10129C
Informix Ωwñ DECIMAL Ω¼iHNϕ≤jd≥Aj≤⌠≤ .NET
Framework Ω¼C]iHOBIADwIC]A∩≤ΩwWH DECI-
MAL PÑΩ¼ xsAz IfxDecimal ½≤ xsC
IfxDecimalΣL½≤YΦk IfxDecimal ½≤CP LI600Gexplicitly B¿
uvC
IfxDecimal cl
v IfxDecimal( System.Double d )
v IfxDecimal( System.Decimal d )
v IfxDecimal( System.Int64 d )
v IfxDecimal( System.Int32 i32 )
3-42 IBM Informix .NET Provider ΓU
sΩNπC
IfxDecimal e
ϕ 3-18. IfxDateTime e
e ¼ s í
E IfxDecimal ¬
RA
Lz e C
IsFloating System.Boolean ¬ pGΩOBIAh trueFh
falseC
IsNull System.Boolean ¬ pGΩOAh trueAh
falseC
IsPositive System.Boolean ¬ pGΩO Ah trueFh
falseC
MaxPrecision System.Byte ¬
RA
IfxDecimal Σ¬δ (
)Ce 32C
MaxValue IfxDecimal ¬
RA
IfxDecimal ñiejC
MinusOne IfxDecimal ¬
RA
-1C
MinValue IfxDecimal ¬
RA
IfxDecimal ñiepC
Null IfxDecimal ¬
RA
] IfxDecimalC
One IfxDecimal ¬
RA
1C
Pi IfxDecimal ¬
RA
Lz pi C
Zero IfxDecimal ¬
RA
0C
IfxDecimal Φk
IfxDecimal.Absv static IfxDecimal IfxDecimal.Abs( IfxDecimal IfxDec_ )
s IfxDecimalABÑ≤ IfxDec_ ∩C
IfxDecimal.Addv static IfxDecimal IfxDecimal.Add( IfxDecimal IfxDec1, IfxDecimal IfxDec2 )
s IfxDecimalABÑ≤ IfxDec1 M IfxDec2 XC
IfxDecimal.Ceilingv static IfxDecimal IfxDecimal.Ceiling( IfxDecimal IfxDec )
s IfxDecimalANϕúp≤ IfxDec pπC
3 ¼ΩT 3-43
IfxDecimal.Clonev IfxDecimal IfxDecimal.Clone()
s IfxDecimalANϕΩC
IfxDecimal.Comparev static System.Int32 IfxDecimal.Compare( IfxDecimal IfxDec1, IfxDecimal IfxDec2
)
IfxDec1 M IfxDec2 ∩ C
Nq
-1 IfxDec1 p≤ IfxDec2
0 IfxDecimal ½≤πP
1 IfxDec1 j≤ IfxDec2
: IBM Informix .NET Provider ñ½≤NΓ°ÑC]N°p
≤⌠≤DC
IfxDecimal.CompareTov System.Int32 IfxDecimal.CompareTo( System.Object obj )
oÑP≤NΩϕ@ IfxDec1 MN obj ϕ@ IfxDec2 Is IfxDecimal.CompareC
½≤ obj O IfxDecimal ½≤CpGqΩ IsΦkAhoC
IfxDecimal.Dividev static IfxDecimal IfxDecimal.Divide( IfxDecimal Dividend, IfxDecimal Divi-
sor )
s IfxDecimalANϕ Dividend úH Divisor GC
IfxDecimal.Equalsv static System.Boolean IfxDecimal.Equals( IfxDecimal IfxDec1, IfxDecimal
IfxDec2 )
v System.Boolean IfxDecimal.Equals( System.Object obj )
pG IfxDecimal.Compare( IfxDec1, IfxDec2 ) 0AhΦk trueC
pGuw objAhNΩϕ@ IfxDec1AN obj ϕ@ IfxDec2 Cobj ½≤
O IfxDecimalC
IfxDecimal.Floorv static IfxDecimal IfxDecimal.Floor( IfxDecimal IfxDec )
s IfxDecimalAΣúj≤ IfxDec jπC
3-44 IBM Informix .NET Provider ΓU
IfxDecimal.GetHashCodev System.Int32 IfxDecimal.GetHashCode()
Ω°ΩXC
⌠NΓπP IfxDecimal ½≤P°ΩXA²ΓπúP
IfxDecimal ½≤]iαP°ΩXC
p°ΩXΩTA\ .NET Framework Owñ Object.GetHashCode Φ
kíC
IfxDecimal.GreaterThanv static System.Boolean IfxDecimal.GreaterThan( IfxDecimal IfxDec1, IfxDecimal
IfxDec2 )
pG IfxDecimal.Compare( IfxDec1, IfxDec2 ) 1AhΦk trueFh
falseC
IfxDecimal.GreaterThanOrEqualv static System.Boolean IfxDecimal.GreaterThanOrEqual( IfxDecimal IfxDec1,
IfxDecimal IfxDec2 )
pG IfxDecimal.Compare( IfxDec1, IfxDec2 ) 0 1AhΦk trueF
h falseC
IfxDecimal.LessThanv static System.Boolean IfxDecimal.LessThan( IfxDecimal IfxDec1, IfxDecimal
IfxDec2 )
pG IfxDecimal.Compare( IfxDec1, IfxDec2 ) -1AhΦk trueFh
falseC
IfxDecimal.LessThanOrEqualv static System.Boolean IfxDecimal.LessThanOrEqual( IfxDecimal IfxDec1,
IfxDecimal IfxDec2 )
pG IfxDecimal.Compare( IfxDec1, IfxDec2 ) 0 -1AhΦk trueF
h falseC
IfxDecimal.Maxv static IfxDecimal IfxDecimal.Max( IfxDecimal IfxDec1, IfxDecimal IfxDec2 )
s IfxDecimalABÑ≤ IfxDec1 IfxDec2 A°≤jwC
IfxDec1 P IfxDec2 úúαOC
IfxDecimal.Minv static IfxDecimal IfxDecimal.Min( IfxDecimal IfxDec1, IfxDecimal IfxDec2 )
s IfxDecimalABÑ≤ IfxDec1 IfxDec2 A°≤pwC
3 ¼ΩT 3-45
IfxDec1 P IfxDec2 úúαOC
IfxDecimal.Modulov static IfxDecimal IfxDecimal.Modulo( IfxDecimal a, IfxDecimal b )
IfxDecimal.Remainder PqrC
IfxDecimal.Multiplyv static IfxDecimal IfxDecimal.Multiply( IfxDecimal IfxDec1, IfxDecimal IfxDec2
)
s IfxDecimalABÑ≤ IfxDec1 H IfxDec2C
IfxDecimal.Negatev static IfxDecimal IfxDecimal.Negate( IfxDecimal IfxDec )
s IfxDecimalANϕΩ ( t) αGC
IfxDecimal.NotEqualsv static System.Boolean IfxDecimal.NotEquals( IfxDecimal IfxDec1, IfxDecimal
IfxDec2 )
pG IfxDecimal.Compare( IfxDec1, IfxDec2 ) 1 -1AhΦk trueC
IfxDecimal.Parsev static IfxDecimal IfxDecimal.Parse( System.String s )
s IfxDecimalABÑ≤ s ñϕpC
s ñeMµQñCziHbpMⁿñííJ e E ]A∩
ⁿCⁿiHOtC
d: UC C++ »zí@W d B -0.000032 IfxDecimalG
IfxDecimal d = IfxDecimal.Parse(" -3.2e-5 ");
IfxDecimal.Remainderv static IfxDecimal IfxDecimal.Remainder( IfxDecimal a, IfxDecimal b )
s IfxDecimalABπúk a úH b lCbípUAπúkϕ
b iJ a ñXpπAUOlC
l ( t) @X a C
IfxDecimal.Roundv static IfxDecimal IfxDecimal.Round( IfxDecimal IfxDec1, System.Int32
FractionDigits )
s IfxDecimalABÑ≤¡JpIkΣ FractionDigits IfxDec1C
pG FractionDigits O 0Ah¡J@CpG FractionDigits O -1Ah
¡JQAC
3-46 IBM Informix .NET Provider ΓU
d: ] IfxDec1 O 123.45 IfxDecimalAUϕπ¡JúP
GC
FractionDigits IfxDecimal.Round(IfxDec1,FractionDigits) G
-2 100.0
-1 120.0
0 123.0
1 123.5
2 123.45
IfxDecimal.Subtractv static IfxDecimal IfxDecimal.Subtract( IfxDecimal IfxDec1, IfxDecimal IfxDec2
)
s IfxDecimalAB IfxDec1 ε IfxDec2C
IfxDecimal.ToStringv System.String IfxDecimal.ToString()
v System.String IfxDecimal.ToString ( System.String format )
HrΩµíΩCpGS formatAh@δQiµíAúⁿ
C
pGú formatAhHrΩñⁿwΦí µíΘXCIBM Informix ESQL/C Pro-
grammer’s Manual 5 ″Formatting Numeric Strings″ pí format ykC
IfxDecimal.Truncatev static IfxDecimal IfxDecimal.Truncate( IfxDecimal IfxDec1, System.Int32
FractionDigits )
ⁿ IfxDecimal.Round(IfxDec1, FractionDigits)A²NⁿwkΣrí]
0AD¡JC
d: oϕµúW IfxDec1 B 999.99 IfxDecimal gLGC
FractionDigits
IfxDecimal.Truncate(IfxDec1,FractionDigits) G
-2 900.0
-1 990.0
0 999.0
1 999.9
2 999.99
IfxError O
IfxError ONϕ IBM Informix ΩwúiΩC
3 ¼ΩT 3-47
IfxError e
Uϕπ IfxError OeC
ϕ 3-19. IfxError e
e í
Message oíC
NativeError o IBM Informix ΩwXC
SQLState oΩw¡rX (X ANSI SQL )C
IfxErrorCollection O
IfxErrorCollection ONϕ IfxException ½≤ñX IfxError ½≤XC
IfxErrorCollection e
Uϕπ IfxErrorCollection OeC
ϕ 3-20. IfxErrorCollection e
e í
Count IfxError bXñXC
IfxErrorCollection Φk
IfxErrorCollection.GetEnumeratorXC (IEnumerator)C
IfxException O
IfxException ONϕϕ IBM Informix Ωwiúº¼pC
IfxException e
Uϕπ IfxException OeC
ϕ 3-21. IfxException e
e í
Errors H IfxErrorCollection ½≤í o IfxError ½≤XC
HelpLink oº¼pí URL (pGi)C
InnerException oPµº¼pº¼pC
Message oº¼píσrC
StackTrace ooº¼pIs∩WΩrΩϕkC
TargetSite oº¼pΦkC
3-48 IBM Informix .NET Provider ΓU
IfxMonthSpan c
IfxMonthSpan NϕSwδMC IfxMonthSpan NϕíeiAt
IfxMonthSpan NϕíhCIfxMonthSpan ]tiHq -11 999 999 999
δ 11 999 999 999 δ (11 999 999 999 δ = 999 999 999 S 11 δ)C
IfxMonthSpan w]Mδj¿C
ziHuδ IfxMonthSpanCoOFΩw°A INTERVAL
Ω¼µCu@íµú⌠≤OΘíC
IfxMonthSpan jíµlíµC IfxMonthSpan píµ
⌠íµClíµM⌠íµX IfxMonthSpan d≥C
d: pG IfxMonthSpan MδAhlíµOA⌠íµOδA
d≥hOδCpGuδAhd≥OδδABlíµM⌠
íµúOδC
b IfxMonthSpan AC IfxTimeUnit C¿ ⁿwíµCp
CΩTA\ 3-67 yIfxTimeUnit CzC
IfxMonthSpan
IfxMonthSpan cl
v IfxMonthSpan( System.Int32 val, IfxTimeUnit timeUnit )
sΩu@íµAB] valC
: StartTimeUnit M EndTimeUnit ú] timeUnitC
v IfxMonthSpan( System.Int32 _years, System.Int32 _months )
sΩÑ≤ _years M _months δXC\tC
IfxMonthSpan e
ϕ 3-22. IfxMonthSpan e
e ¼ s í
EndTimeUnit IfxTimeUnit ¬ ϕΩ⌠íµ
IfxTimeUnit CC
IsNull System.Boolean ¬ pGΩOAh trueFh
falseC
MaxValue IfxMonthSpan ¬
RA
]je IfxMonthSpanC
MinValue IfxMonthSpan ¬
RA
]pe IfxMonthSpanC
Months System.Int32 ¬ IfxTimeSpan ñδúH 12
lC
pG IfxMonthSpan OtAht
C
3 ¼ΩT 3-49
ϕ 3-22. IfxMonthSpan e (≥)
e ¼ s í
Null IfxMonthSpan ¬
RA
] IfxMonthSpanC
StartTimeUnit IfxTimeUnit ¬ IfxMonthSpan ]tjµC
TotalMonths System.Int64 ¬ IfxMonthSpan ñδC
pG IfxMonthSpan OtAht
C
Years System.Int32 ¬ IfxMonthSpan ñπC
pG IfxMonthSpan OtAht
C
Zero IfxMonthSpan ¬
RA
] 0 IfxMonthSpanC
IfxMonthSpan Φk
IfxMonthSpan.Addv IfxMonthSpan IfxMonthSpan.Add( IfxMonthSpan ms )
s IfxMonthSpanAB]ΩA[W ms ñíqC
ú IfxMonthSpan πPΩPd≥CΩúC
IfxMonthSpan.Comparev static System.Int32 IfxMonthSpan.Compare( IfxMonthSpan ms1, IfxMonthSpan ms2
)
Φkú±íZ∩jpAO± IfxTimeSpan ½≤ (pGúOr)CpA-12
íZp≤ 2 δíZC
ms1 M ms2 ∩ C
Nq
-1 ms1 p≤ ms2
0 ms1 M ms2 πP
1 ms1 j≤ ms2
: IBM Informix .NET Provider ñ½≤NΓ°ÑC]N°p
≤⌠≤DC
IfxMonthSpan.CompareTov System.Boolean IfxMonthSpan.CompareTo( System.Object obj )
½≤ obj O IfxMonthSpanC
oÑP≤NoΩϕ@ ms1 N obj ϕ@ ms2 Is IfxMonthSpan.CompareC
3-50 IBM Informix .NET Provider ΓU
IfxMonthSpan.Dividev IfxMonthSpan IfxMonthSpan.Divide( Decimal val )
s IfxMonthSpanAB]ΩúH valC
v IfxMonthSpan IfxMonthSpan.Divide( IfxMonthSpan ms )
jp ms (XΩNϕííZ) ííZCpGΣñ@
IfxMonthSpan ½≤OtΣª½≤úOtAhGtC
IfxMonthSpan.Durationv IfxMonthSpan IfxMonthSpan.Duration()
s IfxMonthSpanABÑ≤Ω∩C
IfxMonthSpan.Equalsv static Boolean IfxMonthSpan.Equals( IfxMonthSpan ms1, IfxMonthSpan ms2 )
pG ms1 M ms2 PAh trueFh falseC
v Boolean IfxMonthSpan.Equals( System.Object obj )
pG obj O@NϕPΩPí IfxMonthSpanAh trueFh
falseC
IfxMonthSpan.GetHashCodev System.Int32 IfxMonthSpan.GetHashCode()
Ω°ΩXC
⌠NΓπP IfxMonthSpan ½≤P°ΩXA²ΓπúP
IfxMonthSpan ½≤]iαP°ΩXC
p°ΩXΩTA\ .NET Framework Owñ Object.GetHashCode Φ
kíC
IfxMonthSpan.GreaterThanv static System.Boolean IfxMonthSpan.GreaterThan( IfxMonthSpan ms1, IfxMonthSpan
ms2 )
pG IfxMonthSpan.Compare( ms1, ms2 ) 1AhΦk trueFh falseC
IfxMonthSpan.GreaterThanOrEqualv static System.Boolean IfxMonthSpan.GreaterThanOrEqual( IfxMonthSpan ms1,
IfxMonthSpan ms2 )
pG IfxMonthSpan.Compare( ms1, ms2 ) 1 0AhΦk trueFh
falseC
IfxMonthSpan.LessThanv System.Boolean IfxMonthSpan.LessThan( IfxMonthSpan ms1, IfxMonthSpan ms2 )
3 ¼ΩT 3-51
pG IfxMonthSpan.Compare( ms1, ms2 ) -1AhΦk trueFh
falseC
IfxMonthSpan.LessThanOrEqualv System.Boolean IfxMonthSpan.LessThanOrEqual( IfxMonthSpan ms1, IfxMonthSpan
ms2 )
pG IfxMonthSpan.Compare( ms1, ms2 ) -1 0AhΦk trueFh
falseC
IfxMonthSpan.Multiplyv IfxMonthSpan IfxMonthSpan.Multiply( Decimal val )
s IfxMonthSpanAB]ΩH valC
IfxMonthSpan.Negatev IfxMonthSpan IfxMonthSpan.Negate()
s IfxMonthSpanABÑ≤ΩA² ( t)C
IfxMonthSpan.NotEqualsv static System.Boolean IfxMonthSpan.NotEquals( IfxMonthSpan ms1, IfxMonthSpan
ms2 )
pG IfxMonthSpan.Compare( ms1, ms2 ) -1 1AhΦk trueFh
falseC
IfxMonthSpan.Parsev static IfxTimeSpan IfxMonthSpan.Parse( System.String val )
v static IfxTimeSpan IfxMonthSpan.Parse( System.String val, IfxTimeUnit start,
IfxTimeUnit end )
v static IfxTimeSpan IfxMonthSpan.Parse( System.String val, System.String for-
mat, IfxTimeUnit start, IfxTimeUnit end )
val s IfxMonthSpanCpGw formatAh val rΩOUCµ
íG
[s]y- m
s i∩CpGsbAhiα + -Cw]O +CΦA ([]) úO
ííZ@íCϕO∩C
y íZñπCO 0 999 999 999 d≥πC
m δCO 0 11 d≥πC
s IfxMonthSpan d≥O start endCIfxMonthSpan ñue\ Year M MonthCp
Gw start M endAhd≥O Year MonthCd≥ñC@µsb≤
val ñAYΣñ@sΓús]@Cúαd≥CpGu@
íµAhú -C
3-52 IBM Informix .NET Provider ΓU
format rΩykP DBTIME ⌠PA²i]tmOd¡≤ %Y
M %mCb⌠wqñ %Y mOdⁿ 0 999 999 999 d≥C
πmOdµúsbCpykΩTA\ IBM Informix
Guide to SQL: Reference ñ DBTIME ⌠íC
pGMδPb val ñwB]Q format ⁿAhPΓAYd≥O
δδ]@CpG IfxMonthSpan d≥OABΣ]tLkH 12 ú
δAhñhlδC
d: ⁿOrΩΘXO 1C
IfxMonthSpan.Parse("1-11","%Y-%m",System.Double.Year,System.Double.Year).ToString()
pG IfxMonthSpan d≥OδδAMδwb val ñwAP]Q format
ⁿAh૨δC
d: ⁿOrΩΘXO 23C
IfxMonthSpan.Parse("1-11","%Y-%m",System.Double.Month,System.Double.Month).ToString()
IfxMonthSpan.Subtractv IfxMonthSpan IfxMonthSpan.Subtract( IfxMonthSpan ms )
s IfxMonthSpanAB]ΩAεh ms C
IfxMonthSpan.ToStringv System.String IfxMonthSpan.ToString()
v System.String IfxMonthSpan.ToString ( System.String format )
HrΩµíΩCpGS formatAhµíG
sy-m
s i∩CpG IfxMonthSpan OtAhoπεCY Ahú
π⌠≤C
y ñπ
m pΓ y ºßUδ
pG IfxMonthSpan u@íµAhuΘXíµA]ñ≤Mδ
ºíεuC
pGú formatAhHrΩñⁿwΦí µíΘXCformat rΩykP
DBTIME ⌠PA²ue\ %mB%y %Y mOdCbrΩñA%y M
%Y mOdΦíPCpykΩTA\ IBM Informix Guide to
SQL: Reference ñ DBTIME ⌠íC
IfxParameter O
IfxParameter ONϕ IfxCommand ½≤@CNϕ IfxParameterCollection
½≤ϕXñxsµ@C
3 ¼ΩT 3-53
IfxParameter O
IfxParameter cl
v IfxParameter()
v IfxParameter( System.String name, System.Object value )
v IfxParameter( System.String name, IfxType type )
v IfxParameter( System.String name, IfxType type, System.Int32 size )
v IfxParameter( System.String name, IfxType type, System.Int32 size,
System.String sourceColumn )
v IfxParameter( System.String name, IfxType type, System.Int32 size,
System.Data.ParameterDirection parameterDirection, System.Boolean
isNullable, System.Byte precision, System.Byte scale, System.String
sourceColumn, System.Data.DataRowVersion srcVersion, System.Object value
)
pUG
name
WC
value
ⁿúC
type
Informix ¼CpΩTA\ 3-69yIfxType CzC
size
jpC
parameterDirection
ϕOΘJBΘXΘJ/ΘXCpⁿΩTAd\ .NET
Framework Owñ System.Data.ParameterDirectionC
sourceColumn
µC
isNullable
pGiⁿAh] trueFh] falseC
precision
δC
scale
pC
srcVersion
C
3-54 IBM Informix .NET Provider ΓU
IfxParameter e
Uϕπ IfxParameter OeC
ϕ 3-23. IfxParameter e
e í
DbType o]w DbTypeCDbType eⁿw IfxParameter ½≤Ω
¼C
Direction o]w@AⁿXOΘJBΘXBVxs
CpGΦVOΘXAB⌡µ÷p IfxCommand ⌠≤
Ah IfxParameter ]tCqß@G¬ß@εCº
ßAN≤s OutputBInputOut ReturnValue Cϕµßπ
Direction eiαC
IfxType o]w IfxTypeCIfxType eⁿw IBM Informix .NET Pro-
vider Ω¼C (∩M Informix Ω¼)C
IsNullable o]w@AⁿXOⁿC
ParameterName o]wWCParameterName XñC
SourceColumn o]w µWAµ∩M DataSetAB≤ⁿJ
CSourceColumn eiHϕ@ IfxParameter clA]
iH] IfxParameter ½≤e (\ yIfxParameter d
z)C
SourceVersion o]wbⁿJ DataRowVersionCSourceVersion ⁿw
IfxDataAdapter ½≤ DataRow CSourceVersion e
iHϕ@ IfxParameter clA]iH] IfxParameter
e (\ yIfxParameter dz)C
Value o]wC
IfxParameter d
@d IfxParameter ½≤C
//illustrates example of creating and using IfxParameter
//assume we have obtained a connection
IfxDataAdapter adpt = new IfxDataAdapter();
adpt.SelectCommand = new IfxCommand("SELECT CustomerID, Name FROM CustomersWHERE Country = ? AND City = ?", conn);
IfxParameter ifxp1 = new IfxParameter("Country",DbType.String);
IfxParameter ifxp2 = new IfxParameter("City",DbType.String);
//add parameter to the Parameter collection
//since our provider does not support named parameters, the order of parameters
//added to the collection is important.
Adpt.SelectCommand.Parameters.Add(ifxp1);
Adpt.SelectCommand.Parameters.Add(ifxp2);
//the above method of creating and adding a parameter can also be done in a
//single step as shown
//adpt.UpdateCommand.Parameters.Add("CustomerName",DbType.String);
//assign value to the parameter
adpt.UpdateCommand.Parameters.["CustomerName"] = "xyz";
3 ¼ΩT 3-55
U@dd SourceVersion M SourceColumn ekG
//The following assumptions have been made:
// 1.We have obtained a connection (conn) to our data source
//2. We have a filled a DataSet using a DataAdapter(custDA) that has the//following SelectCommand:
// "SELECT CustomerID, CompanyName FROM Customers WHERE Country = ? AND City =// ?";
// 3. following is the update statement for the UpdateCommand:
// string updateSQL = "UPDATE Customers SET CustomerID = ?, CompanyName = ? " +
// "WHERE CustomerID = ? ";
// 4.The CustomerID column in the DataRow being used has been modified with a// new value.
custDA.UpdateCommand = new IfxCommand(updateSQL,conn);
//The customer id column is being used as a source for 2 parameters.
//(set CustomerID = ?, and //where CustomerID = ?)
//the last parameter to the Add command specifies the SourceColumn for the
//parameter
IfxParameter myParam1 = custDA.UpdateCommand.Parameters.Add("CustomerID", IfxType.Char,5,"CustomerID");
//The following line of code is implied as default, but is provided for
//illustrative purposes
//We want to update CustomerID with the current value in the DataRow.myParam1.SourceVersion = DataRowVersion.Current;
//Current is the default value
custDA.UpdateCommand.Parameters.Add("CompanyName", IfxType.VarChar);
//The last parameter to the Add command specifies the SourceColumn for the
//parameter
IfxParameter myParm2 = custDA.UpdateCommand.Parameters.Add("OldCustomerID", IfxType.Char,5,"CustomerID");
//We want to use in our search filter, the original value of CustomerID in
//the DataRow
MyParm2.SourceVersion = DataRowVersion.Original;
CustDA.Update();
IfxParameterCollection O
IfxParameterCollection ONϕ IfxCommand ½≤C
IfxParameterCollectionzún IfxParameterCollectionCIfxCommand ñ½≤C
IfxCommand.Parameters e s½≤C
3-56 IBM Informix .NET Provider ΓU
IfxParameterCollection e
Uϕπ IfxParameterCollection OeC
ϕ 3-24. IfxParameterCollection e
e í
Count XñC
Item oⁿwWC
IfxParameterCollection Φk
IfxParameterCollection.Addv IfxParameter Add( IfxParameter value )
N IfxParameter ½≤ value sW IfxParameterCollectionC
v IfxParameter Add( System.Object value )
v IfxParameter Add( System.String parameterName, System.Object value )
v IfxParameter Add( System.String parameterName, IfxType IfxType )
v IfxParameter Add( System.String parameterName, IfxType ifxType,
System.Int32 size )
v IfxParameter Add( System.String parameterName, IfxType ifxType,
System.Int32 size, System.String sourceColumn )
w IfxParameter ½≤AMßNΣsW IfxParameterCollectionCp
C≤÷ΩTA\ 3-56y IfxParameterCollectionzC
ΦkwsW IfxParameterC
IfxParameterCollection.Clearv void IfxParameterCollection.Clear()
ú IfxParameterCollection ½≤ñC
IfxParameterCollection.Containsv System.Boolean IfxParameterCollection.Contains( System.Object value )
v System.Boolean IfxParameterCollection.Contains( System.String value )
o@AⁿXXñOⁿw ϕµWC
IfxParameterCollection.CopyTov void IfxParameterCollection.CopyTo( System.Array array, System.Int32 index
)
NXsⁿwWCñC
3 ¼ΩT 3-57
IfxParameterCollection.GetEnumeratorv System.Collections.IEnumerator IfxParameterCollection.GetEnumerator()
XCC
IfxParameterCollection.IndexOfv System.Int32 IfxParameterCollection.IndexOf( System.Object value )
v System.Int32 IfxParameterCollection.IndexOf( System.String value )
o IfxParameter ½≤bXmC
IfxParameterCollection.Insertv void IfxParameterCollection.Insert( System.Int32 index, System.Object value)
NíJⁿwmWC
IfxParameterCollection.Removev void IfxParameterCollection.RemoveAt( System.Object value )
qXñú IfxParameter ½≤C
IfxParameterCollection.RemoveAtv void IfxParameterCollection.RemoveAt( System.String parameterName )
v void IfxParameterCollection.RemoveAt( System.Int32 index )
qXñúW parameterName bm index W IfxParameter ½≤C
IfxProviderFactory O
ziH IfxProviderFactory O gPúL÷ΩsíXCbon
ú Factory ΩºßAziHQú Factory úSΩs
OΩCIfxProviderFactory @sΩioOΩΦkC
w∩ Dynamic Server úí IBM.Data.InformixAziH DbProviderFactory O
Sa DbProvider ΩApUCdG
DbProviderFactory factory = DbProviderFactories.GetFactory("IBM.Data.Informix");
IfxProviderFactory Φk
IfxProviderFactory.CreateConnectionStringBuilderv IfxProviderFactory CreateConnectionStringBuilder( IfxProviderFactory )
DbConnectionStringBuilder ΩAíoi AsurΩ
IfxProviderFactory.CreateConnectionv IfxProviderFactory.CreateConnection( IfxParameter value )
3-58 IBM Informix .NET Provider ΓU
DbConnection ΩAíoi sΩxswC DbConnection
O CreateCommand() ΦkAΦkis DbCommand ΩCúF
DbProviderFactory.CreateCommand() ΦkAoiH∩Φk suⁿO
IfxProviderFactory.CreateCommandv IfxProviderFactory.CreateCommand()
oi ⌡µ SQL »zíMxsCDbCommand O CreateParameter()
ΦkAΦkis DbParameter ΩCúF DbProviderFactory.CreateParameter()
ΦkAoiH∩Φk ⁿOC
IfxProviderFactory.CreateParameterv IfxProviderFactory.CreateParameter ( )
DbParameter ΩAíoi NJMX SQL »zíxs
IfxProviderFactory.CreateCommandBuilderv IfxProviderFactory.CreateCommandBuilder()
DbCommandBuilder ΩAíoi DataAdapter
UPDATEBINSERT DELETE SQL »zí
IfxProviderFactory.CreateDataAdapterv IfxProviderFactory.CreateDataAdapter( )
DbDataAdapter ΩAíoi ±J≤s DataSet DataTableC
IfxProviderFactory.CreateDataSourceEnumeratorv IfxProviderFactory.CreateDataSourceEnumerator( )
DbDataSourceEnumera to r ΩAíoi dg
DbProviderFactory ΩoΩ C
IfxProviderFactory.CreatePermission ( PermissionState )v IfxProviderFactory.CreatePermission ( PermissionState)
PermissionState CAMß CodeAccessPermission ΩAzi T
wwAϕ\ivIs sns½≤C
3 ¼ΩT 3-59
IfxSmartLOBCreateTimeFlags C
C¿i@BnA ]w¬ IfxBlob IfxClob ½≤ Flags eñ
XCϕ Flags ePC¿gL AND BΓºßApGGúOsA
hΣϕNqpUϕC
¿ Nq
DontKeepAccessTime pGO¬Ahoϕz¼j¼½≤úlesíC
pGOgJAhⁿΩw°Aúnlz¼j¼½≤
esíC
Xm½ KeepAccessTime (pGPwΓ)C
KeepAccessTime pGO¬Ahoϕz¼j¼½≤lesíC
pGOgJAhⁿΩw°Ahlz¼j¼½≤
esíC
síl\α[½Ωw°Au@qC\
αºeAfVC
Log pGO¬AhoϕΩw°ANz¼j¼½≤
≤OⁿtΘxC
pGOgJAhⁿΩw°ANz¼j¼½≤≤
OⁿtΘxC
b\αºeAq∩Ωw°Ay¿Bu@qH
±JtΘxñBΩTC
NoLog pGO¬Ahoϕz¼j¼½≤≤úOⁿt
ΘxC
pGOgJAhⁿΩw°AúnNz¼j¼½≤
≤OⁿtΘxC
Xm½ Log (pGPwΓ)C
IfxSmartLOBFileLocation C
C ⁿXSwb () qúC
¿ Ωw
Client ≤⌡µßíqúWC
Server ≤⌡µΩw°AqúWC
IfxSmartLOBLocator O
oOCÑOAOs÷z¼j¼½≤xsm÷ΩTCO ESQL/C
wcCzúúnTasOΩC
3-60 IBM Informix .NET Provider ΓU
IfxSmartLOBLockMode C
C ⁿXSwΩw¼C
¿ Ωw
Exclusive gJC
Shared ¬MgJCΩ±JwABubz¼j¼½≤÷¼
gJΩw°AC
IfxSmartLOBOpenMode C
C ⁿXH≥í IfxBlob IfxClob ½≤CziHbz∩¿
W⌡µ OR BΓAHⁿwsz¼j¼½≤ΦíC
¿ Nq
Append pGµWAhz¼j¼½≤¬CpGP ReadWrite
Write @AhbgJ⌠≤ΩºeAσz¼j¼½
≤AHO@H[ΦígJC
Buffer pGoOsí@íAh¬MgJΩw°
Aw
DirtyRead ¬C\z¬z¼j¼½≤ñTwC
LockAll pGoOsí@íAhbz¼j¼½≤W]m⌠≤Ωw
NΩwπz¼j¼½≤C
LockRange pGoOsí@íAh\zuΩwz¼j¼½≤ñY
d≥AúΩwπz¼j¼½≤C
Nobuffer pGoOsí@íAh¬MgJΩw°A
Ñq@xsúMwC
ReadOnly ¬C
ReadWrite ¬MgJC
WriteOnly gJC
IfxSmartLOBWhence C
C ⁿwNqC IfxBlob IfxClob (Xz¼j¼½≤) Φ
kC
¿ Ωw
Begin w]qz¼j¼½≤YΓCbípUAúαOtC
Current w]qz¼j¼½≤íσµmΓC
End w]qz¼j¼½≤µΓC
3 ¼ΩT 3-61
IfxTimeSpan c
IfxTimeSpan Nϕíeih@qSw°C IfxTimeSpan Nϕíe
iAt IfxTimeSpan NϕíhC
IfxTimeSpan w]UCUíµj¿G
v Θ
v
v
v ϕ
v ϕp
ziHuWzíµl IfxTimeSpanCoOFΩw°A
INTERVAL Ω¼µCb IfxTimeSpan ñíµú⌠≤
OΘíC
IfxTimeSpan jíµlíµCIfxTimeSpan píµ⌠
íµClíµB⌠íµΓºíµ IfxTimeSpan d
≥C
d: pG IfxTimeSpan pBBϕµAhlíµOpA⌠íµ
OϕAd≥hOpϕC
b IfxTimeSpan A IfxTimeUnit C¿ ⁿwíµCpC
ΩTA\ 3-67 yIfxTimeUnit CzC
IfxTimeSpanbⁿhíµclñAUú@w÷Aúb IfxDateTime
clñ÷C@ (t) HWíµiHOtC IfxTimeSpan
Ñ≤UµϕípC
d: ]z 50 B27 p -5 oT IfxTimeSpanCú
IfxTimeSpan N] 51 2 pS 55 C
IfxTimeSpan cl
v IfxTimeSpan( System.Int64 _ticks )
v IfxTimeSpan( System.Decimal _ticks )
sΩd≥O Day Fraction5AB] _ticks ΦC
@ϕ 10 000 000 ΦC
: Φ± Fraction5 ≤δTCΦkMBΓlñhlδC
v IfxTimeSpan( System.TimeSpan ts )
sΩP ts PABd≥O Day Fraction5C
v IfxTimeSpan( System.Int32 val, IfxTimeUnit timeUnit )
sΩu@íµAB] valC
3-62 IBM Informix .NET Provider ΓU
: StartTimeUnit M EndTimeUnit ú] timeUnitC
v IfxTimeSpan( System.Int32 val1, System.Int32 val2, IfxTimeUnit start,
IfxTimeUnit end)
v IfxTimeSpan( System.Int32 val1, System.Int32 val2, System.Int32 val3,
IfxTimeUnit start, IfxTimeUnit end)
v IfxTimeSpan( System.Int32 val1, System.Int32 val2, System.Int32 val3,
System.Int32 val4, IfxTimeUnit start, IfxTimeUnit end)
v IfxTimeSpan( System.Int32 val1, System.Int32 val2, System.Int32 val3,
System.Int32 val4, System.Int32 val5, IfxTimeUnit end)
pGw val1 val5A]líµ] DayAHS start F
hAsΩd≥O start endC end íµMwpíδAH@w
OnC
d≥ñµúúCval1 líµCΣl
d≥ñΣLíµC
IfxTimeSpan e
ϕ 3-25. IfxTimeSpan eC
e ¼ s í
Days System.Int64 ¬ IfxTimeSpan ñπΘCpG IfxTimeSpan OtA
hoNOtC
EndTimeUnit IfxTimeUnit ¬ IfxTimeSpan ]tpµC
d: pG IfxTimeSpan Day MinuteAh Minute
O EndTimeUnitC
Hours System.Int64 ¬ IfxTimeSpan ñπIúH 24 lC
: AoNÑ≤ ToString rΩpíñ
r
IsNull System.Boolean ¬ pG IfxTimeSpan OAhe TrueAh
FalseC
MaxScale System.Int32 ¬
RA
ñϕpíe\jCeO 5C
MaxValue IfxTimeSpan ¬
RA
]je IfxTimeSpanC
Milliseconds System.Int64 ¬ IfxTimeSpan ñπ@ϕúH 1000 lC
pG IfxTimeSpan OtAhoNOtC
Minutes System.Int64 ¬ IfxTimeSpan ñπIúH 60 lCpG
IfxTimeSpan OtAhoNOtC
MinValue IfxTimeSpan ¬
RA
IfxTimeSpan ñiepC
Null IfxTimeSpan ¬
RA
] IfxTimeSpanC
Seconds System.Int64 ¬ ΩñπúH 60 lCpGΩOt
AhoNOtC
StartTimeUnit IfxTimeUnit ¬ IfxTimeSpan ]tjµC
3 ¼ΩT 3-63
ϕ 3-25. IfxTimeSpan eC (≥)
e ¼ s í
Ticks System.Decimal ¬ IfxTimeSpan ϕí°ñΦC@ϕ 10
000 000 ΦC
pG IfxTimeSpan OtAhoNOtC
Zero IfxTimeSpan ¬
RA
0C
IfxTimeSpan Φk
UCO IfxTimeSpan ½≤ΦkC
IfxTimeSpan.Addv IfxTimeSpan IfxTimeSpan.Add( IfxTimeSpan ts )
s IfxTimeSpanAB]ΩA[W ts ñíqC
ú IfxTimeSpan πPΩPd≥CΩúC
IfxTimeSpan.Comparev static System.Int32 IfxTimeSpan.Compare( IfxTimeSpan ts1, IfxTimeSpan ts2
)
Φkú±íZ∩jpAO± IfxTimeSpan ½≤ (pGúOr)CpA-12
píZp≤ 2 píZC
ts1 M ts2 ∩ C
Nq
-1 ts1 p≤ ts2
0 ts1 M ts2 πP
1 ts1 j≤ ts2
: IBM Informix .NET Provider ñ½≤NΓ°ÑC]N°p
≤⌠≤DC
IfxTimeSpan.CompareTov System.Boolean IfxTimeSpan.CompareTo( System.Object obj )
½≤ obj O IfxTimeSpanC
oÑP≤N IfxTimeSpan ϕ@ ts1 N obj ϕ@ ts2 Is IfxTimeSpan.CompareC
IfxTimeSpan.Dividev IfxTimeSpan IfxTimeSpan.Divide( Decimal val )
s IfxTimeSpanAB]l IfxTimeSpan úH valC
v IfxTimeSpan IfxTimeSpan.Divide( IfxTimeSpan ts )
3-64 IBM Informix .NET Provider ΓU
jp ts (X IfxTimeSpan ΩNϕííZ) ííZCpGΣñ
@ IfxTimeSpan ½≤OtΣª½≤úOtAhGtC
IfxTimeSpan.Durationv IfxTimeSpan IfxTimeSpan.Duration()
s IfxTimeSpanABÑ≤Ω∩C
IfxTimeSpan.Equalsv static Boolean IfxTimeSpan.Equals( IfxTimeSpan ts1, IfxTimeSpan ts2 )
pG ts1 M ts2 PAh trueFh falseC
v Boolean IfxTimeSpan.Equals( System.Object obj )
pG obj O@PΩπP IfxTimeSpanAh trueFh falseC
IfxTimeSpan.GetHashCodev System.Int32 IfxTimeSpan.GetHashCode()
IfxTimeSpan °ΩXC
⌠NΓπP IfxTimeSpan ½≤P°ΩXA²ΓπúP
IfxTimeSpan ½≤]iαP°ΩXC
p°ΩXΩTA\ .NET Framework Owñ Object.GetHashCode Φ
kíC
IfxTimeSpan.GreaterThanv static System.Boolean IfxTimeSpan.GreaterThan( IfxTimeSpan ts1, IfxTimeSpan
ts2 )
pG IfxTimeSpan.Compare( ts1, ts2 ) 1AhΦk trueCh falseC
IfxTimeSpan.GreaterThanOrEqualv static System.Boolean IfxTimeSpan.GreaterThanOrEqual( IfxTimeSpan ts1,
IfxTimeSpan ts2 )
pG IfxTimeSpan.Compare( ts1, ts2 ) 1 0AhΦk trueCh
falseC
IfxTimeSpan.LessThanv System.Boolean IfxTimeSpan.LessThan( IfxTimeSpan ts1, IfxTimeSpan ts2 )
pG IfxTimeSpan.Compare( ts1, ts2 ) -1AhΦk trueCh falseC
IfxTimeSpan.LessThanOrEqualv System.Boolean IfxTimeSpan.LessThanOrEqual( IfxTimeSpan ts1, IfxTimeSpan ts2
)
3 ¼ΩT 3-65
pG IfxTimeSpan.Compare( ts1, ts2 ) -1 0AhΦk trueCh
falseC
IfxTimeSpan.Negatev IfxTimeSpan IfxTimeSpan.Negate()
s IfxTimeSpanABÑ≤ΩA² ( t)C
IfxTimeSpan.NotEqualsv static System.Boolean IfxTimeSpan.NotEquals( IfxTimeSpan ts1, IfxTimeSpan
ts2 )
pG IfxTimeSpan.Compare( ts1, ts2 ) -1 1AhΦk trueCh
falseC
IfxTimeSpan.Parsev static IfxTimeSpan IfxTimeSpan.Parse( System.String _szTime )
v static IfxTimeSpan IfxTimeSpan.Parse( System.String _szTime, IfxTimeUnit
start, IfxTimeUnit end )
v static IfxTimeSpan IfxTimeSpan.Parse( System.String _szTime, System.String
format, IfxTimeUnit start, IfxTimeUnit end )
_szTime s IfxTimeSpanCpGw formatAh _szTime rΩO
UCµíG
[-]d h:m:s.f
- i∩CpGsbAh IfxTimeSpan NOtCΦA ([]) ϕ
O∩CúOµí@íC
d ϕπCO 0 999 999 999 d≥πC
h CO 0 23 d≥πC
m CO 0 59 d≥πC
s πϕCO 0 59 d≥πC
f ϕpíCñWL 5 pδC
s IfxTimeSpan d≥O start endCpGw start M endAhd≥O Day
Fraction5C
d≥ñíµsb≤ _szTime ñAYs]@CpGú formatAh
WXd≥íµ¿∩CYsb]QñCpGú formatAhú
e\WXd≥íµC
format rΩykP DBTIME ⌠PA²úα]tδmOdC
pykΩTA\ IBM Informix ESQL/C Programmer’s Manual ñ
DBTIME ⌠íC
IfxTimeSpan.ToStringv System.String IfxTimeSpan.ToString()
v System.String IfxTimeSpan.ToString ( System.String format )
3-66 IBM Informix .NET Provider ΓU
HrΩµíΩCpGS formatAhµíG
D hh:mm:ss.f
D ñπ
hh ΓpAd≥q 00 23
mm
Γ
ss Γϕ
f ϕpí
rΩútWXΩd≥íC
pGú formatAhHrΩñⁿwΦí µíΘXC format rΩyk
P DBTIME ⌠PCpykΩTA\ IBM Informix Guide to SQL:
Reference ñ DBTIME ⌠íC
IfxTimeUnit C
IfxTimeUnit O@CAs±ift IfxDateTimeBIfxMonthSpan IfxTimeSpan
íµC∩≤C@DníµAIfxTimeUnit ñúΣ¿C
ϕ 3-26. IfxTimeUnit Dp¿
IfxTimeUnit¿ µ
Year
Month δ
Day Θ
Hour
Minute
Second ϕ
C]@¿α≈HúPδ ϕϕpC
ϕ 3-27. IfxTimeUnit p¿
IfxTimeUnit ¿
δ d
Fraction1 Qº@ϕ 1962-04-16 11:35:10.1
Fraction2 º@ϕ 1962-04-16 11:35:10.12
Fraction
Fraction3
dº@ϕ 1962-04-16 11:35:10.123
Fraction4 Uº@ϕ 1962-04-16 11:35:10.1234
Fraction5 QUº@ϕ 1962-04-16 11:35:10.12345
: Informix íΩ¼@eα≈H@ϕ (dº@ϕ) ϕpíC²
Seα≈HΣL⌠≤δ ϕpC
3 ¼ΩT 3-67
IfxTransaction O
IfxTransaction ONϕn∩Ωw⌡µµ÷C
IfxTransaction e
Uϕπ IfxTransaction OeC
ϕ 3-28. IfxTransaction e
e í
Connection nPµ÷ú÷p IfxTransaction ½≤C
IsolationLevel µ÷j≈hC
: N IBM Informix Ωw°A íAiCj≈hPi½¬
j≈hPCpGzb .NET ñNj≈h]i½¬Ah
ΩWbΩw°Añ]iCC
IfxTransaction Φk
IfxTransaction.CommitTwΩwµ÷C
IfxTransaction.RollbackNµ÷qm¼Añ C
bí⌡µznQεµ÷ⁿOºeAz²Nsuñ@ñµ÷
ⁿú IfxCommand ½≤ Transaction eApUCdCpG⌡µ@A
hº¼pC
IfxTransaction d
UCdπp≤bµ÷⌡µíJC MyCommand.Transaction = myTrans; ⁿO
ⁿú@ñµ÷ IfxCommand ½≤ Transaction eC
IfxConnection myConn = new IfxConnection("Host=ajax;Server=myServer;Service=9401;database=dotnet;user id=xxx;password=xxx");
myConn.open();
IfxTransaction myTrans = myConn.BeginTransaction();
IfxCommand myCommand = new IfxCommand();
MyCommand.Transaction = myTrans;
MyCommand.CommandText = "INSERT INTO mytab(custid,custname)values(1005,\"Name\");"
MyCommand.ExecuteNonQuery();
MyTrans.Commit();
MyConn.Close();
3-68 IBM Informix .NET Provider ΓU
IfxType C
CP IfxParameter ½≤ftCC@¿Nϕ Informix Ωw°AΣ
@Ω¼C 3-69 ϕ 3-29 π¿C@¿p≤∩M .NET
DbType ¼M .NET Framework ¼Cp Informix ¼ΩTA\ IBM
Informix Guide to SQL: ReferenceC
ϕ 3-29. IfxType C
¿
.NET DbType(AX)
.NET Framework ¼
(AX)
Blob Binary Byte[]
Boolean Boolean Boolean
Byte Binary Byte[]
Char StringFixedLength String
Char1 StringFixedLength Char
Clob String String
Collection String String
Date Date DateTime
DateTime DateTime DateTime
Decimal Decimal Decimal
Float Double Double
Int8 Int64 Int64
Integer Int32 Int32
IntervalDayFraction String TimeSpan
IntervalYearMonth String String
List String String
LVarChar String String
Money Currency Decimal
MultiSet String String
NChar StringFixedLength String
NVarChar String String
Row String String
Serial Int32 Int32
Serial8 Int64 Int64
Set String String
SmallFloat Single Single
SmallInt Int16 Int16
SmartLOBLocator Binary Byte[]
Text String String
VarChar String String
3 ¼ΩT 3-69
3-70 IBM Informix .NET Provider ΓU
4 dí
dí . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1µ@ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1hεC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-2⌡µúΩ]úµ÷ SQL . . . . . . . . . . . . . . . . . . . . . . . . . 4-3NΩ DataSet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-3 IfxCommandBuilder ½≤ ≤PΩw≤@P . . . . . . . . . . . . . . . . . . . 4-4Isxs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-5íµ÷ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-6N CLOB gJ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-7
dí
IBM Informix .NET Provider dí≤ %INFORMIXDIR%\demo\dotnetdemo Ω
¿ñC
d≥[\UCíoΓG
v C++ Windows Forms
v VB.NET Windows Forms
v ASP.NET Web Forms
d
úud dSw½≤kAπp≤⌡µSwΩw@C
Fⁿπ½IAdúuC]AªúNϕΩBπíCdú
w≤H C++ yÑgDxíC]ú]zwbíñ[JUCⁿ
J IBM.Data.Informix WíG
using IBM.Data.Informix;
Σñ\hd IBM Informix Ωw°A]tΣñ@dΩwC
dΩwO stores_demo M superstores_demoCIBM Informix DB-Access ΓU
ñúp≤oΩwⁿC
µ@
pGDzn⌡µ SQL µ@A IfxCommand.ExecuteScalar ΦkC
IfxCommand.ExecuteScalar Φk System.ObjectCzN½≤jεα¼zw
Ω¼C]d COUNT(*) ΘXOpAH System.Object
njεα¼ System.Decimal ¼C
p IfxCommand O÷ΩTA\ 3-17yIfxCommand OzC
try
// Open a connectionIfxConnection conn =
new IfxConnection("Host=myhost;Service=1541;Server=myifxserver;Database=stores_demo;"+ "User ID=mylogin;password=mypassword"
© Copyright IBM Corp. 2003, 2007 4-1
);conn.Open();
// Create an SQL commandIfxCommand cmd = new IfxCommand(
"SELECT COUNT(*) FROM customer",conn);
Decimal ccount = (Decimal)cmd.ExecuteScalar();Console.WriteLine("There are " + ccount + " customers");
// Close the connectionconn.Close();Console.ReadLine(); // Wait for a Return
catch(IfxException e)
Console.WriteLine(e.ToString());Console.ReadLine(); //Wait for a Return
hεC
ds stores_demo ΩwAMß IfxDataReader ½≤q customer ϕµñ
WrC
pGzúngJA]únA IfxDataReader ½≤ ⌡µµΩ
sCp IfxDataReader O÷ΩTA\ 3-31yIfxDataReader
OzC
try
// Open a connectionIfxConnection conn =
new IfxConnection("Host=myhost;Service=1541;Server=myifxserver;Database=stores_demo;"+ "User ID=mylogin;password=mypassword");
conn.Open();
// Create an SQL commandIfxCommand cmd = new IfxCommand(
"SELECT fname FROM customer",conn );
IfxDataReader dr = cmd.ExecuteReader();// Write the data to the consolewhile (dr.Read())
Console.WriteLine(dr["fname"].ToString());Console.ReadLine(); // Wait for a Returndr.Close();
// Close the connectionconn.Close();catch(IfxException e)
Console.WriteLine(e.ToString());Console.ReadLine(); // Wait for a Return
4-2 IBM Informix .NET Provider ΓU
⌡µúΩ]úµ÷ SQLYn⌡µú⌠≤Ω SQL »zíA IfxCommand.ExecuteNonQuery Φ
kCúΩ SQL »zí¼]AG
v íJ
v ≤s
v Rú
v ≤Ωw½≤
dπp≤ IfxCommand.ExecuteNonQuery ⌡µíJA]πp≤bµ
÷⌡µ IfxCommandCYn²d B@Astores_demo Ωwπµ÷O
ⁿCYnπµ÷Oⁿ stores_demo ΩwAft -log ∩ ⌡µ
dbaccessdemo ⁿOC
p IfxCommand OΩTA\ 3-17yIfxCommand OzCp
IfxTransaction OΩTA\ 3-68yIfxTransaction Oz
try// Open a connectionIfxConnection conn = new IfxConnection(
"Host=myhost;Service=1541;"+ "Server=myifxserver;Database=stores_demo;"+ "User ID=mylogin;password=mypassword"
);conn.Open();
//Begin the transactionIfxTransaction tx = conn.BeginTransaction();
//Create an IfxCommand that uses the connection and transactionIfxCommand cmd = new IfxCommand(
"INSERT INTO state VALUES(’XX’,’No State’)",conn,tx );
//Execute the commandcmd.ExecuteNonQuery();
//Commit the transactiontx.Commit();
// Close the connectionconn.Close();catch(IfxException e)Console.WriteLine(e.ToString());Console.ReadLine(); //Wait for a Return
NΩ DataSetYnNΩwΩT System.Data.DataSet ½≤ñ i@BBzA
IfxDataAdapter ½≤Cd System.Data.DataSetAMßN customer ϕµñW
rMm≤ΘJ DataSet ñCAFϕwΘJAH XML µíN
System.Data.DataSet ΘXDxC
p IfxDataAdapter ½≤ΩTA\ 3-28yIfxDataAdapter OzC
pΩ÷ΩTA\ .NET ADO σ≤C
4 dí 4-3
try
// Open a connectionIfxConnection conn =
new IfxConnection("Host=myhost;Service=1541;Server=myifxserver;Database=stores_demo;"+ "User ID=mylogin;password=mypassword");
conn.Open();
IfxDataAdapter da = new IfxDataAdapter("SELECT fname, lname FROM customer",conn );
System.Data.DataSet ds = new System.Data.DataSet("Names");
//Fill the DataSetda.Fill(ds);
//The DataSet is ready to use.//This example outputs the DataSet to the Console as XML//just to show that it is populated.ds.WriteXml(Console.Out);Console.ReadLine(); //Wait for a Return
// Close the connectionconn.Close();
catch(IfxException e)
Console.WriteLine(e.ToString());Console.ReadLine(); //Wait for a Return
IfxCommandBuilder ½≤≤PΩw≤@P
ziH IfxCommandBuilder ½≤ft SQL SELECT »zí ΩBbΩ
Wiµ≤AMßo≤P IBM Informix Ωw≤@PApUCdC
IfxCommandBuilder ½≤iH÷aΩW≤PΩw≤@PC
p IfxCommandBuilder O÷ΩTA\ 3-20yIfxCommandBuilder
OzCpbΩwñ≤≤@P÷ΩTA\ 1-5y DataSet
≤PΩw≤@PzC
// Add the IBM Informix namespace
using System.Data;
using IBM.Data.Informix;
// Create a connection
IfxConnection conn=new IfxConnection("Host=berry; Service=3500;Server=testserver; User ID=informix; password=ifxtest;Database=testdb");
// Create a DataAdapter object
IfxDataAdapter allDataAdapter = new IfxDataAdapter();
IfxCommand selCmd = new IfxCommand("SELECT * FROM students", conn);
allDataAdapter.SelectCommand = selCmd;
//Set up the CommandBuilder object
IfxCommandBuilder cbuild = new IfxCommandBuilder(allDataAdapter);
DataSet allDataSet = new DataSet ();
try
4-4 IBM Informix .NET Provider ΓU
// Open the connection
conn.Open();
allDataAdapter.Fill(allDataSet);
// Change the age of a student
DataRow chRow;
chRow = allDataSet.Tables["Table"].Rows[5];
chRow["age"] = 24;
// Use IfxDataAdapter.Update() to reconcile changes with the database
allDataAdapter.Update(allDataSet);
catch (Exception ex);
// Use a messagebox to show any errors
MessageBox.Show (ex.Message);
// Close the connection
conn.Close();
Isxs
ziH IfxCommand ½≤ IsxsCzN IfxCommand ½≤
CommandType e] StoredProcedureCUCdπp≤⌡µxsAMß
IfxDataReader ½≤ ¬xs⌠≤GC
p IfxCommand O÷ΩTA\ 3-17yIfxCommand OzCp
Isxs÷ΩTA\ 1-7yIsxszC
// Add the IBM Informix namespace
using System.Data;
using IBM.Data.Informix;
// Create a connection
IfxConnection conn=new IfxConnection("Host=berry; Service=3500;Server=testserver; User ID=informix; password=ifxtest;Database=testdb");
conn.Open();
//Create a command object for the stored procedure
IfxCommand spCmd = new IfxCommand("testproc", conn);
// Set the CommandType property to Storedprocedure
spCmd.CommandType = CommandType.StoredProcedure
IfxDataReader testDataReader;
try
testDataReader = spCmd.ExecuteReader();
testDataReader.Close();
4 dí 4-5
catch (Exception ex)
// Use a messagebox to show any errors
MessageBox.Show (ex.Message);
// Close the connection
conn.Close();
íµ÷
UCdΩíX dp≤íµ÷C
...using System.EnterpriseServices;using IBM.Data.Informix;...[assembly: AssemblyKeyFile("test.snk")]...
public static void Main()
.../* The ’using’ construct below results in a call to Dispose onexiting the curly braces. It is important to dispose of COM+objects as soon as possible, so that COM+ services such asObject Pooling work properly */
using (TwoPhaseTxn txn = new TwoPhaseTxn)
txn.TestAutoComplete_Exception();
using (TwoPhaseTxn txn = new TwoPhaseTxn)
txn.TestAutoComplete_TransactionVote();...
//Transaction attributes specify the type of transaction requested
[Transaction(TransactionOption.RequiresNew)]public class TwoPhaseTxn : ServicedComponent
[AutoComplete]public void TestAutoComplete_Exception()
IfxConnection ifxConn1 = new IfxConnection(“db=db1;server=srv1;enlist=true;”);
IfxConnection ifxConn2 = new IfxConnection(“db=db2;server=srv2;enlist=true;”);
try
// db operation on ifxConn1catch
// throw exception
try
// db operation on ifxConn2
4-6 IBM Informix .NET Provider ΓU
catch
// throw exception
[AutoComplete]
public void TestAutoComplete_TransactionVote()
IfxConnection ifxConn1 = new IfxConnection(“db=db1;server=srv1;enlist=true;”);
IfxConnection ifxConn2 = new IfxConnection(“db=db2;server=srv2;enlist=true;”);
try
// db operation on ifxConn1catch
// In case of any failure, flag abortContextUtil.MyTransactionVote = TransactionVote.Abort
try
// db operation on ifxConn2catch
// In case of any failure, flag abort
ContextUtil.MyTransactionVote = TransactionVote.Abort
N CLOB gJ
ds superstores_demo ΩwAMßN catalog ϕµñ CLOB gJ
C:\tmp ²UCN BLOB gJ]OPNC
NA² IfxClob ΩA αiµsC
p IfxClob O÷ΩTA\ 3-12yIfxClob OzC
try
// Open a connectionIfxConnection conn =
new IfxConnection("Host=myhost;" +"Service=1576;" +"Server=mydbserver;"+"Database=superstores_demo;" +"User ID=mylogin;password=mypassword");
conn.Open();
// Create an SQL commandIfxCommand cmd = new IfxCommand(
"SELECT advert_descr, catalog_num FROM catalog",conn);
IfxDataReader dr = cmd.ExecuteReader();
// Write any CLOBs to files in C:\tmp
4 dí 4-7
while (dr.Read())
if(!dr.IsDBNull(0))IfxClob c = dr.GetIfxClob(0);long num = dr.GetInt64(1);
c.Open(IBM.Data.Informix.IfxSmartLOBOpenMode.ReadOnly);c.ToFile(
"C:\\tmp\\" + num.ToString() + ".txt",System.IO.FileMode.Create,IfxSmartLOBFileLocation.Client);
dr.Close();
// Close the connectionconn.Close();
catch(Exception e)
//This is assumed to be a console applicationConsole.WriteLine(e.ToString());
4-8 IBM Informix .NET Provider ΓU
². ≤Uuπ
ΓUº HTML ñúaIpykµíykAoµíOubz
⌡¬ αisµíC
aIpyk
C@ykúObOµWgBHaIpµí ϕCpGΓ (t) HWy
kTw@e (TwúX)AhoiHXbP@µWA]iHN
ª°µ@XykC
C@µúOHaIplFpA3 3.1 3.1.1CYn TaÑorA
Twz⌡¬]¬ICykYπPaIp (pA
ykúπr 3.1)AªN¼CpGÑ 3.1 USERID 3.1 SYSTEMID
oΓµAzykiH]A USERID SYSTEMIDA²úαP]AoΓC
aIphϕ¼hC±ΦíApG@ykπaIp 3AΣß@
sΩykπaIp 3.1Ahs 3.1 ykOs 3 yk
hC
aIpΣYrMA sWyk÷ΩTCAor
iαXb¡YCpGrOyk@íAhF
÷≤OAreu (\) rCaIpΣiH * AHⁿ
Xyk½CpAtaIp 3 yk *FILE ¬¿ 3 \* FILECµí 3*
FILE ⁿXyk FILE ½Cµí 3* \* FILEⁿXyk * FILE½C
pr ( j@sΩyk) rπbykñA²ubªje
CoriHPC@XbP@µAP÷PaIpOX
búP@µCo@µ]iHπt@A úyk÷ΩTC
pA5.1*B5.1 LASTRUN 5.1 DELETE oXµϕpGzh LASTRUN DELETE
ykAoHrIjCpGSújAN]zµ
jC@ykC
pGyke % AoO@bOBwqC% ßrΩOyk
qWAúOσrWCpA2.1 %OP1 o@µϕzOyk
q OP1C
aIpΣUCrG
? ⁿwi∩ykCaIpßY ? AⁿXt∩aIp
ykAH⌠≤hykúOi∩CpGu@ykπ
aIpAh ? PykπbP@µ (pA5? NOTIFY)CpG
hykπaIpAh ? ¡πb@µWAß≥i∩
ykC±ΦíApGÑ 5 ?B 5 NOTIFY 5 UPDATE oXµAz
Dyk NOTIFY UPDATE Oi∩FτYAziH∩ªΣñ@
úú∩C? ϕ≤K⌠ñuC
! ⁿww]ykCaIpßY !ykAⁿXoykO
© Copyright IBM Corp. 2003, 2007 A-1
@PaIpºykw]∩CuΣñ@@PaIp
ykiHⁿw ! C±ΦíApGÑ 2? FILEB2.1! (KEEP)
2.1 (DELETE) oXµAzD (KEEP) O FILE ÷Σrw]∩Cbod
ñApGz]A FILE ÷ΣrA²ⁿw∩ANMw]∩ KEEPCw]
∩]MU@≤¬aIpCbodñApGñ FILE ÷Σ
rANw] FILE(KEEP)CMApGÑ 2? FILEB2.1B2.1.1! (KEEP)
2.1.1 (DELETE) oXµAw]∩ KEEP MU@≤¬aIp
2.1 (S÷÷Σr)ABúM 2? FILECpGñ÷Σr FILEA
Nú⌠≤∩C
* ⁿwiH½s (t) HWykCaIpßY * AⁿXo
ykiHs (t) HWFτYAªOi∩BiH½C±Φ
íApGÑ 5.1* data-area o@µAzDiH]AhΩAú
ú]ACpGÑ 3*B3 HOST 3 STATE oXµAzDiHP]A
HOSTBSTATEAúú]AC
:
1. pGaIpΣ@P (*)ABu@πaIpA
zNiH½PhC
2. pGaIpΣ@PABπaIpAzN
iHqMµhA²OC@úαWL@Cbe@
dñAziHg HOST STATEA²Ozúαg HOST HOSTC
3. * ϕ≤K⌠ykñ⌠¼juC
+ ⁿw]A@ (t) HWykCaIpßY + AⁿXo
yk]A@ (t) HWC±ΦíApGÑ 6.1+ data-area o@
µAz]A@ΩCpGÑ 2+B2 HOST 2 STATE oXµA
zD]A HOSTBSTATE ΓC≤ * AubSwO@
πaIpAz α½oC+ pP * @δA
ϕ≤K⌠ykñ⌠¼juC
A-2 IBM Informix .NET Provider ΓU
N
IBM ú@wbΩañúúñúUúBA B\αCnDb
zbºOioúPA AVϕa IBM A NϕdCb
ú IBM úBíA Aúϕtuα IBM úBíA C
unI IBM z]úvA⌠≤\αϕúBíA úiHN IBM
úBíA CúLAΣLD IBM úBíBA bB@WPτA
Σd⌠≤C
boσ≤ñiα]t IBM ºMQMQCú
ezMQº⌠≤vCziHΦí dvA τHG
IBM Director of LicensingIBM CorporationNorth Castle DriveArmonk, NY 10504-1785U.S.A.
Ynd÷G (DBCS) ΩTS\v¡yApzΩa IBM z]ú
íAΦíHG
IBM World Trade Asia Corporation Licensing2-31 Roppongi 3-chome, Minato-kuTokyo 106-0032, Japan
UCq¿YPΩºk°ΦAY°úAGIBM Hu¼vúAú
ú⌠≤qºO]]A²ú¡≤iΓXSwOCY
abYµ÷Wú\úWzOAhúLC
ñiαNWLΩWC]AIBM wqFNqß
eJsñCPAIBM oH∩i]ñúú]
íC
ΩTñ⌠≤∩D IBM ⌠zAIBM ∩⌠úúOC Web
WΩAD IBM úΩ@íA] Web y¿ºlA
QßµtdC
IBM oHUAϕΦíG Qßú⌠≤ΩTAL∩ztdC
íº≥vY µo÷ΩAHKUCΩTAió IBMCΣUCΩ
TⁿOG(1) WíPΣLí]]Aíºí≤½ΩTΦí (2)
¼wµ½ºΩTΦkCY⌠≤DpG
IBM CorporationJ46A/G4555 Bailey AvenueSan Jose, CA 95141-1003U.S.A.
WzΩºoΣSϕn≤AbYípUIOΦoC
© Copyright IBM Corp. 2003, 2007 B-1
IBM ≥≤ΦºuIBM ßXvBuΩívXv⌠≤PÑXº°A
úñzºvíPΣAvΩC
⌠≤B[\⌡µαΩúOb@ⁿε⌠UMwX C]AYbΣ
L@⌠UAoGiαjjúPCwwboÑqtWLAú
LoúOb@δtWXPGCAAwiαwzLΦí
⌠LC²ΩGiαDpCvSw⌠AdAΩ
C
úºD IBM úΩTAY@úAΣXnΣL
DoCIBM LoúA]LkToD IBM ú⌡µαBe
B⌠≤∩úΣLDiOLCpGz∩D IBM úα⌠≤
AwVúdC
÷ IBM V⌠≤»zANϕ IBM wAiα≤²ní
pUMC
IBM µúO IBM µsΓµAiαúw≤Aútµq
CgPµiαúPC
ΩT]tCΘ°τBñΩ°idCiαíAod
ú]AHBqBPúWCÑWΩcAZⁿΩ°
ºWaAXC
vv:
ΩT]tlyÑdíAHíU@¡xWí]pNCz
iH≥≤πoBBPΓGX@¡x]gdí@¡xº
ííÑAH⌠≤ísB∩GodíAúV
IBM IOCodígπC]A∩oíiaBA \αA
IBM úOCziH≥≤πoBBPΓGX IBM í
íÑAH⌠≤ísB∩GodíAúV IBM IOC
odí⌠≤l@C@⌠≤íúWpUvnG
©]zqW]≈CíXº@íYluIBM IBM Corp.
ívC© Copyright IBM Corp. (enter the year or years). All rights reserved.
pGzs²OΩTnΘAhmΓiαúπC
UCMWⁿO International Business Machines Corporation bⁿΩ () ΣLΩa
G
AIX DataBlade DB2DB2 Connect DB2 Universal Database IBMInformix MQSeries RETAIN
IntelBIntel xBIntel InsideBIntel Inside xBIntel CentrinoBIntel Centrino xB
CeleronBIntel XeonBIntel SpeedStepBItanium Pentium O Intel Corporation Σl
qbⁿΩΣLΩaUC
B-2 IBM Informix .NET Provider ΓU
Java Java ¼MxO Sun Microsystems, Inc. bⁿΩ () ΣLΩa
C
MicrosoftBWindowsBWindows NT H Windows xO Microsoft Corporation bⁿ
Ω () ΣLΩaC
UNIX O The Open Group bⁿΩΣLΩaUC
Linux O Linus Torvalds bⁿΩ () ΣLΩaUC
ΣLqBúA WAiαOΣLqA xC
N B-3
B-4 IBM Informix .NET Provider ΓU
HñσrAσrASϕº
CC
efúⁿΣΦk 3-6, 3-7
e
IfxBlob O 3-9
IfxCommand O 3-17
IfxCommandBuilder O 3-20
IfxConnection O 3-22
IfxConnectionStringBuilder O 3-27
IfxDataAdapter O 3-29
IfxDataReader O 3-32
IfxDataSourceEnumerator O 3-35
IfxDateTime c 3-37
IfxDecimal c 3-43
IfxError O 3-48
IfxErrorCollection O 3-48
IfxException O 3-48
IfxMonthSpan c 3-49
IfxParameter O 3-55
IfxParameterCollection O 3-57
IfxTimeSpan c 3-63
IfxTransaction O 3-68
3-6
A½≤ 1-3
≥ªO 3-6
íµ÷ 3-23, 4-6
kd 4-6
σ≤D viii
Φk
IfxClob O 3-14
IfxCommand O 3-18
IfxCommandBuilder O 3-21
IfxConnection O 3-25
IfxConnectionStringBuilder O 3-27
IfxDataAdapter O 3-30
IfxDataReader O 3-32
IfxDataSourceEnumerator O 3-35
IfxDateTime c 3-38
IfxDecimal c 3-43
IfxErrorCollection O 3-48
IfxMonthSpan c 3-50
IfxParameterCollection O 3-57
IfxProviderFactory O 3-58
IfxTimeSpan c 3-64
IfxTransaction O 3-68
Φk, úⁿΣ 3-6, 3-7
e¡fDnΣ 1-5, 1-6
D≈W
b SQLHOSTS ñ 1-2
HaIpµíϕyk A-1
NX, 3-48
íΣ 1-6
¡x 1-2
µ÷
kd 4-3
dí 4-1
efµ÷ 3-68
í 1-7, 3-23, 4-6
kd 4-3
≤ (GAC) 1-2
LΩD viii
Wí
J 1-4
IBM Informix .NET Provider 1-4
rΩσr 2-2
w
A≤ Microsoft Visual Studio IBM Informix .NET
Provider í 1-2
w IBM Informix .NET Provider 1-2
SQL »zí 1-6
INSERTBDELETE UPDATE 1-5, 3-20
eCfmOd 1-7
eKf≤
IfxConnection O 3-26
≤Ω@P 1-4, 1-5, 3-20, 3-28, 4-4
≤Uuπ xiii
HaIpµíϕyk A-1
yk, H⌡¬¬ A-1
Isxs
d 4-5
wr 1-6, 2-2, 3-21
3-55
© Copyright IBM Corp. 2003, 2007 X-1
eEf
IfxCommand O 3-17
IfxCommandBuilder O 3-20
IfxConnection O 3-22
IfxConnectionStringBuilder O 3-27
IfxDataAdapter O 3-28
IfxDataSourceEnumerator O 3-35
IfxDateTime c 3-36
IfxDecimal c 3-42
IfxMonthSpan c 3-49
IfxParameter O 3-54
IfxParameterCollection O 3-56
IfxTimeSpan c 3-62
cl
IfxBlob O 3-8
IfxClob O 3-13
IfxCommand O 3-17
IfxCommandBuilder O 3-20
IfxConnection O 3-22
IfxDataAdapter O 3-28
IfxDateTime c 3-36
IfxDecimal c 3-42
IfxMonthSpan c 3-49
IfxParameter O 3-54
IfxTimeSpan c 3-62
ⁿOµD
p≤¬ x
d x
ⁿVeσ 1-3, 3-24, 3-31, 4-2
eQfα 3-31
íµ
b IfxDateTime ñ 3-36
íd≥¼ 3-36, 3-49
Sϕr 1-6
Tº 3-47
l 1-8
C 1-7
¬πW≤ 1-2
eQ@fA SQL 1-7
C 1-7
¼ 2-2
¬Ω 1-4, 3-31, 4-2
≡ 3-24
NΩ DataSet
d 4-3
¼rΩσr 2-2
jεα¼Ad 4-1
º¼p 1-8
X
xiii
Θr¼ ix
≤, ¬πW 1-2
sΩw 1-4
surΩ 1-4
H°Φíwq 1-5
d 3-26
3-23
suxs 1-6, 3-24
eQGfµ@ϕµ≤s 3-20
µr 2-2
íJεC, d 4-3
ú⌡µⁿw 1-4
úW 1-4
, °
¬yk A-1
n² 1-5
íXd
IfxCommand O 3-19
íX, d, D xii
⌠íµ 3-36, 3-49
°
¬yk A-1
líµ 3-36, 3-49
eQTfJWí 1-4
, X xiii
Ω 1-3
Ωw
s 1-4
eQfD
σ≤ viii
LΩ viii
ⁿOµ x
yk ix
ykWh ix
díX xii
⌠⌠⌠qT≤w 6 (IPv6) 1-2
yÑ⌠ 3-23
ykq xi
yk
H⌡¬¬ A-1
D ix
÷Σr≤ xii
b xii
X-2 IBM Informix .NET Provider ΓU
eQ¡fd 4-1
µ÷k 4-3
DataSet ñ≤PΩw≤@P 4-4
íµ÷ 4-6
Isxs 4-5
NΩ DataSet 4-3
NΩ¼jεα¼s¼ 4-1
surΩ 3-26
íJεC 4-3
hεC 4-2
µ@ 4-1
ExecuteNonQuery k 4-3
ExecuteScalar Φkk 4-1
IfxCommandBuilder k 4-4
IfxCommand.CommandType ek 4-5
IfxDataAdapter k 4-3
IfxDataReader Ok 4-2
IfxParameter Ok 3-55
IfxTransaction Ok 3-68
System.DataSet k 4-3
dí 4-1
díXD xii
eQf⌡¬
¬yk A-1
ΘJ 1-7, 3-55
ΘX 1-6, 3-55
Tº 1-8, 3-47
eQCfxs 1-7, 3-21, 4-5
⌠ ix
pΩT xiii
eQKfhεC
d 4-2
µ@, d 4-1
Ω 4-2
r 2-2
eQEf÷Y 1-3
÷¼su 1-5
÷Σr
bykñ xii
O, úⁿΣ 3-6, 3-7
eGQfiTº 3-47
eGQ@fA ≤s 1-4
eGQTf, bykñ xii
AAbs Φk
IfxDecimal c 3-43
AcceptChangesDuringFill e
IfxDataAdapter O 3-29
AcceptChangesDuringUpdate e
IfxDataAdapter O 3-29
Add Φk
IfxConnectionStringBuilder O 3-27
IfxDateTime c 3-38
IfxDecimal c 3-43
IfxMonthSpan c 3-50
IfxParameterCollection O 3-57
IfxTimeSpan c 3-64
Add 3-29
AddDays Φk
IfxDateTime c 3-38
AddMilliseconds Φk
IfxDateTime c 3-38
AddMinutes Φk
IfxDateTime c 3-38
AddMonths Φk
IfxDateTime c 3-39
AddSeconds Φk
IfxDateTime c 3-39
AddWithKey 3-29
AddYears Φk
IfxDateTime c 3-39
ADO.NET 1-3
AnsiString ¼ 2-2
Append ¿
IfxSmartLOBOpenMode C 3-61
AppendKeyValuePair Φk
IfxConnectionStringBuilder O 3-28
ArgumentException º¼p 3-24
ASP.NET 1-1, 4-1
BBegin ¿
IfxSmartLOBWhence C 3-61
X-3
BeginTransaction Φk
IfxConnection O 3-25
Blob ¿
IfxType C 3-69
BLOB ¼ 2-1
Boolean ¿
IfxType C 3-69
BOOLEAN ¼ 2-1
Both 3-18
Buffer ¿
IfxSmartLOBOpenMode C 3-61
Byte ¿
IfxType C 3-69
BYTE ¼ 2-1
CCancel Φk
IfxCommand O 3-18
cdotnet.sql Script 1-3
Ceiling Φk
IfxDecimal c 3-43
ChangeDatabase Φk
IfxConnection O 3-26
Char ¿
IfxType C 3-69
CHAR ¼ 2-1
Char1 ¿
IfxType C 3-69
CHAR(1) ¼ 2-1
Clear Φk
IfxConnectionStringBuilder O 3-28
IfxParameterCollection O 3-57
Client Locale surΩ 3-23
Client SDK 1-2
Client ¿
IfxSmartLOBFileLocation C 3-60
ClientLocale e
IfxConnection O 3-22
Clob ¿
IfxType C 3-69
CLOB ¼ 2-1
Clone Φk
IfxDecimal c 3-44
Close e
IfxConnection
k 1-5
Close Φk
IfxBlob O 3-10
IfxClob O 3-14
IfxConnection O 3-26
IfxDataReader O 3-32
CloseConnection 3-18
Collection ¿
IfxType C 3-69
COLLECTION ¼ 2-2
CommandText e 1-7
IfxCommand 3-17
CommandTimeout e 1-5
IfxCommand 3-17
CommandType e 1-7
IfxCommand 3-17
IfxCommand O
kd 4-5
Commit Φk
IfxTransaction O 3-68
Compare Φk
IfxDateTime c 3-39
IfxDecimal c 3-44
IfxMonthSpan c 3-50
IfxTimeSpan c 3-64
CompareTo Φk
IfxDateTime c 3-40
IfxDecimal c 3-44
IfxMonthSpan c 3-50
IfxTimeSpan c 3-64
ConflictOption e
IfxCommandBuilder O 3-20
Connection Lifetime surΩ 3-23
Connection e 1-5
IfxCommand 3-17
IfxTransaction O 3-68
ConnectionString e
3-23
IfxConnection
k 1-5
IfxConnection O 3-22
IfxConnectionStringBuilder O 3-27
ConnectionTimeout e
IfxConnection O 3-23
Contains Φk
IfxParameterCollection O 3-57
ContainsKey Φk
IfxConnectionStringBuilder O 3-28
CopyTo Φk
IfxParameterCollection O 3-57
Count e
IfxConnectionStringBuilder O 3-27
IfxErrorCollection O 3-48
IfxParameterCollection O 3-57
CREATE DATABASE... »zí 3-23
CreateCommand Φk
IfxConnection O 3-26
IfxProviderFactory O 3-59
CreateCommandBuilder Φk
IfxProviderFactory O 3-59
CreateConnection Φk
IfxProviderFactory O 3-58
CreateConnectionStringBuilder Φk
IfxProviderFactory O 3-58
CreateDataAdapter Φk
IfxProviderFactory O 3-59
X-4 IBM Informix .NET Provider ΓU
CreateDataSourceEnumerator Φk
IfxProviderFactory O 3-59
CreateParameter Φk
IfxCommand O 3-18
IfxProviderFactory O 3-59
CreatePermission Φk
IfxProviderFactory O 3-59
Current ¿
IfxSmartLOBWhence C 3-61
DDataAdapter e
IfxCommandBuilder O 3-20
Database Locale surΩ 3-23
Database e
IfxConnection O 3-23
Database surΩ 3-23
DatabaseLocale e
IfxConnection O 3-23
DATABASE... »zí 3-23
DataColumn 1-3
DataReader ½≤ 1-4
DataRelation 1-3
DataSet ½≤ 1-3, 2-1
kd 4-3
DataTable 1-3
Date e
IfxDateTime c 3-37
Date ¿
IfxType C 3-69
DATE ¼ 2-1
DateTime ¿
IfxType C 3-69
DATETIME Ω¼ 3-36
DATETIME ¼ 2-1
Day e
IfxDateTime c 3-37
Day ¿
IfxTimeUnit C 3-67
Days e
IfxTimeSpan c 3-63
DaysInMonth Φk
IfxDateTime c 3-40
DB surΩ 3-23
DbProviderFactory O 3-58
DbType e
IfxParameter O 3-55
DB_LOCALE surΩ 3-23
Decimal ¿
IfxType C 3-69
DECIMAL ¼ 2-1
Default 3-18
DELETE »zí 3-20
DELETEA 1-5
DeleteCommand e 1-5
DeleteCommand e (≥)
IfxDataAdapter O 3-29
DELIMIDENT surΩ 3-23
DELIMIDENT ⌠ 1-5
w] 1-5
Depth e
IfxDataReader O 3-32
DeriveParameters Φk 1-7
IfxCommandBuilder O 3-21
Direction e
IfxParameter O 3-55
DirtyRead ¿
IfxSmartLOBOpenMode C 3-61
Dispose Φk 1-6
Disposed ≤
IfxConnection O 3-26
Divide Φk
IfxDecimal c 3-44
IfxMonthSpan c 3-51
IfxTimeSpan c 3-64
DontKeepAccessTime ¿
IfxSmartLOBCreateTimeFlags C 3-60
dotnetdemo Ω¿ 4-1
DOUBLE ¼ 2-1
Duration Φk
IfxMonthSpan c 3-51
IfxTimeSpan c 3-65
EE e
IfxDecimal c 3-43
End ¿
IfxSmartLOBWhence C 3-61
EndTimeUnit e
IfxDateTime c 3-37
IfxMonthSpan c 3-49
IfxTimeSpan c 3-63
Enlist surΩ 3-23
Enlist 1-7
Equals Φk
IfxDateTime c 3-40
IfxDecimal c 3-44
IfxMonthSpan c 3-51
IfxTimeSpan c 3-65
EquivalentTo Φk
IfxConnectionStringBuilder O 3-28
Error 3-29
Errors e
IfxException O 3-48
EstimatedSize e
IfxBlob 3-9
IfxClob 3-13
Exclusive ¿
IfxSmartLOBLockMode C 3-61
Exclusive surΩ 3-24
X-5
ExecuteNonQuery Φk
kd 4-3
IfxCommand O 3-18
ExecuteNonQuery() Φk 4-3
ExecuteReader Φk
IfxCommand O 3-18
ExecuteScalar Φk
IfxCommand O 3-19
ExecuteScalar ΦkAd 4-1
ExtentSize e
IfxBlob 3-9
IfxClob 3-13
FFBS surΩ 3-24
Fetch Buffer Size surΩ 3-24
FetchBufferSize e
IfxConnection O 3-23
FieldCount e
IfxDataReader O 3-32
Fill Φk
IfxDataAdapter O 3-30
FilLoadOption e
IfxDataAdapter O 3-29
FillSchema Φk
IfxDataAdapter O 3-30
FirstReturnedRecord 3-18
Flags e
IfxBlob 3-9
IfxClob 3-13
Float ¿
IfxType C 3-69
FLOAT ¼ 2-1
Floor Φk
IfxDecimal c 3-44
Fraction ¿
IfxTimeUnit C 3-67
Fraction1 ¿
IfxTimeUnit C 3-67
Fraction2 ¿
IfxTimeUnit C 3-67
Fraction3 ¿
IfxTimeUnit C 3-67
Fraction4 ¿
IfxTimeUnit C 3-67
Fraction5 ¿
IfxTimeUnit C 3-67
FromFile Φk
IfxBlob O 3-10
IfxClob O 3-14
FullTrust \iv 1-6
GGACC
\ ≤C
GetBoolean Φk
IfxDataReader O 3-32
GetByte Φk
IfxDataReader O 3-32
GetBytes Φk
IfxDataReader O 3-32
GetChar Φk
IfxDataReader O 3-32
GetChars Φk
IfxDataReader O 3-32
GetData Φk
IfxDataReader O 3-32
GetDataSources Φk
IfxDataSourceEnumerator O 3-35
GetDataTypeName Φk
IfxDataReader O 3-32
GetDateTime Φk
IfxDataReader O 3-32
GetDecimal Φk
IfxDataReader O 3-32
GetDeleteCommand Φk 1-6
IfxCommandBuilder O 3-21
GetDouble Φk
IfxDataReader O 3-33
GetEnumerator Φk
IfxErrorCollection O 3-48
IfxParameterCollection O 3-58
GetFieldType Φk
IfxDataReader O 3-33
GetFillParameters Φk
IfxDataAdapter O 3-30
GetFloat Φk
IfxDataReader O 3-33
GetGuid Φk
IfxDataReader O 3-33
GetHashCode Φk
IfxDateTime c 3-40
IfxDecimal c 3-45
IfxMonthSpan c 3-51
IfxTimeSpan c 3-65
GetIfxBlob Φk
IfxConnection O 3-26
GetIfxClob Φk
IfxConnection O 3-26
GetInsertCommand Φk 1-6
IfxCommandBuilder O 3-21
GetInt16 Φk
IfxDataReader O 3-33
GetInt32 Φk
IfxDataReader O 3-33
GetInt64 Φk
IfxDataReader O 3-33
X-6 IBM Informix .NET Provider ΓU
GetLocator Φk
IfxBlob O 3-10
IfxClob O 3-15
GetName Φk
IfxDataReader O 3-33
GetOrdinal Φk
IfxDataReader O 3-33
GetSchemaTable Φk
IfxDataReader O 3-33
GetString Φk
IfxDataReader O 3-33
GetString() Φk 2-2
GetTimeSpan Φk
IfxDataReader O 3-33
GetUpdateCommand Φk 1-6
IfxCommandBuilder O 3-21
GetValue Φk
IfxDataReader O 3-33
GetValues Φk
IfxDataReader O 3-33
GreaterThan Φk
IfxDateTime c 3-40
IfxDecimal c 3-45
IfxMonthSpan c 3-51
IfxTimeSpan c 3-65
GreaterThanOrEqual Φk
IfxDateTime c 3-40
IfxDecimal c 3-45
IfxMonthSpan c 3-51
IfxTimeSpan c 3-65
GUID ¼ 2-2
HHelpLink e
IfxException O 3-48
Host surΩ 3-24
Hour e
IfxDateTime c 3-37
Hour ¿
IfxTimeUnit C 3-67
Hours e
IfxTimeSpan c 3-63
IIBM Informix Client SDK 1-2
IBM Informix ODBC Driver 1-1
IBM Informix OLE DB Provider 1-1
IBM Informix .NET Provider
w 1-2
Wí 1-4
º[ 1-3
IBM.Data.Informix 3-58
IBM.Data.Informix Wí 1-4
IfxBlob O 3-8, 3-12
e 3-9
íσ 3-8
3-8
cl 3-8
Close Φk 3-10
EstimatedSize e 3-9
ExtentSize e 3-9
Flags e 3-9
FromFile Φk 3-10
GetLocator Φk 3-10
IsNull e 3-9
IsOpen e 3-9
LastAccessTime e 3-9
LastChangeTime e 3-9
LastModificationTime e 3-9
Lock Φk 3-10
MaxBytes e 3-9
Null e 3-10
Open Φk 3-10
Position e 3-10
Read Φk 3-11
ReferenceCount e 3-10
Release Φk 3-11
SBSpace e 3-10
Seek Φk 3-11
Size e 3-10
ToFile Φk 3-11
Truncate Φk 3-12
Unlock Φk 3-12
Write Φk 3-12
IfxBlob OΦk
Φk
IfxBlob O 3-10
IfxClob 3-12, 3-16
cl 3-13
IfxClob O
íσ 3-12
Φk 3-14
3-13
Close Φk 3-14
EstimatedSize e 3-13
ExtentSize e 3-13
Flags e 3-13
FromFile Φk 3-14
GetLocator Φk 3-15
IsNull e 3-13
IsOpen e 3-13
LastAccessTime e 3-14
LastChangeTime e 3-14
LastModification e 3-14
Lock Φk 3-15
MaxBytes e 3-14
Null e 3-14
Open Φk 3-15
Position e 3-14
X-7
IfxClob O (≥)
Read Φk 3-15
ReferenceCount e 3-14
Release Φk 3-15
SBSpace e 3-14
Seek Φk 3-16
Size e 3-14
ToFile Φk 3-16
Truncate Φk 3-16
Unlock Φk 3-16
Write Φk 3-16
IfxClob Oe
e
IfxClob O 3-13
IfxCommand O 3-17, 3-20
e 3-17
Φk 3-18
3-17
cl 3-17
íXd 3-19
Cancel Φk 3-18
CommandText e 3-17
CommandTimeout e 3-17
CommandType e 3-17
Connection e 3-17
CreateParameter Φk 3-18
ExecuteNonQuery Φk 3-18
ExecuteReader Φk 3-18
ExecuteScalar Φk 3-19
Parameters e 3-17
Prepare Φk 3-19
Transaction e 3-17
UpdatedRowSource e 3-17
IfxCommandBuilder O 1-4, 1-5, 3-20, 3-22
kd 3-21, 4-4
e 3-20
Φk 3-21
3-20
cl 3-20
ConflictOption e 3-20
DataAdapter e 3-20
DeriveParameters Φk 3-21
GetDeleteCommand Φk 3-21
GetInsertCommand Φk 3-21
GetUpdateCommand Φk 3-21
QuotePrefix e 3-20
QuoteSuffix e 3-21
RefreshSchema Φk 3-21
IfxCommand.ExecuteNonQuery() Φk 4-3
IfxConnection ½≤
Close e
k 1-5
ConnectionString e
H°Φíwq 1-5
k 1-5
IfxConnection ConnectionString e
H°Φíwq 1-5
IfxConnection O 3-22, 3-27
e 3-22
Φk 3-25
H°Φí 1-5
≤ 3-26
3-22
sΩw 1-4
BeginTransaction Φk 3-25
ChangeDatabase Φk 3-26
ClientLocale e 3-22
Close Φk 3-26
ConnectionString e 3-22
ConnectionTimeout e 3-23
CreateCommand Φk 3-26
Database e 3-23
DatabaseLocale e 3-23
Disposed ≤ 3-26
FetchBufferSize e 3-23
GetIfxBlob Φk 3-26
GetIfxClob Φk 3-26
InfoMessage ≤ 3-26
Open Φk 1-4, 3-26
PacketSize e 3-23
ServerVersion e 3-23
State e 3-23
StateChange ≤ 3-26
UserDefinedTypeFormat e 3-23
IfxConnection Ocl 3-22
IfxConnectionStringBuilder O 3-27, 3-28
e 3-27
Φk 3-27
3-27
Add Φk 3-27
AppendKeyValuePair Φk 3-28
Clear Φk 3-28
ConnectionString e 3-27
ContainsKey Φk 3-28
Count e 3-27
EquivalentTo Φk 3-28
IsFixedSize e 3-27
IsReadOnly e 3-27
Keys e 3-27
Remove Φk 3-28
ToString Φk 3-28
TryGetValue Φk 3-28
Values e 3-27
IfxDataAdapter
kd 3-30
IfxDataAdapter O 1-5, 2-1, 3-20, 3-28, 3-31
e 3-29
Φk 3-30
kd 4-3
3-28
cl 3-28
X-8 IBM Informix .NET Provider ΓU
IfxDataAdapter O (≥)
AcceptChangesDuringFill e 3-29
AcceptChangesDuringUpdate e 3-29
DeleteCommand e 3-29
Fill Φk 3-30
FillLoadOption e 3-29
FillSchema Φk 3-30
GetFillParameters Φk 3-30
InsertCommand e 3-29
MissingMappingAction e 3-29
MissingSchemaAction e 3-29
ReturnProviderSpecifictypes e 3-29
SelectCommand e 3-29
TableMappings e 3-29
Update Φk 3-30
UpdateBatchSize e 3-29
UpdateCommand e 3-29
IfxDataReader O 3-31, 3-34, 4-2
e 3-32
Φk 3-32
kd 3-34, 4-2
Close Φk 3-32
Depth e 3-32
FieldCount e 3-32
GetBoolean Φk 3-32
GetByte Φk 3-32
GetBytes Φk 3-32
GetChar Φk 3-32
GetChars Φk 3-32
GetData Φk 3-32
GetDataTypeName Φk 3-32
GetDateTime Φk 3-32
GetDecimal Φk 3-32
GetDouble Φk 3-33
GetFieldType Φk 3-33
GetFloat Φk 3-33
GetGuid Φk 3-33
GetInt16 Φk 3-33
GetInt32 Φk 3-33
GetInt64 Φk 3-33
GetName Φk 3-33
GetOrdinal Φk 3-33
GetSchemaTable Φk 3-33
GetString Φk 3-33
GetTimeSpan Φk 3-33
GetValue Φk 3-33
GetValues Φk 3-33
IsClosed e 3-32
IsDBNull Φk 3-33
NextResult Φk 3-33
Read Φk 3-34
RecordsAffected e 3-32
VisibleFieldCount e 3-32
IfxDataReader.GetString() Φk 2-2
IfxDataSourceEnumerator O 3-34, 3-35
e 3-35
IfxDataSourceEnumerator O (≥)
Φk 3-35
3-35
GetDataSources Φk 3-35
Instance e 3-35
IfxDateTime c 3-35, 3-42
ñíµ 3-36
e 3-37
Φk 3-38
¡ε 3-35
3-36
cl 3-36
w] 3-36
Add Φk 3-38
AddDays Φk 3-38
AddMilliseconds Φk 3-38
AddMinutes Φk 3-38
AddMonths Φk 3-39
AddSeconds Φk 3-39
AddYears Φk 3-39
Compare Φk 3-39
CompareTo Φk 3-40
Date e 3-37
Day e 3-37
DaysInMonth Φk 3-40
EndTimeUnit e 3-37
Equals Φk 3-40
GetHashCode Φk 3-40
GreaterThan Φk 3-40
GreaterThanOrEqual Φk 3-40
Hour e 3-37
LessThan Φk 3-41
LessThanOrEqual Φk 3-41
MaxValue e 3-37
Millisecond e 3-37
Minute e 3-37
MinValue e 3-37
Month e 3-37
NotEquals Φk 3-41
Now e 3-37
Null e 3-38
Parse Φk 3-41
Second e 3-38
StartTimeUnit e 3-38
Ticks e 3-38
Today e 3-38
ToString Φk 3-42
Year e 3-38
IfxDecimal c 3-42, 3-47
e 3-43
Φk 3-43
3-42
cl 3-42
Abs Φk 3-43
Add Φk 3-43
Ceiling Φk 3-43
X-9
IfxDecimal c (≥)
Clone Φk 3-44
Compare Φk 3-44
CompareTo Φk 3-44
Divide Φk 3-44
E e 3-43
Equals Φk 3-44
Floor Φk 3-44
GetHashCode Φk 3-45
GreaterThan Φk 3-45
GreaterThanOrEqual Φk 3-45
IsFloating e 3-43
IsNull e 3-43
IsPositive e 3-43
LessThan Φk 3-45
LessThanOrEqual Φk 3-45
Max Φk 3-45
MaxPrecision e 3-43
MaxValue e 3-43
Min Φk 3-45
MinusOne e 3-43
MinValue e 3-43
Modulo Φk 3-46
Multiply Φk 3-46
Negate Φk 3-46
NotEquals Φk 3-46
Null e 3-43
One e 3-43
Parse Φk 3-46
Pi e 3-43
Remainder Φk 3-46
Round Φk 3-46
Subtract Φk 3-47
ToString Φk 3-47
Truncate Φk 3-47
kd 3-47
Zero e 3-43
IFXDOTNETTRACE ⌠ 1-8
IFXDOTNETTRACEFILE ⌠ 1-9
IfxError O 3-47, 3-48
e 3-48
Message e 3-48
NativeError e 3-48
SQLState e 3-48
IfxErrorCollection O 3-48
Φk 3-48
Count e 3-48
GetEnumerator Φk 3-48
IfxErrorCollection Oe 3-48
IfxException O 3-48, 3-49
e 3-48
Errors e 3-48
HelpLink e 3-48
InnerException e 3-48
Message e 3-48
StackTrace e 3-48
IfxException O (≥)
TargetSite e 3-48
IfxMonthSpan c 3-49, 3-53
e 3-49
¡ε 3-49
3-49
cl 3-49
Add Φk 3-50
Compare Φk 3-50
CompareTo Φk 3-50
Divide Φk 3-51
Duration Φk 3-51
EndTimeUnit e 3-49
Equals Φk 3-51
GetHashCode Φk 3-51
GreaterThan Φk 3-51
GreaterThanOrEqual Φk 3-51
IsNull e 3-49
LessThan Φk 3-51
LessThanOrEqual Φk 3-52
MaxValue e 3-49
MinValue e 3-49
Months e 3-49
Multiply Φk 3-52
Negate Φk 3-52
NotEquals Φk 3-52
Null e 3-50
Parse Φk 3-52
StartTimeUnit e 3-50
ToString Φk 3-53
TotalMonths e 3-50
Years e 3-50
Zero e 3-50
IfxMonthSpan cΦk 3-50
IfxParameter cl 2-2
IfxParameter O 3-53, 3-56
e 3-55
kd 3-55
3-54
cl 3-54
DbType e 3-55
Direction e 3-55
IfxType e 3-55
IsNullable e 3-55
ParameterName e 3-55
SourceColumn e 3-55
SourceVersion e 3-55
Value e 3-55
IfxParameterCollection O 3-56, 3-58
e 3-57
Φk 3-57
3-56
Add Φk 3-57
Clear Φk 3-57
Contains Φk 3-57
CopyTo Φk 3-57
X-10 IBM Informix .NET Provider ΓU
IfxParameterCollection O (≥)
Count e 3-57
GetEnumerator Φk 3-58
IndexOf Φk 3-58
Insert Φk 3-58
Item e 3-57
Remove Φk 3-58
RemoveAt Φk 3-58
IfxProviderFactory O 3-58, 3-59
Φk 3-58
CreateCommand Φk 3-59
CreateCommandBuilder Φk 3-59
CreateConnection Φk 3-58
CreateConnectionStringBuilder Φk 3-58
CreateDataAdapter Φk 3-59
CreateDataSourceEnumerator Φk 3-59
CreateParameter Φk 3-59
CreatePermission Φk 3-59
IfxSmartLOBCreateTimeFlags C 3-60
DontKeepAccessTime ¿ 3-60
KeepAccessTime ¿ 3-60
Log ¿ 3-60
NoLog ¿ 3-60
IfxSmartLOBFileLocation C 3-60
Client ¿ 3-60
Server ¿ 3-60
IfxSmartLOBLockMode C 3-61
Exclusive ¿ 3-61
Shared ¿ 3-61
IfxSmartLOBOpenMode C 3-61
Append ¿ 3-61
Buffer ¿ 3-61
DirtyRead ¿ 3-61
LockAll ¿ 3-61
LockRange ¿ 3-61
NoBuffer ¿ 3-61
ReadOnly ¿ 3-61
ReadWrite ¿ 3-61
WriteOnly ¿ 3-61
IfxSmartLOBWhence C 3-61, 3-62
Begin ¿ 3-61
Current ¿ 3-61
End ¿ 3-61
IfxTimeSpan c 3-62, 3-67
e 3-63
Φk 3-64
3-62
cl 3-62
Add Φk 3-64
Compare Φk 3-64
CompareTo Φk 3-64
Days e 3-63
Divide Φk 3-64
Duration Φk 3-65
EndTimeUnit e 3-63
Equals Φk 3-65
IfxTimeSpan c (≥)
GetHashCode Φk 3-65
GreaterThan Φk 3-65
GreaterThanOrEqual Φk 3-65
Hours e 3-63
IsNull e 3-63
LessThan Φk 3-65
LessThanOrEqual Φk 3-65
MaxScale e 3-63
MaxValue e 3-63
Milliseconds e 3-63
Minutes e 3-63
MinValue e 3-63
Negate Φk 3-66
NotEquals Φk 3-66
Null e 3-63
Parse Φk 3-66
Seconds e 3-63
StartTimeUnit e 3-63
Ticks e 3-64
ToString Φk 3-66
Zero e 3-64
IfxTimeUnit C 3-67
Day ¿ 3-67
Fraction ¿ 3-67
Fraction1 ¿ 3-67
Fraction2 ¿ 3-67
Fraction3 ¿ 3-67
Fraction4 ¿ 3-67
Fraction5 ¿ 3-67
Hour ¿ 3-67
Minute ¿ 3-67
Month ¿ 3-67
Second ¿ 3-67
Year ¿ 3-67
IfxTransaction O 3-68, 3-69
e 3-68
Φk 3-68
kd 3-68
Commit Φk 3-68
Connection e 3-68
IsolationLevel e 3-68
Rollback Φk 3-68
IfxType e
IfxParameter O 3-55
IfxType 2-2
IfxType C 3-69, 4-1
Blob ¿ 3-69
Boolean ¿ 3-69
Byte ¿ 3-69
Char ¿ 3-69
Char1 ¿ 3-69
Clob ¿ 3-69
Collection ¿ 3-69
Date ¿ 3-69
DateTime ¿ 3-69
X-11
IfxType C (≥)
Decimal ¿ 3-69
Float ¿ 3-69
Int8 ¿ 3-69
Integer ¿ 3-69
IntervalDayFraction ¿ 3-69
IntervalYearMonth ¿ 3-69
List ¿ 3-69
LVarChar ¿ 3-69
Money ¿ 3-69
MultiSet ¿ 3-69
NChar ¿ 3-69
NVarChar ¿ 3-69
Row ¿ 3-69
Serial ¿ 3-69
Serial8 ¿ 3-69
Set ¿ 3-69
SmallFloat ¿ 3-69
SmallInt ¿ 3-69
SmartLOBLocator ¿ 3-69
Text ¿ 3-69
VarChar ¿ 3-69
Ignore 3-29
IndexOf Φk
IfxParameterCollection O 3-58
InfoMessage ≤
IfxConnection O 3-26
Informix Client SDK 1-2
Informix ODBC Driver 1-1
Informix OLE DB Provider 1-1
Informix Ω¼ 3-55
Informix ¼ 3-69
InnerException e
IfxException O 3-48
Insert Φk
IfxParameterCollection O 3-58
INSERT »zí 3-20
InsertCommand e 1-5
IfxDataAdapter O 3-29
INSERT, 1-5
Instsance e
IfxDataSourceEnumerator O 3-35
Int32 ¼ 2-1
Int64 ¼ 2-1
Int8 ¿
IfxType C 3-69
INT8 ¼ 2-1
Integer ¿
IfxType C 3-69
INTEGER ¼ 2-1
INTERVAL ¼ 2-1
IntervalDayFraction ¿
IfxType C 3-69
IntervalYearMonth ¿
IfxType C 3-69
IP 3-24
IP (≥)
SQLHOSTS ñ IPv6 µí 1-2
IPv6C
\ ⌠⌠⌠qT≤w 6 C
IsClosed e
IfxDataReader O 3-32
IsDBNull Φk
IfxDataReader O 3-33
IsFixedSize e
IfxConnectionStringBuilder O 3-27
IsFloating e
IfxDecimal c 3-43
IsNull e
IfxBlob 3-9
IfxClob 3-13
IfxDecimal c 3-43
IfxMonthSpan c 3-49
IfxTimeSpan c 3-63
IsNullable e
IfxParameter O 3-55
IsolationLevel e
IfxTransaction O 3-68
IsOpen e
IfxBlob 3-9
IfxClob 3-13
IsPositive e
IfxDecimal c 3-43
IsReadOnly e
IfxConnectionStringBuilder O 3-27
Item e
IfxParameterCollection O 3-57
JJOIN BΓl 1-6
KKeepAccessTime ¿
IfxSmartLOBCreateTimeFlags C 3-60
KeyInfo 3-18
Keys e
IfxConnectionStringBuilder O 3-27
LLastAccessTime e
IfxBlob 3-9
IfxClob 3-14
LastChangeTime e
IfxBlob 3-9
IfxClob 3-14
LastModificationTime e
IfxBlob 3-9
IfxClob 3-14
X-12 IBM Informix .NET Provider ΓU
LessThan Φk
IfxDateTime c 3-41
IfxDecimal c 3-45
IfxMonthSpan c 3-51
IfxTimeSpan c 3-65
LessThanOrEqual Φk
IfxDateTime c 3-41
IfxDecimal c 3-45
IfxMonthSpan c 3-52
IfxTimeSpan c 3-65
List ¿
IfxType C 3-69
LIST ¼ 2-2
Lock Φk
IfxBlob O 3-10
IfxClob O 3-15
LockAll ¿
IfxSmartLOBOpenMode C 3-61
LockRange ¿
IfxSmartLOBOpenMode C 3-61
Log ¿
IfxSmartLOBCreateTimeFlags C 3-60
LVarChar ¿
IfxType C 3-69
LVARCHAR ¼ 2-1
MMax Pool Size surΩ 3-24
Max Pool Size 1-6
MAX ROWS 1-3
Max Φk
IfxDecimal c 3-45
MaxBytes e
IfxBlob 3-9
IfxClob 3-14
MaxPrecision e
IfxDecimal c 3-43
MaxScale e
IfxTimeSpan c 3-63
MaxValue e
IfxDateTime c 3-37
IfxDecimal c 3-43
IfxMonthSpan c 3-49
IfxTimeSpan c 3-63
Message e
IfxError O 3-48
IfxException O 3-48
Microsoft ODBC .NET 1-1
Microsoft OLE DB .NET 1-1
Microsoft Visual Studio í
w 1-2
Microsoft .NET 3-6
Microsoft .NET ≥ªO 3-6
Microsoft .NET Framework SDK 1-2
Microsoft .NET Wµ vii
Millisecond e
IfxDateTime c 3-37
Milliseconds e
IfxTimeSpan c 3-63
Min Pool Size surΩ 3-24
Min Pool Size 1-6
Min Φk
IfxDecimal c 3-45
MinusOne e
IfxDecimal c 3-43
Minute e
IfxDateTime c 3-37
Minute ¿
IfxTimeUnit C 3-67
Minutes e
IfxTimeSpan c 3-63
MinValue e
IfxDateTime c 3-37
IfxDecimal c 3-43
IfxMonthSpan c 3-49
IfxTimeSpan c 3-63
MissingMappingAction e 3-30
IfxDataAdapter O 3-29
MissingSchemaAction e
IfxDataAdapter O 3-29
Modulo Φk
IfxDecimal c 3-46
Money ¿
IfxType C 3-69
MONEY ¼ 2-2
Month e
IfxDateTime c 3-37
Month ¿
IfxTimeUnit C 3-67
Months e
IfxMonthSpan c 3-49
Multiply Φk
IfxDecimal c 3-46
IfxMonthSpan c 3-52
MultiSet ¿
IfxType C 3-69
MULTISET ¼ 2-2
NNativeError e
IfxError O 3-48
NChar ¿
IfxType C 3-69
NCHAR ¼ 2-2
Negate Φk
IfxDecimal c 3-46
IfxMonthSpan c 3-52
IfxTimeSpan c 3-66
NextResult Φk
IfxDataReader O 3-33
X-13
Nobuffer ¿
IfxSmartLOBOpenMode C 3-61
NoLog ¿
IfxSmartLOBCreateTimeFlags C 3-60
None 3-18
NotEquals Φk
IfxDateTime c 3-41
IfxDecimal c 3-46
IfxMonthSpan c 3-52
IfxTimeSpan c 3-66
Now e
IfxDateTime c 3-37
Null e
IfxBlob 3-10
IfxClob 3-14
IfxDateTime c 3-38
IfxDecimal c 3-43
IfxMonthSpan c 3-50
IfxTimeSpan c 3-63
NVarChar ¿
IfxType C 3-69
OODBC Driver 1-1
ODBC surΩ 3-24
ODBC .NET 1-1
OLE DB Provider 1-1
OLE DB .NET 1-1
One e
IfxDecimal c 3-43
Open Φk
IfxBlob O 3-10
IfxClob O 3-15
IfxConnection O 3-26
Optimize OpenFetchClose surΩ 3-24
OPTOFC surΩ 3-24
OPTOFC ⌠ 1-5
OutputParameters 3-18
PPacket Size surΩ 3-24
PacketSize e
IfxConnection O 3-23
ParameterCollection.Add Φk 1-7
ParameterName e
IfxParameter O 3-55
Parameters e
IfxCommand 3-17
Parse Φk
IfxDateTime c 3-41
IfxDecimal c 3-46
IfxMonthSpan c 3-52
IfxTimeSpan c 3-66
Passthrough 3-29
Password surΩ 3-24
Persist Security Info surΩ 3-24
Persist Security Info 3-24
Pi e
IfxDecimal c 3-43
Pooling surΩ 3-24
Pooling 1-6, 1-7
Position e
IfxBlob 3-10
IfxClob 3-14
Prepare Φk
IfxCommand O 3-19
PRO surΩ 3-24
Protocol surΩ 3-24
PWD surΩ 3-24
QQuotePrefix e 1-6
IfxCommandBuilder O 3-20
QuoteSuffix e 1-6
IfxCommandBuilder O 3-21
RRead Φk
IfxBlob O 3-11
IfxClob O 3-15
IfxDataReader O 3-34
ReadOnly ¿
IfxSmartLOBOpenMode C 3-61
ReadWrite ¿
IfxSmartLOBOpenMode C 3-61
REAL ¼ 2-2
RecordsAffected e
IfxDataReader O 3-32
ReferenceCount e
IfxBlob 3-10
IfxClob 3-14
RefreshSchema Φk 1-5
IfxCommandBuilder O 3-21
Release Φk
IfxBlob O 3-11
IfxClob O 3-15
Remainder Φk
IfxDecimal c 3-46
Remove Φk
IfxConnectionStringBuilder O 3-28
IfxParameterCollection O 3-58
RemoveAt Φk
IfxParameterCollection O 3-58
ReturnProviderSpecifictypes e
IfxDataAdapter O 3-29
X-14 IBM Informix .NET Provider ΓU
Rollback Φk
IfxTransaction O 3-68
Round Φk
IfxDecimal c 3-46
Row ¿
IfxType C 3-69
RowUpdating ≤ 3-20
SSBSpace e
IfxBlob 3-10
IfxClob 3-14
SchemaOnly 3-18
Second e
IfxDateTime c 3-38
Second ¿
IfxTimeUnit C 3-67
Seconds e
IfxTimeSpan c 3-63
Seek Φk
IfxBlob O 3-11
IfxClob O 3-16
SELECT »zí 1-3
SelectCommand e 1-5, 3-20
IfxDataAdapter O 3-29
SequentialAccess 3-18
Serial ¿
IfxType C 3-69
SERIAL ¼ 2-2
Serial8 ¿
IfxType C 3-69
Server ¿
IfxSmartLOBFileLocation C 3-60
Server surΩ 3-24
ServerVersion e
IfxConnection O 3-23
Service surΩ 3-24
Set ¿
IfxType C 3-69
SET ¼ 2-2
Setnet í 1-5
Shared ¿
IfxSmartLOBLockMode C 3-61
SingleResult 3-19
SingleRow 3-19
Size e
IfxBlob 3-10
IfxClob 3-14
SmallFloat ¿
IfxType C 3-69
SMALLFLOAT ¼ 2-2
SmallInt ¿
IfxType C 3-69
SmartLOBLocator ¿
IfxType C 3-69
SourceColumn e
IfxParameter O 3-55
SourceVersion e
IfxParameter O 3-55
SQL íX xii
SQLHOSTS
ñD≈W 1-2
ñ IPv6 IP 1-2
SQLState e
IfxError O 3-48
StackTrace e
IfxException O 3-48
StartTimeUnit e
IfxDateTime c 3-38
IfxMonthSpan c 3-50
IfxTimeSpan c 3-63
State e
IfxConnection O 3-23
StateChange ≤
IfxConnection O 3-26
StoredProcedure 3-17
String ¼ 2-1
Subtract Φk
IfxDecimal c 3-47
sysmaster Ωw 1-3
SystemException º¼p 3-29
System.DataSet O
≤PΩw≤@P
d 4-4
TTableDirect 3-17
TableMappings e 3-30
IfxDataAdapter O 3-29
TargetSite e
IfxException O 3-48
Text ¿
IfxType C 3-69
Text 3-18
TEXT ¼ 2-2
Ticks e
IfxDateTime c 3-38
IfxTimeSpan c 3-64
Today e
IfxDateTime c 3-38
ToFile Φk
IfxBlob O 3-11
IfxClob O 3-16
ToString Φk
IfxConnectionStringBuilder O 3-28
IfxDateTime c 3-42
IfxDecimal c 3-47
IfxMonthSpan c 3-53
IfxTimeSpan c 3-66
X-15
TotalMonths e
IfxMonthSpan c 3-50
Transaction e 1-5, 3-68
IfxCommand 3-17
Truncate Φk
IfxBlob O 3-12
IfxClob O 3-16
IfxDecimal c 3-47
TryGetValue Φk
IfxConnectionStringBuilder O 3-28
UUID surΩ 3-24
Unlock Φk
IfxBlob O 3-12
IfxClob O 3-16
Update Φk
IfxDataAdapter O 3-30
UPDATE »zí 3-20
UPDATEA 1-5
UpdateBatchSize e
IfxDataAdapter O 3-29
UpdateCommand e 1-5
IfxDataAdapter O 3-29
UpdatedRowSource e
IfxCommand 3-17
User ID surΩ 3-24
UserDefinedTypeFormat
3-25
UserDefinedTypeFormat e
3-25
IfxConnection O 3-23
VValue e
IfxParameter O 3-55
Values e
IfxConnectionStringBuilder O 3-27
VarChar ¿
IfxType C 3-69
VARCHAR ¼ 2-2
VisibleFieldCount e
IfxDataReader O 3-32
Visual BASIC .NET 1-1
Visual C++ .NET 1-1
Visual J++ .NET 1-1
WWrite Φk
IfxBlob O 3-12
IfxClob O 3-16
WriteOnly ¿
IfxSmartLOBOpenMode C 3-61
XXCL surΩ 3-24
YYear e
IfxDateTime c 3-38
Year ¿
IfxTimeUnit C 3-67
Years e
IfxMonthSpan c 3-50
ZZero e
IfxDecimal c 3-43
IfxMonthSpan c 3-50
IfxTimeSpan c 3-64
eSϕrf.NET DbType ¼ 2-2, 3-69
.NET Framework ¼ 3-69
.NET 3-6
.NET ≥ªO 3-6
? , 1-7
X-16 IBM Informix .NET Provider ΓU
G251-3002-00