Cursor Positioning for Raiserror
- Last Updated: June 13, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- SAP Sybase IQ 8.0
- Documentation
Cursor Positioning for Raiserror
Attribute
RaiserrorPositionBehavior (REPB)
Purpose
Determines whether the driver returns raiserrors when the next statement is executed or handles them separately.
Valid Values
0 | 1
Behavior
If set to 0 (Default), raiserrors are handled separately
from surrounding statements. The error is returned when a raiserror is processed (for
example, resulting from SQLExecute, SQLExecDirect, or SQLMoreResults). The result set is
empty.
If set to 1 (Microsoft compatible), raiserrors are
returned when the next statement is processed, and the cursor is positioned on the first row
of the subsequent result set. This could result in multiple raiserrors being returned on a
single execute.
Default
0 (Default)