Functions

Functions

Removed Functions

The following are the functions that have been removed:

Removed

Description

MOD	This function is no longer necessary. You may use the MOD operator instead with ElevateDB.
LASTAUTOINC IDENT_CURRENT	These functions are no longer necessary. ElevateDB procedures and functions can retrieve the assigned IDENTITY value for a column using the FETCH statement on a cursor.
TEXTOCCURS	This function is no longer supported.
YEARSFROMMSECS DAYSFROMMSECS HOURSFROMMSECS MINSFROMMSECS SECSFROMMSECS MSECSFROMMSECS	These functions are no longer necessary. ElevateDB supports the standard SQL date and time interval types. Please see the Interval Types topic for more information.

Function Changes

The following are the changes to the functions:

Changed

Description

SUBSTRING	The alternate SUBSTR syntax is now acceptable.
TEXTSEARCH	This function has been changed to the CONTAINS and DOES NOT CONTAIN operators.

New Functions

The following are the new functions:

New	Description

None

More Support Options

Frequently Asked Questions

Technical Bulletins

Technical Articles

Incident Reports