IBM Books

Image, Audio, and Video Extenders Administration and Programming


SQLSTATE codes

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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]