The following table lists and describes the SQLSTATE values that can be
returned by the DB2 extenders. The description of each SQLSTATE value
includes its symbolic representation. The table also lists the message
number associated with each SQLSTATE value. See Messages for information about each message.
Table 15. SQLSTATE codes and associated message numbers
SQLSTATE | Message No. | Description |
---|---|---|
00000 |
MMDB_SQLSTATE_OK Successful | |
01H01 | DMB0211W |
MMDB_SQLSTATE_WARN_NO_OVERWRITE The file overwrite does not take place |
38A00 | DMB0101E |
MMDB_SQLSTATE_AUDIO_NULL_PARM Input parameter to the UDF cannot be null |
38A02 | DMB0209E |
MMDB_SQLSTATE_AUDIO_OPEN_HDR_ERROR Error occurred while opening audio file header |
38A03 | DMB0209E |
MMDB_SQLSTATE_AUDIO_BAD_WAVE_HDR Invalid wave file supplied |
38V00 | DMB0101E |
MMDB_SQLSTATE_VIDEO_NULL_PARM Input parameter to the UDF cannot be null |
38V02 | DMB0051E |
MMDB_SQLSTATE_VIDEO_OPEN_HDR_ERROR Error occurred while opening video file header |
38V03 | DMB0105E |
MMDB_SQLSTATE_VIDEO_BAD_MPEG1_HDR Invalid mpeg1 file supplied |
38V04 | DMB0104E |
MMDB_SQLSTATE_VIDEO_BLOB_TOO_SHORT Video buffer supplied is too small |
38V05 | DMB0106E |
MMDB_SQLSTATE_VIDEO_BAD_AVI_HDR Invalid AVI file supplied |
38V07 | DMB0106E |
MMDB_SQLSTATE_VIDEO_BAD_QT_HDR Invalid Quicktime file supplied |
38600 |
DMB0075E DMB0101E DMB0102E DMB0103E DMB0210E |
MMDB_SQLSTATE_INVALID_INPUT Input parameter to the UDF is not valid |
38601 | DMB0009E |
MMDB_SQLSTATE_MALLOC_FAIL Memory allocation failed |
38602 | DMB0386E |
MMDB_SQLSTATE_CANNOT_COLLOCATE Cannot collocate with user data |
38603 | DMB0077E |
MMDB_SQLSTATE_READ_FILE_FAIL Cannot read from file |
38604 | DMB0080E |
MMDB_SQLSTATE_WRITE_FILE_FAIL Cannot write to file |
38610 | DMB0070E |
MMDB_SQLSTATE_INVALID_HANDLE Media column contains invalid data |
38611 | DMB0073E |
MMDB_SQLSTATE_INVALID_SESSION_HANDLE Invalid UDF session handle |
38612 | DMB0074E |
MMDB_SQLSTATE_INVALID_STATEMENT_HANDLE Invalid UDF statement handle |
38613 | DMB0083E |
MMDB_SQLSTATE_INVALID_IMPORT_REQUEST The request for import is not valid |
38615 | DMB0071E |
MMDB_SQLSTATE_CONNECT_FAIL Error occurred while connecting to database |
38617 | DMB0071E |
MMDB_SQLSTATE_ALLOC_STMT_FAIL Error occurred while allocating a new statement handle |
38618 |
DMB0208E DMB0138E |
MMDB_SQLSTATE_FREE_STMT_FAIL Error occurred while freeing statement |
38619 |
DMB0208E DMB0132E |
MMDB_SQLSTATE_BIND_FAIL Error occurred while binding |
38620 | DMB0208E |
MMDB_SQLSTATE_BIND_COLUMN_FAIL Error occurred while binding a column |
38621 | DMB0208E |
MMDB_SQLSTATE_BIND_FILE_FAIL Error occurred while binding file |
38622 |
DMB0208E DMB0132E |
MMDB_SQLSTATE_SET_PARAM_FAIL Error occurred while setting parameter |
38623 |
DMB0208E DMB0131E |
MMDB_SQLSTATE_PREPARE_FAIL Error occurred while preparing an SQL statement |
38624 |
DMB0208E DMB0133E |
MMDB_SQLSTATE_EXECUTE_FAIL Error occurred while executing a statement |
38625 |
DMB0208E DMB0133E |
MMDB_SQLSTATE_EXEC_DIRECT_FAIL Error occurred while directly executing SQL statement in UDF |
38626 |
DMB0208E DMB0133E |
MMDB_SQLSTATE_FETCH_FAIL Error occurred while retrieving next row of data |
38627 | DMB0208E |
MMDB_SQLSTATE_COMMIT_FAIL Error occurred while committing the transaction |
38628 | DMB0208E |
MMDB_SQLSTATE_GET_LENGTH_FAIL Error occurred while retrieving the length of a string value |
38629 | DMB0208E |
MMDB_SQLSTATE_GET_SUBSTRING_FAIL Error occurred while retrieving a portion of a string value |
38650 |
DMB0077E DMB0079E |
MMDB_SQLSTATE_COPY_BLOB_2_FILE_FAIL Error occurred while copying BLOB to a file |
38651 | DMB0086E |
MMDB_SQLSTATE_BLOB_BUFFER_TOO_SMALL The buffer supplied is too small |
38652 | DMB0082E |
MMDB_SQLSTATE_BUILD_HANDLE Error occurred while constructing media column data |
38653 | DMB0083E |
MMDB_SQLSTATE_INVALID_INSERT_VIA_SELECT The request for insert via select is not valid |
38654 | DMB0081E |
MMDB_SQLSTATE_INVALID_OFFSET_SIZE The offset size is not valid |
38655 | DMB0068E |
MMDB_SQLSTATE_METATABLE_DOESNOT_EXIST The required metadata table does not exist |
38670 |
DMB0134E DMB0103E |
MMDB_SQLSTATE_UNKNOWN_FORMAT The stored media has unknown format |
38671 | DMB0135E |
MMDB_SQLSTATE_CREATE_THUMBNAIL_FAIL Error occurred while creating the thumbnail |
38672 | DMB0114E |
MMDB_SQLSTATE_FORMAT_CONVERSION_FAIL Error occurred while converting the file format |
38673 | DMB0363E |
MMDB_SQLSTATE_INVALID_UPDATE Error occured when an update UDF was invoked without referencing a table |
38674 | DMB0361E |
MMDB_SQLSTATE_NOT_ENABLED Error occured when an import UDF was applied to a column which was not enabled for the extender |
38675 | DMB0129E |
MMDB_SQLSTATE_VIDEO_INTERNAL Internal error in Video Extender UDFs |
38676 | DMB0129E |
MMDB_SQLSTATE_AUDIO_INTERNAL Internal error in Audio Extender UDFs |
38677 | DMB0129E | MMDB_SQLSTATE_IMAGE_INTERNAL |
38678 |
DMB0089E DMB0208E |
MMDB_SQLSTATE_BASE_INTERNAL_ERROR Internal error in common layer |
38681 | DMB0108E |
MMDB_SQLSTATE_IMPORT_ENV_NOT_SETUP Environment variable for import is not set up correctly |
38682 | DMB0111E |
MMDB_SQLSTATE_STORE_ENV_NOT_SETUP Environment variable for store operation is not set up correctly |
38683 | DMB0107E |
MMDB_SQLSTATE_EXPORT_ENV_NOT_SETUP Environment variable for export operation is not set up correctly |
38684 | DMB0117E |
MMDB_SQLSTATE_TEMP_ENV_NOT_SETUP Environment variable for creating temporary files is not set up correctly |
38686 | DMB0109E |
MMDB_SQLSTATE_CANT_RESOLVE_IMPORT_FILE Error occurred while resolving import file name |
38687 | DMB0112E |
MMDB_SQLSTATE_CANT_RESOLVE_STORE_FILE Error occurred while resolving store file name |
38688 | DMB0110E |
MMDB_SQLSTATE_CANT_RESOLVE_EXPORT_FILE Error occurred while resolving export file name |
38689 | DMB0116E |
MMDB_SQLSTATE_CANT_CREATE_TMP_FILE Error occurred while creating temporary file |
38690 | DMB0076E |
MMDB_SQLSTATE_OPEN_IMPORT_FILE_FAIL Cannot open import file |
38691 | DMB0115E |
MMDB_SQLSTATE_OPEN_STORE_FILE_FAIL Cannot open import file |
38692 | DMB0114E |
MMDB_SQLSTATE_OPEN_EXPORT_FILE_FAIL Cannot open export file |
38693 | DMB0118E |
MMDB_SQLSTATE_OPEN_TEMP_FILE_FAIL Cannot open temporary file |
38694 | DMB0117E |
MMDB_SQLSTATE_OPEN_CONTENT_FILE_FAIL Cannot open content file |
38695 | DMB0135E |
MMDB_SQLSTATE_OPEN_THUMBNAIL_FILE_FAIL Cannot open thumbnail file |
38696 | DMB0135E |
MMDB_SQLSTATE_READ_THUMBNAIL_FILE_FAIL Cannot read thumbnail file |
38697 | DMB0207E |
MMDB_SQLSTATE_OVERWRITE_NOT_ALLOWED The overwrite operation could not be performed |
38699 | DMB0171E |
MMDB_SQLSTATE_QUERY_NAME_NOT_FOUND A query with that name was not found |
38700 |
|
MMDB_SQLSTATE_NO_MANAGEBLOB |
38701 |
|
MMDB_SQLSTATE_UDFLOCATOR_FAIL |
38702 |
|
MMDB_SQLSTATE_SQL_FAIL |
38703 |
|
MMDB_SQLSTATE_INVALID_UPDATE |
38704 |
|
MMDB_SQLSTATE_NOT_ENABLED |
38705 |
DMB0366E DMB0382E |
MMDB_SQLSTATE_QBIC_QUERY_FAIL_TO_BUILD A failure occurred in building the query |
38706 |
|
MMDB_SQLSTATE_QBIC_TABLE_COLUMN_PAIR _NOT_VALID |
38707 | DMB0383E |
MMDB_SQLSTATE_QBIC_QUERY_EXECUTE_FAILED A failure occurred in running the query |
38708 |
|
MMDB_SQLSTATE_QBIC_UKNOWN_ERROR An unkown failure occurred in QBIC |
38709 | DMB0208E |
MMDB_COPY_FILE_TO_LOCATOR_FAILURE A failure occurred in copying a file to a LOB locator |
38710 | DMB0534E |
MMDB_SQLSTATE_QBIC_UNSUPPORTED_UDF The UDF is not supported. |