Data type mappings for non-relational data sources

For some non-relational data sources, the data type mappings are not in the wrappers. In some cases, you must specify the local type information in the CREATE NICKNAME statement.

The following example shows how column data types are specified in the CREATE NICKNAME statement for some of the nonrelational data sources:

CREATE NICKNAME DRUGDATA1
   (Dcode Integer NOT NULL, Drug CHAR(20), Manufacturer CHAR(20))
   FOR SERVER biochem_lab 
   OPTIONS (FILE_PATH '/usr/pat/DRUGDATA1.TXT', COLUMN_DELIMITER ',',
   SORTED 'Y', KEY_COLUMN 'DCODE', VALIDATE_DATA_FILE 'Y')