Successful execution SQL codes

SQL return codes that are preceded by a plus sign (+) indicate that the SQL statement execution was successful.

000
SUCCESSFUL EXECUTION
+012
THE UNQUALIFIED COLUMN NAME column-name WAS INTERPRETED AS A CORRELATED REFERENCE
+020
BIND, REBIND, OR PRECOMPILE OPTION option-name IS NOT SUPPORTED BY THE TARGET SERVER AND WILL BE IGNORED.
+098
A DYNAMIC SQL STATEMENT ENDS WITH A SEMICOLON.
+100
ROW NOT FOUND FOR FETCH, UPDATE OR DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE
+110
SQL UPDATE TO A DATA CAPTURE TABLE NOT SIGNALED TO ORIGINATING SUBSYSTEM
+111
THE SUBPAGES OPTION IS NOT SUPPORTED FOR TYPE 2 INDEXES
+117
THE NUMBER OF INSERT VALUES IS NOT THE SAME AS THE NUMBER OF OBJECT COLUMNS
+162
TABLESPACE database-name.tablespace-name HAS BEEN PLACED IN CHECK PENDING
+203
THE QUALIFIED COLUMN NAME column-name WAS RESOLVED USING A NON-UNIQUE OR UNEXPOSED NAME
+204
name IS AN UNDEFINED NAME
+205
column-name IS NOT A COLUMN OF TABLE table-name
+206
column-name IS NOT A COLUMN OF AN INSERTED TABLE, UPDATED TABLE, MERGED TABLE, OR ANY TABLE IDENTIFIED IN A FROM CLAUSE
+217
THE STATEMENT WAS NOT EXECUTED AS ONLY EXPLAIN INFORMATION REQUESTS ARE BEING PROCESSED.
+218
THE SQL STATEMENT REFERENCING A REMOTE OBJECT CANNOT BE EXPLAINED
+219
THE REQUIRED EXPLANATION TABLE table-name DOES NOT EXIST
+220
THE COLUMN column-name IN EXPLANATION TABLE table-name IS NOT DEFINED PROPERLY
+222
HOLE DETECTED USING CURSOR cursor-name
+231
CURRENT POSITION OF CURSOR cursor-name IS NOT VALID FOR THE SPECIFIED FETCH ORIENTATION OF THE CURRENT ROW OR ROWSET
+236
SQLDA INCLUDES integer1 SQLVAR ENTRIES, BUT integer2 ARE REQUIRED FOR integer3 COLUMNS
+237
SQLDA INCLUDES integer1 SQLVAR ENTRIES, BUT integer2 ARE REQUIRED BECAUSE AT LEAST ONE OF THE COLUMNS BEING DESCRIBED IS A DISTINCT TYPE
+238
SQLDA INCLUDES integer1 SQLVAR ENTRIES, BUT integer2 SQLVAR ENTRIES ARE NEEDED FOR integer3 COLUMNS BECAUSE AT LEAST ONE OF THE COLUMNS BEING DESCRIBED IS A LOB
+239
SQLDA INCLUDES integer1 SQLVAR ENTRIES, BUT integer2 ARE REQUIRED FOR integer3 COLUMNS BECAUSE AT LEAST ONE OF THE COLUMNS BEING DESCRIBED IS A DISTINCT TYPE
+252
A NON-ATOMIC statement STATEMENT SUCCESSFULLY PROCESSED ALL REQUESTED ROWS, WITH ONE OR MORE WARNING CONDITIONS
+304
A VALUE WITH DATA TYPE data-type1 CANNOT BE ASSIGNED TO A HOST VARIABLE BECAUSE THE VALUE IS NOT WITHIN THE RANGE OF THE HOST VARIABLE IN POSITION position-number WITH DATA TYPE data-type2
+331
THE NULL VALUE HAS BEEN ASSIGNED TO A HOST VARIABLE OR PARAMETER BECAUSE THE STRING CANNOT BE CONVERTED FROM source-ccsid TO target-ccsid. REASON reason-code, POSITION position-number
+335
DB2 CONVERTED A HOST VARIABLE, PARAMETER, OR COLUMN NUMBER var-num var-name-or-num TO COLUMN NAME, HOST VARIABLE, OR EXPRESSION NUMBER col-name-or-num FROM from ccsid TO to-ccsid, AND RESULTING IN SUBSTITUTION CHARACTERS.
+347
THE RECURSIVE COMMON TABLE EXPRESSION name MAY CONTAIN AN INFINITE LOOP
+354
A ROWSET FETCH STATEMENT MAY HAVE RETURNED ONE OR MORE ROWS OF DATA. HOWEVER, ONE OR MORE WARNING CONDITIONS WERE ALSO ENCOUNTERED. USE THE GET DIAGNOSTICS STATEMENT FOR MORE INFORMATION REGARDING THE CONDITIONS THAT WERE ENCOUNTERED
+361
COMMAND WAS SUCCESSFUL BUT RESULTED IN THE FOLLOWING: msg-token
+364
DECFLOAT EXCEPTION exception-type HAS OCCURRED DURING operation-type OPERATION, POSITION position-number
+385
ASSIGNMENT TO AN SQLSTATE OR SQLCODE VARIABLE IN AN SQL ROUTINE routine-name MAY BE OVERWRITTEN AND DOES NOT ACTIVATE ANY HANDLER
+394
ALL USER SPECIFIED OPTIMIZATION HINTS USED DURING ACCESS PATH SELECTION
+395
A USER SPECIFIED OPTIMIZATION HINT IS INVALID (REASON CODE = reason-code)
+402
LOCATION location IS UNKNOWN
+403
THE LOCAL OBJECT REFERENCED BY THE CREATE ALIAS STATEMENT DOES NOT EXIST
+434
clause IS A DEPRECATED CLAUSE
+438
APPLICATION RAISED WARNING WITH DIAGNOSTIC TEXT: text
+440
NO routine-type BY THE NAME routine-name HAVING COMPATIBLE ARGUMENTS WAS FOUND
+445
VALUE value HAS BEEN TRUNCATED
+462
EXTERNAL FUNCTION OR PROCEDURE name (SPECIFIC NAME specific-name) HAS RETURNED A WARNING SQLSTATE, WITH DIAGNOSTIC TEXT text
+464
PROCEDURE proc RETURNED num QUERY RESULT SETS, WHICH EXCEEDS THE DEFINED LIMIT integer
+466
PROCEDURE proc RETURNED num QUERY RESULTS SETS
+494
NUMBER OF RESULT SETS IS GREATER THAN NUMBER OF LOCATORS
+495
ESTIMATED PROCESSOR COST OF estimate-amount1 PROCESSOR SECONDS (estimate-amount2 SERVICE UNITS) IN COST CATEGORY cost-category EXCEEDS A RESOURCE LIMIT WARNING THRESHOLD OF limit- amount SERVICE UNITS
+535
THE RESULT OF THE POSITIONED UPDATE OR DELETE MAY DEPEND ON THE ORDER OF THE ROWS
+541
THE REFERENTIAL OR UNIQUE CONSTRAINT name HAS BEEN IGNORED BECAUSE IT IS A DUPLICATE
+551
auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation ON OBJECT object-name
+552
auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation
+558
THE WITH GRANT OPTION IS IGNORED.
+562
A GRANT OF A PRIVILEGE WAS IGNORED BECAUSE THE GRANTEE ALREADY HAS THE PRIVILEGE FROM THE GRANTOR
+585
THE COLLECTION collection-id APPEARS MORE THAN ONCE WHEN SETTING THE special-register SPECIAL REGISTER
+599
COMPARISON FUNCTIONS ARE NOT CREATED FOR A DISTINCT TYPE BASED ON A LONG STRING DATA TYPE
+610
A CREATE/ALTER ON OBJECT object-name HAS PLACED OBJECT IN utility-name PENDING
+645
WHERE NOT NULL IS IGNORED BECAUSE THE INDEX KEY CANNOT CONTAIN NULL VALUES OR THE INDEX IS AN XML INDEX
+650
THE TABLE BEING CREATED OR ALTERED CANNOT BECOME A DEPENDENT TABLE
+653
TABLE table-name IN PARTITIONED TABLESPACE tspace-name IS NOT AVAILABLE BECAUSE ITS PARTITIONED INDEX HAS NOT BEEN CREATED
+655
STOGROUP stogroup_name HAS BOTH SPECIFIC AND NON-SPECIFIC VOLUME IDS. IT WILL NOT BE ALLOWED IN FUTURE RELEASES
+658
THE SUBPAGES VALUE IS IGNORED FOR THE CATALOG INDEX index-name
+664
THE INTERNAL LENGTH OF THE LIMIT-KEY FIELDS SPECIFIED IN THE PARTITION CLAUSE OF THE statement-name STATEMENT EXCEEDS THE EXISTING INTERNAL LIMIT KEY LENGTH STORED IN CATALOG TABLE table-name
+738
DEFINITION CHANGE OF object object_name MAY REQUIRE SIMILAR CHANGE ON READ-ONLY SYSTEMS
+799
THE SET STATEMENT set-stmt REFERENCES A SPECIAL REGISTER THAT DOES NOT EXIST AT THE SERVER SITE
+802
EXCEPTION ERROR exception-type HAS OCCURRED DURING operation-type OPERATION ON data-type DATA, POSITION position-number
+806
BIND ISOLATION LEVEL RR CONFLICTS WITH TABLESPACE LOCKSIZE PAGE OR LOCKSIZE ROW AND LOCKMAX 0
+807
THE RESULT OF DECIMAL MULTIPLICATION MAY CAUSE OVERFLOW
+863
THE CONNECTION WAS SUCCESSFUL BUT ONLY SBCS WILL BE SUPPORTED
+883
ROLLBACK TO SAVEPOINT OCCURRED WHEN THERE WERE OPERATIONS THAT CANNOT BE UNDONE, OR AN OPERATION THAT CANNOT BE UNDONE OCCURRED WHEN THERE WAS A SAVEPOINT OUTSTANDING
+4726
THE STATEMENT WAS SUCCESSFULLY PREPARED, BUT IT CANNOT BE EXECUTED BECAUSE authorization-id DOES NOT HAVE privilege-name PRIVILEGE ON OBJECT object-name BUT HAS EXPLAIN PRIVILEGE
+4748
THE statement STATEMENT FOR OBJECT object-name WAS SUCCESSFUL ON THE DB2 SERVER. THE OBJECT MAY NOT HAVE BEEN SUCCESSFULLY PROCESSED ON THE ACCELERATOR SERVER FOR REASON reason-code.
+4751
bind-type WARNING FOR PACKAGE = package-name, THE USE OF keyword RESULTED IN UNSUCCESSFUL COMPLETION FOR ONE OR MORE STATEMENTS.
+20002
THE specification-source SPECIFICATION IS IGNORED FOR OBJECT object-name
+20007
USE OF OPTIMIZATION HINTS IS DISALLOWED BY A DB2 SUBSYSTEM PARAMETER. THE SPECIAL REGISTER 'OPTIMIZATION HINT' IS SET TO AN EMPTY STRING.
+20122
DEFINE NO OPTION IS NOT APPLICABLE IN THE CONTEXT SPECIFIED
+20141
TRUNCATION OF VALUE WITH LENGTH length OCCURRED FOR hv-or-parm-number
+20187
ROLLBACK TO SAVEPOINT CAUSED A NOT LOGGED TABLE SPACE TO BE PLACED IN THE LPL
+20224
ENCRYPTED DATA THAT WAS ORIGINALLY A BINARY STRING CANNOT BE DECRYPTED TO A CHARACTER STRING
+20237
FETCH PRIOR ROWSET FOR CURSOR cursor-name RETURNED A PARTIAL ROWSET
+20245
NOT PADDED CLAUSE IS IGNORED FOR INDEXES CREATED ON AUXILIARY TABLES
+20270
OPTION NOT SPECIFIED FOLLOWING ALTER PARTITION CLAUSE
+20271
THE NAME AT ORDINAL POSITION position-number IN THE STATEMENT, WITH NAME object-name, WAS TRUNCATED.
+20272
TABLE SPACE table-space-name HAS BEEN CONVERTED TO USE TABLE-CONTROLLED PARTITIONING INSTEAD OF INDEX-CONTROLLED PARTITIONING, ADDITIONAL INFORMATION: old-limit-key-value
+20278
THE VIEW view-name MAY NOT BE USED TO OPTIMIZE THE PROCESSING OF QUERIES
+20348
THE PATH VALUE HAS BEEN TRUNCATED.
+20360
TRUSTED CONNECTION CAN NOT BE ESTABLISHED FOR SYSTEM AUTHID authorization-name
+20365
A SIGNALING NAN WAS ENCOUNTERED, OR AN EXCEPTION OCCURRED IN AN ARITHMETIC OPERATION OR FUNCTION INVOLVING A DECFLOAT.
+20367
OPTION clause IS NOT SUPPORTED IN THE CONTEXT IN WHICH IT WAS SPECIFIED
+20368
TRUSTED CONTEXT context-name IS NO LONGER DEFINED TO BE USED BY SPECIFIC VALUES FOR ATTRIBUTE attribute-name.
+20371
THE ABILITY TO USE TRUSTED CONTEXT context-name WAS REMOVED FROM SOME, BUT NOT ALL AUTHORIZATION IDS SPECIFIED IN THE STATEMENT.
+20378
A NON-ATOMIC statement STATEMENT SUCCESSFULLY COMPLETED FOR SOME OF THE REQUESTED ROWS, POSSIBLY WITH WARNINGS, AND ONE OR MORE ERRORS, AND THE CURSOR CAN BE USED
+20458
THE PROCEDURE procedure-name HAS ENCOUNTERED AN INTERNAL PARAMETER PROCESSING ERROR IN PARAMETER number1. THE VALUE FOR PARAMETER number2 CONTAINS FURTHER INFORMATION ABOUT THE ERROR.
+20459
THE PROCEDURE procedure-name HAD ENCOUNTERED AN INTERNAL PROCESSING ERROR. THE VALUE FOR PARAMETER number CONTAINS FURTHER INFORMATION ABOUT THE ERROR.
+20460
THE PROCEDURE procedure-name SUPPORTS A HIGHER VERSION, version1. THAN THE SPECIFIED VERSION, version2, FOR PARAMETER number.
+20461
THE PROCEDURE procedure-name RETURNED OUTPUT IN THE ALTERNATE LOCALE, locale1, INSTEAD OF THE LOCALE locale2, SPECIFIED IN PARAMETER number.
+20468
THE COMBINATION OF TARGET NAMESPACE target-namespace AND SCHEMA LOCATION HINT location-hint IS NOT UNIQUE IN THE DB2 XML SCHEMA REPOSITORY.
+20520
ATTEMPT TO USE A DEPRECATED FEATURE ON OBJECT object-name. REASON CODE reason-code
+30100
OPERATION COMPLETED SUCCESSFULLY BUT A DISTRIBUTION PROTOCOL VIOLATION HAS BEEN DETECTED. ORIGINAL SQLCODE=original-sqlcode AND ORIGINAL SQLSTATE=original-sqlstate

Parent topic: SQL codes