ASE_FUNCTION_BEHAVIOR option

Specifies that output of Sybase IQ functions, including INTTOHEX and HEXTOINT, is consistent with the output of Adaptive Server Enterprise functions.

ON, OFF

OFF

DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.

When the ASE_BEHAVIOR_FUNCTION option is ON, some of the Sybase IQ data type conversion functions, including HEXTOINT and INTTOHEX, return output that is consistent with the output of Adaptive Server Enterprise functions. The differences in the ASE and Sybase IQ output, with respect to formatting and length, exist because ASE primarily uses signed 32-bit as the default and Sybase IQ primarily uses unsigned 64-bit as the default.

Sybase IQ does not provide support for 64-bit integer, as ASE does not have a 64-bit integer data type.

In this example, the HEXTOINT function returns a different value based on whether the ASE_FUNCTION_BEHAVIOR option is ON or OFF.

The HEXTOINT function returns 4294967287 with ASE_FUNCTION_BEHAVIOR OFF:

select hextoint(‘fffffff7’) from iq_dummy

The HEXTOINT function returns -9 with ASE_FUNCTION_BEHAVIOR ON:

select hextoint(‘fffffff7’) from iq_dummy