Cursor Positioning for Raiserror
- Last Updated: June 13, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- 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)