Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

204 Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

Figure B-40 ODBC data source - Create Nicknames

Select the R_TRACKING nickname and click OK to create the nickname with the

defaults. Clicking Show SQL displays the SQL used to create the nickname, as

shown in Figure B-41.

Figure B-41 ODBC data source - SQL for creating the nickname

The default schema for the nicknames is the user ID that is creating it. In our

case that is NALUR1.

Test the ODBC nickname

To test the R_TRACKING nickname, right-click it, and click Sample

Contents, as shown in Figure B-42 on page 205.

Appendix B. Configuring data sources in DB2 Information Integrator 205

Figure B-42 ODBC wrapper - Create nickname - Sample Contents

The results of the sample contents request is displayed in Figure B-43 on

page 206, showing that the nickname creation was successful.