IBM InfoSphere Federation Server, Version 10.1

Registering nicknames for BioRS data sources

For each BioRS server definition that you register, you must register a nickname for each databank that you want to access. Use these nicknames, instead of the names of the databanks, when you query the BioRS servers.

Before you begin

If a BioRS databank name does not conform to the syntax required by the CREATE NICKNAME statement, you must use the REMOTE_OBJECT nickname option when you register the nickname.
If a BioRS element name does not conform to the syntax required by the CREATE NICKNAME statement, you must use the ELEMENT_NAME column option when you register the nickname.

About this task

Restrictions

Do not use the BioRS AllText element as the first column for a nickname. You can use the BioRS AllText element in any other column position (for example, as the second column or as the third column).

After a data source has been integrated into the BioRS system, it is referred to as a databank in BioRS. Databanks in BioRS equate to nicknames in a federated system.

The names that you give the nicknames can be up to 128 characters in length.

Procedure

Issue the CREATE NICKNAME statement from the command line.

For example:

CREATE NICKNAME nickname
(
column_name data_type 
   OPTIONS (nickname_column_options),
column_name data_type 
   OPTIONS (nickname_column_options),
column_name data_type 
   OPTIONS (nickname_column_options)
)
FOR SERVER server_definition_name
OPTIONS (nickname_options);

When you create a BioRS nickname, you define a list of nickname columns. The specified nickname columns must correspond to elements of a specific BioRS databank format. BioRS defines five possible data types for elements: Text, Number, Date, Author, and Reference. The BioRS data types can be mapped only to the CHAR, CLOB, or VARCHAR data types that are used by the federated database.

What to do next

Repeat this step for each BioRS databank that you want to create a nickname for.

Feedback

Last updated: 2012-05-18