16.9.10 SQLBulkOperations
- Organization of this subsection
(1) Function
This ODBC function performs batch insertions and batch bookmark operations using bookmarks. The batch bookmark processing includes update, delete, and fetch operations.
Note that HADB returns SQL_ERROR when SQLSTATE is HYC00.
(2) Format
SQLRETURN SQLBulkOperations ( SQLHSTMT StatementHandle, /* In */ SQLSMALLINT Operation /* In */ )
(3) Arguments
- StatementHandle
-
Specifies a statement handle.
- Operation
-
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 |
|
|
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 |
|
|
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