16.9.7 SQLFetchScroll
- Organization of this subsection
(1) Function
This ODBC function fetches a specified row set of data from the result set and returns data for all bound columns.
Note that HADB returns SQL_ERROR when SQLSTATE is HYC00.
(2) Format
SQLRETURN SQLFetchScroll ( SQLHSTMT StatementHandle, /* In */ SQLSMALLINT FetchOrientation, /* In */ SQLLEN FetchOffset /* In */ )
(3) Arguments
- StatementHandle
-
Specifies a statement handle.
- FetchOrientation
-
This argument is ignored, if specified.
- FetchOffset
-
This argument is ignored, if specified.
(4) Return value
This ODBC function returns SQL_ERROR or SQL_INVALID_HANDLE.
(5) SQLSTATE
This ODBC function returns one of the following SQLSTATE values:
|
SQLSTATE |
Description |
Remarks |
Returned |
|---|---|---|---|
|
01000 |
General warning |
-- |
N |
|
01004 |
Character string data was right-truncated |
N |
|
|
01S01 |
Error in row |
N |
|
|
01S06 |
An attempt was made to fetch before the result set returned the first row set |
N |
|
|
01S07 |
Fractional truncation |
N |
|
|
07006 |
Restricted data type attribute violation |
N |
|
|
07009 |
Invalid descriptor index |
N |
|
|
08S01 |
Communication link failure |
N |
|
|
22001 |
Character string data was right-truncated |
N |
|
|
22002 |
Required indicator variable not supplied |
N |
|
|
22003 |
Numeric value out of range |
N |
|
|
22007 |
Invalid datetime format |
N |
|
|
22012 |
Division by zero |
N |
|
|
22015 |
Interval field overflow |
N |
|
|
22018 |
Invalid character value for cast specification |
N |
|
|
24000 |
Invalid cursor status |
N |
|
|
40001 |
Serialization failure |
N |
|
|
40003 |
Statement completion unknown |
N |
|
|
HY000 |
General error |
N |
|
|
HY001 |
Memory allocation error |
N |
|
|
HY008 |
Operation cancelled |
N |
|
|
HY010 |
Function sequence error |
N |
|
|
HY013 |
Memory management error |
N |
|
|
HY090 |
Invalid string or buffer length |
N |
|
|
HY106 |
Fetch type out of range |
N |
|
|
HY107 |
Row value out of range |
N |
|
|
HY111 |
Invalid bookmark value |
N |
|
|
HYC00 |
Optional feature not implemented |
The driver returns SQL_ERROR. |
Y |
|
HYT01 |
Connection timeout expired |
-- |
N |
|
IM001 |
Driver does not support this function |
N |
- Legend:
-
Y: This SQLSTATE might be returned by the HADB ODBC driver.
N: This SQLSTATE is not returned by the HADB ODBC driver.
--: None