Miscellaneous Enhancements

External Functions (UDFs)

User-defined functions.-

In the ib_udf Library

rpad()

Juan Guerrero

rpad (instring, length, padcharacter)

Right-pads the supplied string instring by appending padcharacters until the result string has the given length.

The input string can be any length less than 32766 bytes. Length must not exceed 32765 bytes.

Declaration

DECLARE EXTERNAL FUNCTION rpad

CSTRING(80), INTEGER, CSTRING(1)

RETURNS CSTRING(80) FREE_IT

ENTRY_POINT 'IB_UDF_rpad' MODULE_NAME 'ib_udf';

lpad()

Juan Guerrero

lpad (instring, length, padcharacter)

Left-pads the supplied string instring by prepending padcharacters until the result string has the given length.

The input string can be any length less than 32766 bytes. Length must not exceed 32765 bytes.

Declaration

DECLARE EXTERNAL FUNCTION lpad

CSTRING(80), INTEGER, CSTRING(1)

RETURNS CSTRING(80) FREE_IT

ENTRY_POINT 'IB_UDF_lpad' MODULE_NAME 'ib_udf';

log()

Paul Vinkenoog

log (x, y)

This function had an old bug, whereby the arguments x and y were erroneously reversed. It should return the logarithm base x of y but in fact it returned the log base y of x. It has been corrected.

51