The SYSBldRelease Function

SYSBldRelease( ) is a function signature that HCL OneDB™ defines in all databases of the server instance. You can invoke this function with the EXECUTE FUNCTION statement of SQL or with the CALL statement of SPL to return the version string of the SYSBldPrepare( ) function.

The SYSBldRelease( ) function has this definition:

CREATE FUNCTION informix.sysbldrelease() 
   RETURNS LVARCHAR
EXTERNAL NAME
   '$INFORMIXDIR/extend/%SYSBLDDIR%/ifxmngr.bld(MackRelease)'
   LANGUAGE C NOT VARIANT;
GRANT EXECUTE ON FUNCTION SYSBldRelease() TO PUBLIC;

This function takes no arguments. It returns the version string and compilation date of the SYSBldPrepare( ) function. The returned version string has this format:

major.minor.os_codeCinterim

Here C is a literal character, and the major, minor, os_code, and interim version string elements have the same semantics that these terms have in the Module Reference segment of the SYSBldPrepare( ) function, but with no asterisk ( * ) wildcard notation.

SYSBldRelease( ) is useful when you contact HCL Support with SYSBldPrepare( ) issues.

The SYSBldPrepare( ) function needs to have been called at least once in the same database before SYSBldRelease( ) can return the correct version string of SYSBldPrepare( ). The call to SYSBldPrepare( ) does not need to be in the same session as the call to SYSBldRelease( ).