SQL Reference

CREATE WRAPPER

The CREATE WRAPPER statement registers a wrapper--a mechanism by which a federated server can interact with a certain category of data sources--to a federated database.

Invocation

This statement can be embedded in an application program or issued through the use of dynamic SQL statements. It is an executable statement that can be dynamically prepared. However, if the bind option DYNAMICRULES BIND applies, the statement cannot be dynamically prepared (SQLSTATE 42509).

Authorization

The authorization ID of the statement must have SYSADM or DBADM authority.

Syntax

>>-CREATE WRAPPER----wrapper-name------------------------------->
 
>-----+--------------------------+-----------------------------><
      '-LIBRARY--'library-name'--'
 

Description

wrapper-name

Names the wrapper. It can be:

• A predefined name. If a predefined name is specified, the federated server automatically assigns a default to 'library-name'.

  The predefined names are:

  DRDA

  For all DB2 family data sources

  NET8

  For all Oracle data sources that are supported by Oracle's Net8 client software

  OLEDB

  For all OLE DB providers supported by Microsoft OLE DB

  SQLNET

  For all Oracle data sources that are supported by Oracle's SQL*Net client software

• A user-supplied name. If such a name is provided, it is necessary to also specify 'library-name'.

LIBRARY 'library-name'

Names the file that contains the wrapper module. The LIBRARY option is only necessary when a user-supplied wrapper-name is used. This option should not be used when a predefined wrapper-name is given. The default file names for the predefined wrapper-names are:

Table 26. Default file names for LIBRARY option

Platform	DRDA	SQLNET	NET8	OLEDB
AIX	libdrda.a	libsqlnet.a	libnet8.a	-
HP-UX	libdrda.sl	libsqlnet.sl	libnet8.sl	-
SOLARIS	libdrda.so	libsqlnet.so	libnet8.so	-
UNIX	libdrda.a	libsqlnet.a	libnet8.a	-
WINNT	drda.dll	sqlnet.dll	net8.dll	db2oledb.dll

Notes

Refer to Installation and Configuration Supplement for more information on how to select and define wrappers.

Examples

Example 1: Register a wrapper that the federated server can use to interact with an Oracle data source that is supported by Oracle's SQL*Net client software. Use the predefined name.

   CREATE WRAPPER SQLNET      

Example 2: Register a wrapper that the federated server on an AIX system can use to interact with DB2 for VM and VSE data sources. Specify a name to indicate that these data sources are used for testing.

   CREATE WRAPPER TEST 
      LIBRARY 'libsqlds.a'