You can control the error-handling behavior for the time series functions that call the IMSL libraries. If a runtime error occurs when invoking IMSL library functions, Sybase IQ responds according to your error-handling choice. You can choose from four error-handling options, ranging from ignoring all errors and warnings (the default behavior), to specifying which level of error severity causes Sybase IQ to abort a SQL statement and return an error message.
Use the following SQL statement to control error-handling:
set option PUBLIC.Time_Series_Error_Level = ‘<value>’
Valid values are:
Value |
Description |
|---|---|
0 (default) |
All types of warnings and errors that can be obtained while invoking an IMSL library function are ignored. When such a condition is encountered, the time series function returns a NULL value. |
1 |
If the time series function obtains a warning or an error message while invoking an IMSL library function, IQ returns an error message and aborts the SQL query. |
2 |
If the time series function obtains a fatal error message while invoking an IMSL library function, IQ returns an error message and aborts the SQL query. However if a warning is obtained then the time series function returns a NULL value. |
3 |
If the time series function obtains a terminal error message while invoking an IMSL library function, IQ returns an error message and aborts the SQL query. However if a warning or a fatal error is obtained then the time series function returns a NULL value. |
