|
Topics: |
Omni-Payer™ HealthViews relies on a Hash64 function to create unique keys for the tables in the Omni-Payer™ HealthViews scheme. In addition, the Hash64 function is used to create integer values for fields that are character strings in Omni-Payer™. Joining integer fields provides improved performance than joining character strings.
The Hash64 function code is contained in the ibi_functions.so file. A system administrator who has the required authorization, must place the ibi_functions.so file in a known location (the default is /udbhome/udbinst4/sqllib/function) and set permissions to 755 (readable to all, executable by all).
Once there it is created by entering the following SQL command:
CREATE FUNCTION hash64(varchar(255)) RETURNS BIGINT EXTERNAL name '/udbhome/udbinst4/sqllib/function/ibi_functions!hash64' LANGUAGE C PARAMETER STYLE SQL DETERMINISTIC NOT FENCED NULL CALL NO SQL NO EXTERNAL ACTION
Note: Only a system administrator who has the required authorization must perform the steps described in this section.