Tivoli Service Desk 6.0 Developer's Toolkit Script Language Reference

SQL Error Code Definitions

Return to Main Page


Introduction

The return codes documented here are generated by Tivoli Service Desk Developer's Toolkit when it processes SQL statements. If you receive an error code that is not listed here, it was generated by the DBMS. In that case, refer to your DBMS documentation for the error code definition.

Code Ranges

SQL error codes are grouped into ranges, by message type, to help you identify the nature of the message by its number. The ranges are:

Range Type of Message
1 Success
-100 to -299 Information
-17301 to -17399 Errors (excluding text retrieval errors)
-17400 to -17499 Text Retrieval Subsystem Errors
-17500 to -17599 Warnings

Success Code

Error Code Definition
1 Success

Information Code

Error Code Definition
-100 Data not found

Error Codes

Error Code Definition
-17301 Out of memory
-17302 Field not found
-17303 Invalid command
-17304 Invalid cursor
-17305 Type mismatch
-17306 Unknown type
-17307 Cannot disconnect
-17308 Cannot connect
-17309 Cannot stop DBMS
-17310 Cannot initialize DBMS
-17311 Cursor closed
-17312 Cursor in use
-17313 Too many cursors
-17314 Too many statements
-17315 Invalid statement
-17316 Invalid statement handle
-17317 Statement closed
-17318 Unable to bind
-17319 Not initialized
-17320 Not logged on
-17321 Unable to create thread
-17322 Space unknown
-17323 Invalid date format
-17324 Invalid time format
-17325 Cannot insert unknown
-17326 Unknown statement
-17327 Unknown table
-17328 Unknown where
-17329 Unknown statement handle
-17330 Unknown cursor
-17331 Unable to create semaphore
-17332 Unable to obtain semaphore
-17333 Statement in use
-17334 Duplicate key insert
-17335 Duplicate key insert multi line edit
-17336 Duplicate key update
-17337 Duplicate key update multi line edit
-17338 Foreign key insert
-17339 Foreign key update
-17340 Bind 805
-17341 Bind 818
-17342 Row has changed
-17343 Cannot update unknown
-17344 Bad parameter
-17345 Not connected
-17346 Invalid connection
-17347 Parent key delete
-17348 Parent key update
-17349 Not implemented
-17350 General error
-17351 Table not found
-17352 Unable to load object
-17353 Unable to free object
-17354 Too many connections
-17355 No transaction
-17356 Missing database
-17357 Already connected
-17358 Cannot nest transaction
-17359 Unrecognized option
-17360 Unrecognized driver
-17361 File open
-17362 Too many defaults
-17363 Too many auto connections
-17364 No driver
-17365 Missing entry
-17366 No source
-17367 Qualifier stack empty
-17368 No default source
-17369 No driver
-17370 Connection not found
-17371 Unrecognized source
-17372 Unrecognized driver
-17373 PC update number mismatch
-17374 PC update name mismatch
-17375 Unable to initialize trace
-17376 Transactions not supported
-17377 Invalid driver
-17378 Unable to get procedure address
-17379 Statement too long
-17380 Invalid driver mode

Text Retrieval Subsystem Errors

Error Code Definition
-17400 Invalid text retrieval object
-17401 Can not open configuration file
-17402 Null configuration string
-17403 Bad fetched data
-17404 Unknown index
-17405 Null column list
-17406 Index type conflict
-17407 No key
-17408 No longchar
-17409 Column type conflict
-17410 Index name not found
-17411 Bad key type
-17412 Bad filter list
-17413 Can not make cache
-17414 Join not allowed
-17415 Text retrieval not initialized
-17416 Duplicate index
-17417 Invalid text search

Warnings

Error Code Definition
-17500 Data truncation
-17501 Cursor open
-17502 Statement open
-17503 Transaction in progress
-17510 Null item

Tivoli Service Desk 6.0 Developer's Toolkit Script Language Reference

Return to Main Page

Copyright