Skip to content
CA Datacom Messages
Documentation powered by DocOps

SQL Return Codes Quick Reference

Last update March 11, 2019

The following table provides the message text and link to easily access additional information for the SQL return codes.

TABLE/VIEW DOES NOT EXIST (table/new-name) AUTHID (auth-id)

Return Code Description
0 THE COMMAND WAS SUCCESSFUL
-1 NULL INDICATOR VARIABLE REQUIRED FOR OUTPUT HOST VARIABLE NUMBER nnn
-2 EMPTY QUERY STRING
-3 CANNOT REVOKE FROM YOURSELF
-4 OVERFLOW TYPE<x> ACTION<ASSIGNMENT/CONVERSION>
-5 TABLE tablename IN DDD AND NOT IN CXX
-6 STRING CONSTANT TOO LONG
-7 INCOMPLETE STRING. CHECK FOR MISSING QUOTES
-8 CANNOT GRANT TO YOURSELF
-9 ILLEGAL COLUMN NAME aaaa
-10 UNABLE TO ALLOCATE MEMORY
-12 COLUMN FUNCTIONS NOT ALLOWED IN SET CLAUSE OF QUERY
-14 NO RECORD FOUND
-15 AUTHID (auth-id) NOT DEFINED
-16 DEPENDENT PLAN (auth-id.plan-name) IN USE
-17 MODIFICATION OF COLUMN TO INCOMPATIBLE DATATYPE IS NOT ALLOWED
-18 WITH CHECK OPTION IS NOT ALLOWED ON NON-UPDATABLE VIEWS
-19 INDEX AND TABLE AUTHIDS DO NOT MATCH aaaa, bbbb
-20 BAD SYNTAX description WHEN THE ERROR OCCURRED, THE SYNTAX BELOW HAD BEEN PARSED statement
-21 DEFAULT CHARACTER LITERAL TOO LONG
-24 VIEWS CONTAINING FUNCTIONS OR GROUP BY CANNOT BE JOINED
-25 INCOMPLETE COMMENT
-26  EXCEEDS MAX NUMBER OF TABLES/VIEWS PERMITTED IN SUBSELECT
-27 CANNOT USE GROUP BY IN QUERY THAT REFERENCES A GROUPED VIEW
-29 HAVING CLAUSE IS ILLEGAL WHEN A REFERENCED VIEW CONTAINS A HAVING
-30 SQL IDENTIFIERS MAY NOT EXCEED 32 BYTES IN LENGTH
-31 CANNOT REFERENCE A VIEW CONTAINING SELECT DISTINCT IN THIS STATEMENT
-32 STATEMENT IS TOO LARGE TO COMPILE
-33 AMBIGUOUS COLUMN REFERENCE x...x
-34 ILLEGAL CORRELATION NAME nnnn
-35 TTM IS UNUSABLE SQLCODE xxx, DB RC yy(zzz) ON INITIALIZATION
-36 BAD FOREIGN KEY reason code,A,B,C,D,E,F,G
-37 CONSTRAINT REBIND FAILED A,B,C,D,E,F
-38 DB2 TRANSPARENCY OPTION IS NOT INSTALLED
-39 NEGATIVE RESULT FOR UNSIGNED DECIMAL TARGET
-40 CONSTRAINT AUTO-REBIND IN PROGRESS. PLEASE TRY AGAIN.
-41 DATATYPES OF OPERATION op-string NOT COMPATIBLE
-42

INVALID USE OF ESCAPE CHARACTER IN PATTERN OF LIKE PREDICATE

