Notes on creating a column data editing UOC routine

To execute a column data editing UOC routine, specify the directory path to the shared library file in an environment variable. Note that the environment variable and the shared library file to be used depend on the OS. The following table shows the environment variable and shared library file for each OS.

Table 8-34 Environment variable and shared library file for each OS

OS	Environment variable	Shared library file
HP-UX (32-bit or 64-bit edition)	SHLIB_PATH	libhdscuoc.sl
HP-UX (IPF version), Solaris, or Linux (32-bit, IPF, or EM64T version)	LD_LIBRARY_PATH	libhdscuoc.so
AIX	LIBPATH	libhdscuoc.a

If the environment variable is not specified or there is no shared library file at the directory path specified in the environment variable, Datareplicator executes import processing without using the column data editing UOC routine.

Organization of this subsection: (1) Limitations on signals; (2) Limitations on file manipulations; (3) Limitations on shared memory; (4) Limitations on data types; (5) Limitations on SQL execution; (6) Notes about the AIX Datareplicator; (7) Notes about handling repetition columns

(1) Limitations on signals

(2) Limitations on file manipulations

You can manipulate only user-specific files (that are open) within a column data editing UOC routine's function. The following are the file-related rules:

Do not use the standard input, standard output, or standard error output.
Do not read, write, or close any file that is not opened by the UOC routine.
Do not manipulate any file that belongs to HiRDB or Datareplicator.

(3) Limitations on shared memory

(4) Limitations on data types

Columns of the following data types are not supported by column data editing UOC routines; if such a column is specified, an error occurs during import definition analysis:
- Abstract data types (SGMLTEXT, FREEWORD, XML)
- BLOB type
- BINARY type
SMALLFLOAT-type data is passed as FLOAT-type data to the UOC routine (to avoid overflow that might occur due to a difference in representation range).
If an extracted column is the UNPACK type, Datareplicator converts it to DECIMAL-type data, and then passes it to the column data editing UOC routine. If Datareplicator cannot convert the UNPACK data to DECIMAL data, it passes the UNPACK data to the UOC routine.

(5) Limitations on SQL execution

(6) Notes about the AIX Datareplicator

(7) Notes about handling repetition columns

A column data editing UOC routine passes each element of the data (a single call to a column data editing UOC function passes one element data item to this UOC function). This means that a column data editing UOC routine cannot be used to increase or decrease the number of elements.