
Appendix B. Configuring data sources in DB2 Information Integrator 229
Figure B-2 Oracle - Create Wrapper
If your target Oracle Server is Version 8i or higher, select Oracle using OCI 8,
otherwise choose Oracle using OCI 7. Since our Oracle Server was Oracle 9i,
we selected Oracle using OCI 8. For Wrapper name, we chose OracleWrapper
as shown in Figure B-2.
Click OK to create the Oracle wrapper.
Example B-2 shows the command line version for creating the OracleWrapper
wrapper.
Example: B-2 Create wrapper statement for Oracle
CONNECT TO FEDDEMO;
CREATE WRAPPER "ORACLEWRAPPER" LIBRARY 'db2net8.dll';
CONNECT RESET;
B.2.3 Create the Oracle server definition ...