-43 COLUMN FUNCTION ON INVALID TYPE
-44 HOST VARIABLE NUMBER <xxx> HAS INVALID DATA TYPE <xxx>
-53 STRING TOO LONG FOR COLUMN nnn
-54 UNEQUAL NUMBER OF COLUMNS AND VALUES
-55 DUPLICATE NAMES IN INSERT/ALTER/CREATE LIST aaaa
-56 entity-type entity-name ALREADY EXISTS
-57 SPECIFIED MORE COLUMNS OR VALUES THAN THE TABLE HAS
-58 COLUMN aaaa DATATYPE INCOMPATIBLE WITH bbbb DATATYPE
-60 nnnn IS GREATER THAN MAXIMUM ALLOWABLE NUMBER OF COLUMNS
-66 ILLEGAL NUMBER nnnn IN ORDER SPECIFICATION
-67 COLUMN FUNCTIONS NOT ALLOWED IN WHERE CLAUSE OF QUERY
-69 TOO MANY SET CLAUSES IN UPDATE COMMAND
-70 ODER BY COLUMN aaaa IS NOT IN SELECT LIST OR IS A DUPLICATE
-71 SELECTING MORE THAN ONE ITEM IN A SUBQUERY
-72 CANNOT NEST COLUMN FUNCTIONS
-73 SELECTED COLUMNS MUST BE IN THE GROUP BY CLAUSE
-75 CANNOT USE COLUMN FUNCTIONS WITH NO GROUP BY CLAUSE
-76 colName IN HAVING NOT GROUP COLUMN OR COLUMN FUNCTION ARGUMENT
-79 UPDATE/DELETE WHERE CURRENT OF cursorname ON READ ONLY CURSOR
-80 ONLY ONE DISTINCT CLAUSE ALLOWED PER QUERY
-82 EACH QUERY IN A UNION MUST HAVE THE SAME NBR OF PROJECTED COLUMNS
-83 DATA TYPES IN COLUMN aaaa DO NOT MATCH
-84 ORDER BY ITEMS MUST BE CONSTANTS FOR UNION OF QUERIES
-85 ORDER BY MUST FOLLOW ALL QUERIES WHEN PERFORMING A UNION
-86 NULL NOT ALLOWED IN COLUMN aaaa
-87 CANNOT USE <UNION> AND <UNION ALL> IN SAME STATEMENT
100 NO ROW FOUND
-101 A SYNONYM ON A SYNONYM IS NOT ALLOWED
-103 MUST USE COLUMN FUNCTIONS IF HAVING CLAUSE WITH NO GROUP BY
-105 aaa IN bb
-109 VIEW COLUMN CONTAINING EXPRESSION OR FUNCTION USED ILLEGALLY
-110 ORDER BY IS NOT ALLOWED IN A VIEW DEFINITION
-111 THE VIEW IS NOT UPDATABLE BECAUSE IT CONTAINS A SUBQUERY
-113 THE VIEW'S COLUMN IS NOT UPDATABLE aaaa
-117 RAAT/CBS ERROR CMD=xxxxx TBL=ttt DBID=nnnn KEY=kkkkk RC=rr (iii)
-118 DSF dsf-code error [text varies]
-119 product_name error_text
-120 PROGRAM TIMESTAMP timestamp-in-decimal NOT = PLAN TIMESTAMP timestamp-in-decimal
-121 STATEMENT REBIND ERROR
-122 STATEMENT aaaa NOT FOUND
-123 PLAN ALREADY EXISTS
-124 PLAN authid.planname DOES NOT EXIST
-125 PLAN CURRENTLY IN USE
-126 NO MORE WORK SPACE
-127 sql-object-name NOT FOUND
-128 LUW ABORTED
-129 RRS COMMIT ROLLBACK
-130 CURSOR NOT UPDATEABLE
-131 RESULT TABLE LENGTH TOO LONG
-132 INVALID PLAN OPTION STRING DELIMITER
-133 CURSOR NAME aaaa NOT DECLARED
-134 UNKNOWN DYNAMIC/CURSOR STATEMENT-ID (aaaa)
-135 INVALID CURSOR STATE (STMT-ID=aaaa)
-136 SQLDA TRUNCATED - NEEDED aaaa ENTRIES
-137 PLAN OPTION CBSIO EXCEEDED
-138 INVALID 'PRIORITY' PLAN OPTION
-139 INVALID PLAN OPTION TIMEMIN
-140 INVALID PLAN OPTION TIMESEC
-141 INVALID 'PLNCLOSE' PLAN OPTION x
-142 MORE THAN 1 ROW SELECTED
-143 INVALID PLAN OPTION DECPOINT
-144 TRX ISOLATION LEVELS UNMATCHED
-145 INVALID 'ISOLEVEL' PLAN OPTION
-146 AUTHORIZATION ID LENGTH > 18
-147 OP. NOT ALLOWED AT ISOL. LEVEL U
-148 SUBQUERY AT LVL aaaa NBR bbbb RETURNED MORE THAN 1 ROW
-149 PLAN CAN'T SPECIFY DATACOM SQLMODE WHEN MUF OPTION SPECIFIES ANSI
-150 AUTHORIZATION ID MUST MATCH SCHEMA'S AUTHORIZATION ID
-151 INVALID PRECISION OR SCALE SPECIFICATION ON aaaa
-152 MAXIMUM NUMBER OF TABLES EXCEEDED FOR OPERATION
-153 DUPLICATE CURSOR NAME DETECTED
-155 NUMBER OF COLUMNS IN VIEW NOT EQUAL TO NUMBER IN QUERY
-156 VIEW xxx WITH CHECK OPTION VIOLATION
-157 TTM INIT. FAILED. SQL CODE xxx, DB RC yy(zzz).
-158 CANNOT CREATE SYNONYM FOR INVALID VIEW aaaa
-159 HOST VARIABLE INCOMPATIBLE WITH COLUMN AT POSITION aaaa
-161 colname datatype(prec,scale) INVALID DATA hh
-162 CANNOT INSERT AND SELECT ON THE SAME TABLE
-163 MORE THAN 1 DEFAULT SPECIFIED FOR A COLUMN
-164 CHARACTER DEFAULT MORE THAN 20 BYTES
-165

