
Appendix B. Data consolidation examples 349
Switch to the Settings menu to complete your server edition. For server settings
visualized in Figure B-26, some input fields require definition, and some are
optional. The first two fields, Node and Password, are required.
Figure B-26 Oracle - Create Server - Settings
Example B-4shows the command line version of creating the server for your
Oracle instance. Additionally, you may check your server definition in the DB2
federated system catalog with the two select statements listed below.
Example: B-4 Oracle - Create server statement
CONNECT TO FEDDB;
CREATE SERVER ORASRC TYPE ORACLE VERSION '9' WRAPPER ...