16.9.9 SQLSetPos
- Organization of this subsection
(1) Function
This ODBC function sets the cursor position in a row set.
Note that HADB returns SQL_ERROR when SQLSTATE is HYC00.
(2) Format
SQLRETURN SQLSetPos ( SQLHSTMT StatementHandle, /* In */ SQLSETPOSIROW RowNumber, /* In */ SQLUSMALLINT Operation, /* In */ SQLUSMALLINT LockType /* In */ )
(3) Arguments
- StatementHandle
-
Specifies a statement handle.
- RowNumber
-
This argument is ignored, if specified.
- Operation
-
This argument is ignored, if specified.
- LockType
-
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 |
|
01001 |
Cursor operation conflict |
N |
|
|
01004 |
Character string data was right-truncated |
N |
|
|
01S01 |
Error in row |
N |
|
|
01S07 |
Fractional truncation |
N |
|
|
07006 |
Restricted data type attribute violation |
N |
|
|
07009 |
Invalid descriptor index |
N |
|
|
21S02 |
Degree of derived table does not match column list |
N |
|
|
22001 |
Character string data was right-truncated |
N |
|
|
22003 |
Numeric value out of range |
N |
|
|
22007 |
Invalid datetime format |
N |
|
|
22008 |
Datetime field overflow |
N |
|
|
22015 |
Interval field overflow |
N |
|
|
22018 |
Invalid character value for cast specification |
N |
|
|
23000 |
Integrity constraint violation |
N |
|
|
24000 |
Invalid cursor status |
N |
|
|
40001 |
Serialization failure |
N |
|
|
40003 |
Statement completion unknown |
N |
|
|
42000 |
Syntax error or access violation |
N |
|
|
44000 |
WITH CHECK OPTION violation |
N |
|
|
HY000 |
General error |
N |
|
|
HY001 |
Memory allocation error |
N |
|
|
HY008 |
Operation cancelled |
N |
|
|
HY010 |
Function sequence error |
N |
|
|
HY011 |
Attribute cannot be set now |
N |
|
|
HY013 |
Memory management error |
N |
|
|
HY090 |
Invalid string or buffer length |
N |
|
|
HY092 |
Invalid attribute or option identifier |
N |
|
|
HY107 |
Row value out of range |
N |
|
|
HY109 |
Invalid cursor position |
N |
|
|
HYC00 |
Optional feature not implemented |
The driver returns SQL_ERROR. |
Y |
|
HYT00 |
Timeout expired |
-- |
N |
|
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