DUPLICATE CONSTRAINT NAME nnnnnnnn mmmmmmmm

-166 TBL authid.tblname CHECK PENDING
-167 DOMAIN CONSTRAINT nnnnnnnn.mmmmmmmm VIOLATION
-168 THE TABLE ALREADY HAS A PRIMARY KEY, ONLY ONE MAY BE DEFINED
-169 THE REFERENCED COLUMNS DID NOT REFER TO A CANDIDATE KEY
-170 CONSTRAINT(S) DID NOT CONFIRM - TABLE PLACED IN CHECK STATUS
-171 THE REFERENCED TABLE DOES NOT CONTAIN A PRIMARY KEY
-172 THE NUMBER OF REFERENCING AND REFERENCED COLUMNS DOES NOT MATCH
-173 THE REFERENCING AND REFERENCED COLUMNS ARE NOT EQUIVALENT
-174 UPDATE/DELETE CANNOT HAVE CORRELATED SUBQRY
-175 FOREIGN KEY <authid.constraintname> REFERENCE VIOLATION
-176 FOREIGN KEY <authid.constraintname> VALUE VIOLATION
-177 PRIMARY/UNIQUE CONSTRAINT CANNOT BE DROPPED DUE TO REFERENCE
-178 WITH CHECK OPTION CANNOT BE DROPPED FROM A VIEW DEFINITION
-179 CONSTRAINT mmmmm nnnnn NOT FOUND
-180 ROW HELD BY PREVIOUS LOGICAL UNIT OF WORK WAS DELETED
-181 ROW HELD BY PREVIOUS LOGICAL UNIT OF WORK WAS UPDATED
-182 UNIQUE/PRIMARY CANNOT BE SPECIFIED DUE TO NULL ON nnnnnn
-183 MUST SPECIFY DATACOM SQLMODE FOR CURSORS TO SURVIVE UNITS OF WORK
-184 COLUMN NAME LIST REQUIRED ON CREATE VIEW CONTAINING NON-SIMPLE COLUMN
-185 accessor-id HAS NO action-type AUTHORITY ON object
-188 DROP NOT ALLOWED DUE TO FOREIGN REFERENCES
-189 NO RESULT FORMAT SPECIFIED
-190 OPERAND 1 OR RESULT FORMAT MUST BE INTERNAL TO DO CONVERSION
-191 BOTH OPERANDS MUST BE IN INTERNAL FORMAT
-192 RESULT FORMAT MUST BE INTERNAL TO DO VERIFICATION
-193 CENTURY nn IS LARGER THAN 99
-194 IT IS INVALID TO ADD xx AND zz DATATYPES
-195 IT IS INVALID TO SUBTRACT xx AND zz DATATYPES
-198 YEAR yy IS LARGER THAN 99
-199 MONTH mm IS NOT BETWEEN 1 AND 12 INCLUSIVE
-200 DAY dd OUT OF RANGE FOR MONTH mm, YEAR yy
-201 HOUR hh OUT OF RANGE
-202 MINUTE mm OUT OF RANGE
-203 SECOND ss OUT OF RANGE
-204 MICROSECOND ssssss GREATER THAN 99
-205 INVALID DATATYPE xx FOR SCALAR FUNCTION nn
-206 OP2 NOT ALLOWED IF OP1 IS A TIMESTAMP FOR SCALAR FUNCTION CHAR
-207 RESULT DATATYPES IN CASE/COALESCE/NULLIF EXPRESSION ARE INCOMPATIBLE
-208 CASE EXPRESSION MUST CONTAIN AT LEAST ONE NON-NULL RESULT EXPRESSION
-209 operation DISALLOWED ON object
-210 ROLLBACK INCOMPATIBLE WITH USE OF RESOURCE RECOVERY SERVICES
-214 ARRAY INDEX MUST BE A LITERAL IN THIS CONTEXT
-215 <column-name> INDEX index-value MUST BE BETWEEN lower-limit AND upper-limit INCLUSIVE
-216 BAD ARRAY VALUE reason
-217 disallowed-language-element NOT ALLOWED disallowed-context
-218 CANNOT DETERMINE JULIAN DATE WITH MONTH = mm
-219 JULIAN DATE HAS GONE NEGATIVE dddd
-223 A TIME STRING CANNOT CONTAIN MORE THAN ONE A aa
-224 A TIME STRING CANNOT CONTAIN MORE THAN ONE P pp
-225 A TIME STRING CANNOT CONTAIN MORE THAN ONE BLANK BEFORE THE A OR P
-226 NO M AFTER THE A OR P OR TOO MANY COLONS IN A TIME STRING
-227 THERE MUST BE AN M AFTER THE A OR P IN A TIME STRING
-228 TOO MANY NODES IN CHARACTER STRING node count is n
-229 TOO MANY DIGITS PER NODE IN STRING xxxx
-230 THE VALUE OF A NODE IS OUT OF RANGE xxxx
-231 NUMBER OF SLASHES IS n, ONLY TWO ALLOWED xxxx
-232 NO AM OR PM FOUND IN TIME CHARACTER STRING WITH ONE COLON xxxx
-233 NUMBER OF COLONS MUST BE 1 OR 2. FOUND n
-234 FOUND AN M BUT NO A OR P TO GO WITH IT xxxx
-235 NUMBER OF PERIODS CAN ONLY BE 2. FOUND n
-236 NUMBER OF DASHES CAN ONLY BE 3. FOUND n
-237 NUMBER OF DIGITS FOR MICROSECONDS CANNOT EXCEED 6, FOUND n xxxx
-238 UNRECOGNIZABLE DATE/TIME FORMAT xxxx
-241 SQL REFERENTIAL INTEGRITY IS NOT ALLOWED ON A DL1/T TABLE
-242 CONFLICT ALTERING COLUMN xxx
243 EXTENSION TO ANSI SQL-86 (SQLMODE-ANSI/FIPS)
-243 ANSI EXTENSION
-244 NOT ALLOWED WITH SQLMODE=ANSI/FIPS
-245 CONFLICTING SECURITY MODES
-246 INVALID AREA NAME aaaa
-247 accessor-id HAS NO CREATE SCHEMA AUTHORITY
-248 accessor-id HAS NO AUTHORITY TO USE "GRANTED BY" FORM OF REVOKE
-249 REFERENCED TABLE aaa.ttt PLUS n OTHERS IN CHECK STATUS
-250 EXCEPTION TABLE authid.tblname NOT FOUND
-251 TABLE HAS NO CONSTRAINTS
-252 TABLE NOT IN A CHECK STATE
-254 REVOKE WOULD CASCADE BUT "CASCADE" NOT SPECIFIED
-255 COLUMN xxx NOT NULL WITHOUT DEFAULT
-256 RQA TOO LARGE FOR TABLE ttt
-257 FOREIGN KEY COLUMN xxx NOT FOUND
-258 TABLE FULL - DBID=nnnn INTERNAL NAME aaa
-259 INDEX FULL - DBID=nnnn
-260 UNIQUE CONSTRAINT constraint-name DUPLICATES KEY key-name
-261 UNIQUE constraint-name COLUMN column-name NOT FOUND
-262 REFERENCING TABLE xxx.xxx IN CHECK-RELATED STATE
-263 DUPLICATE KEY <keyname> VALUE REJECTED DBID <dbid> TBL <tbl>
-264 INDEX ALREADY EXISTS xxx
-265 INDEX DOES NOT EXIST aaaa.bbbb
-269 FOREIGN KEY LOOP
-272 ERROR DURING AUTOMATIC REBINDING OF VIEW authid.viewname
-273 GRANT AND REVOKE STATEMENTS NOT ALLOWED
-274 CANNOT CREATE AN INDEX ON A VIEW
-275 SQLDA SPECIFIES n MORE HOST VARIABLES THAN IN STATEMENT
-276 SQLDA SPECIFIES n FEWER HOST VARIABLES THAN IN STATEMENT
-277 aaaa RECEIVED UNKNOWN DURATION TYPE
-278 INVALID PREC(xxx) OR SCALE(zzz) FOR DECIMAL DATATYPE
-279 INVALID DATE TABLE INDEX (xxx)
-280 INVALID TIME TABLE INDEX (xxx)
-281 INVALID TIMESTAMP TABLE INDEX (xxx)
-282 NO OPERAND NODE RECEIVED
-283 NO OPERAND VALUE RECEIVED
-284 NON-NUMERIC ITEM FOUND <x> IN STRING <aaaa>
-286 SUBSTR FUNCTION ARGUMENTS <START=aaaa, LENGTH=bbbb> ARE OUT OF RANGE
-287 DL1/T CONSTRAINT ENFORCEMENT MODULE DLSERV NOT FOUND
-289 <x> LITERAL <y> TOO LARGE/SMALL
-290 DATATYPE OF FIRST OPERAND OF LIKE NOT CHARACTER STRING
-291 INDEX <xxxxx> NOT IN SEQUENCE
-292 <nnnn> VARIABLES PROVIDED FOR <nnnn> SELECT LIST COLUMNS
-293 PREDICATE INVALID BECAUSE HOST VARIABLE <nnn> HAS THE NULL VALUE
-294 INVALID MIXED DATA IN VALUE ASSIGNED TO column_name
-296 INVALID MIXED DATA IN COLUMN column_name
-297 INVALID MIXED DATA IN LIKE PATTERN
-298 INVALID MIXED DATA IN VARGRAPHIC OPERAND
-299 LIKE ESCAPE OPTION NOT ALLOWED WITH MIXED DATA
-300 CANNOT EXECUTE UNPREPARED/INVALID STATEMENT statement_name
-301 PREPARE OF SELECT REJECTED - CURSOR cursor_name IN OPEN STATE
-302 INVALID USE OF PARAMETER MARKER
-303 STATEMENT-NAME OF CURSOR cursor_name NOT PREPARED SELECT STATEMENT
-304 CANNOT DESCRIBE UNPREPARED STATEMENT statement_name
-305 SQLDA HAS count HOST VARIABLES - STATEMENT HAS count PARAMETER MARKERS
-306 STATEMENT TYPE CANNOT BE PREPARED
-307 STATEMENT-NAME statement_name CAN ONLY BE USED WITH ONE CURSOR
-308 PREPARE HOST VARIABLE SOURCE STATEMENT LENGTH INVALID
-309 HOST VARIABLES CANNOT BE USED IN DYNAMICALLY PREPARED STATEMENTS
-310 COMBINATION OF CHECKPLAN=checkplan_value, CHECKWHO=checkwho_value, AND CHECKWHEN=checkwhen_value IS INVALID
-311 EMBEDDED UPDATE OR DELETE REFERENCES DYNAMIC CURSOR
-312 NO SQLDA FOR EXECUTE OF A STATEMENT WITH PARAMETER MARKERS
-313 NO SUCH PRIVILEGE IS grantable or revokable ON object_name
-314 EXTERNALLY SECURED PLANS REQUIRE AUTHID.PLAN-NAME < 26 BYTES
-315 ONLY THE PLAN CREATOR MAY MODIFY PLAN SECURITY OPTIONS DURING REBIND
-316 %s.%s OUTSIDE SCOPE OF JOINED TABLE
-317 CURSOR cursor-name ERROR MULTIPLE stmt-type STATEMENTS ATTEMPTED
-317 (alternate version) - CURSOR REQUIRED ERROR CURSOR REQUIRED FOR NON-DYNAMIC SELECT
-318 URI=YES IS REQUIRED FOR SQL TO USE TABLE (DATACOM-NAME) ttt DBID nnnn
-319 LUW IS TIMING OUT - TRY AGAIN (LUWID=luw-id-string, TASK=task-nbr, JOB=job-name)
-320 message describing user error
-321 INVALID SQLCODE sqlcode HAS BEEN GENERATED
-322 INVALID SQLSTATE
-323 LUW_STATEMENT_LIMIT OF x STATEMENTS EXCEEDED - TRY A COMMIT
-324 BAD NUMERIC LITERAL n (NON-DIGIT/SPACE EMBEDDED)
-326 MAXIMUM NUMBER (number) OF DIAGNOSTICS AREAS EXCEEDED
-327 INCREASE MUF TASKS SIZE TO AT LEAST nnnnn
-435 USER CONDITION user-cond-name SIGNALLED WITH NO ATTACHED ERROR MESSAGE
-436 RESIGNAL FOR SQLSTATE sqlstate REQUESTED WHEN HANDLER NOT ACTIVE
-437 NO HANDLER EXISTS FOR USER-DEFINED CONDITION NAME name-string
-438 SQLSTATE sqlstate-value WAS SIGNALLED WITH NO ATTACHED ERROR MESSAGE
-439 sqlstate-value IN handler-name error-description
-441 PROC msg-text
-501 INVALID CURSOR STATE (STMT - ID=aaaa)
-502 CURSOR ALREADY OPEN
-504 PLAN OPTION ERROR error-string
-505 ON-CLAUSE ERROR x NOT ALLOWED
-530 PROC authid.name msg-string
-531 PROC authid.name msg-string
-532 TRIG authid.name msg-string
-533 TRIG authid.name msg-string
-534 msg-string
-535 PROC authid.name msg-string
-537 msg-string
-559 SECURITY FACILITY NOT ENABLED
-560 TEMPORARY TABLE AREA (TTM) FULL
-561 TTM TOO SMALL, SEE ERROR ACTION
-562 INVALID DATACOM NAME
-563 INVALID ORDER <aaa>---USE 'ASC' OR 'DESC'
-564 ONLY ONE PRIMARY KEY MAY BE DEFINED
-565 HEX LITERALS MUST HAVE EVEN NUMBER OF HEX DIGITS xxx
-566 INVALID HEX DIGIT IN HEX LITERAL <xxxx>--USE 0-9, A-F
-568 INVALID EXPRESSION FOR GROUP BY CLAUSE
-569 NO WEB CONNECT SEAT AVAILABLE
-570 NOT ALLOWED WITH WEB CONNECT
-571 SOURCE CACHE ERROR msg-string
-572 COMMAND: xxxx
-573 NTE x SELECT COLUMNS n, CORRELATION NAMES m
-574 NTE x CORRELATION NAME y NOT UNIQUE
-575 columnName NOT VALID IN THIS CONTEXT
-576 CANNOT USE VIEW AND NESTED TABLE EXPRESSION IN SAME QUERY
-577 TABLE IN REFERENCED CURSOR IS DIFFERENT
-985 through -998 SQLnnnn xxxx .
-999 INTERNAL ERROR (file-name LINE line-number) specific-error
Was this helpful?

Please log in to post comments.

  1. WILLIAMS
    2018-10-13 05:33

    Clicking on "EXTENSION TO ANSI SQL-86 (SQLMODE-ANSI/FIPS)" results in "page not found"

  2. WILLIAMS
    2018-10-13 05:34

    ...in fact many of the links on this page are broken - "Page not found" errors all over the place.

  3. JOANNA KRUEGER
    2018-10-18 04:43

    Thank you Owen for finding this. The links used to work and we are still trying to resolve the problem. 

  4. JOANNA KRUEGER
    2018-10-23 04:48

    Finally! All the links should be working again!