Updated SQL code explanations

These topics have had technical changes to the explanation of the SQL code in the Db2 12 for z/OS® documentation.

-060
INVALID specification-type SPECIFICATION : specification-value
-101
THE STATEMENT IS TOO LONG OR TOO COMPLEX
-109
clause-type CLAUSE IS NOT PERMITTED
-111
AN AGGREGATE FUNCTION DOES NOT INCLUDE A COLUMN NAME
-119
A COLUMN OR EXPRESSION IN A HAVING CLAUSE IS NOT VALID
-120
AN AGGREGATE FUNCTION OR OLAP SPECIFICATION IS NOT VALID IN THE CONTEXT IN WHICH IT WAS INVOKED
-121
THE TARGET name IS IDENTIFIED MORE THAN ONCE FOR ASSIGNMENT IN THE SAME SQL STATEMENT
-148
THE SOURCE TABLE OR TABLESPACE source-name CANNOT BE ALTERED, REASON reason-code
-159
THE STATEMENT REFERENCES object-name WHICH IDENTIFIES AN actual-type RATHER THAN AN expected-type
-164
authorization-id DOES NOT HAVE THE PRIVILEGE TO CREATE A VIEW WITH QUALIFICATION qualifier-name
-171
THE DATA TYPE, LENGTH, OR VALUE OF ARGUMENT argument-position OF function-name IS INVALID
-204
name IS AN UNDEFINED NAME
-206
object-name IS NOT VALID IN THE CONTEXT WHERE IT IS USED
-243
SENSITIVE CURSOR cursor-name CANNOT BE DEFINED FOR THE SPECIFIED SELECT STATEMENT
-246
STATEMENT USING CURSOR cursor-name SPECIFIED NUMBER OF ROWS num-rows WHICH IS NOT VALID WITH dimension
-270
FUNCTION NOT SUPPORTED
-312
VARIABLE variable-name IS NOT DEFINED OR NOT USABLE
-327
THE ROW CANNOT BE INSERTED BECAUSE IT IS OUTSIDE THE BOUND OF THE PARTITION RANGE FOR THE LAST PARTITION
-338
AN ON CLAUSE IS INVALID
-345
THE FULLSELECT OF THE RECURSIVE COMMON TABLE EXPRESSION name MUST BE A UNION ALL AND MUST NOT INCLUDE AGGREGATE FUNCTIONS, GROUP BY, HAVING, ORDER BY, OFFSET, FETCH FIRST, OR AN EXPLICIT JOIN INCLUDING AN ON CLAUSE
-350
column-name WAS IMPLICITLY OR EXPLICITLY REFERENCED IN A CONTEXT IN WHICH IT CANNOT BE USED
-356
COLUMN OR KEY EXPRESSION expression-number IS NOT VALID, REASON CODE = reason-code
-365
USE OF THE VALUE OF EXTENDED INDICATOR VARIABLE IN POSITION value-position IS NOT VALID.
-372
ONLY ONE ROWID, IDENTITY, ROW CHANGE TIMESTAMP, ROW BEGIN, ROW END, TRANSACTION START ID, SECURITY LABEL, OR DATA CHANGE OPERATION COLUMN IS ALLOWED IN A TABLE
-390
OBJECT object-name, SPECIFIC NAME specific-name, IS NOT VALID IN THE CONTEXT WHERE IT IS USED
-440
NO AUTHORIZED routine-type BY THE NAME routine-name HAVING COMPATIBLE ARGUMENTS WAS FOUND
-455
IN CREATE FOR routine-name, THE SCHEMA NAME schema-name1 PROVIDED FOR THE SPECIFIC NAME DOES NOT MATCH THE SCHEMA NAME schema-name2 OF THE ROUTINE
-461
A VALUE WITH DATA TYPE source-data-type CANNOT BE CAST TO TYPE target-data-type
-469
SQL CALL STATEMENT MUST SPECIFY AN OUTPUT VARIABLE FOR PARAMETER number
-476
REFERENCE TO ROUTINE routine-name WAS IDENTIFIED WITHOUT A SIGNATURE, OR BY BOTH SIGNATURE AND SPECIFIC NAME, BUT THE ROUTINE IS NOT UNIQUE WITHIN ITS SCHEMA
-512
STATEMENT REFERENCE TO REMOTE OBJECT IS INVALID
-513
INVALID USE OF alias-name
-518
THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED STATEMENT
-526
THE REQUESTED OPERATION OR USAGE DOES NOT APPLY TO table-type TEMPORARY TABLE table-name
-530
THE INSERT OR UPDATE VALUE OF FOREIGN KEY constraint-name IS INVALID
-538
FOREIGN KEY name DOES NOT CONFORM TO THE DESCRIPTION OF A PARENT KEY OF TABLE table-name
-540
THE DEFINITION OF TABLE table-name IS INCOMPLETE BECAUSE IT LACKS A PRIMARY INDEX OR A REQUIRED UNIQUE INDEX
-551
auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation ON OBJECT object-name
-552
authorization-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation
-581
THE DATA TYPES OF THE RESULT-EXPRESSIONS OF A CASE EXPRESSION ARE NOT COMPATIBLE
-582
THE SEARCH-CONDITION IN A SEARCHED-WHEN-CLAUSE OF A CASE IS NOT VALID IN THE CONTEXT IN WHICH IT WAS SPECIFIED. THE SEARCH CONDITION CONTAINS A QUANTIFIED PREDICATE OR AN IN PREDICATE THAT INCLUDES A FULLSELECT, AND THESE ARE NOT ALLOWED IN THE SPECIFIED CONTEXT.
-584
INVALID USE OF NULL OR DEFAULT
-590
NAME name IS NOT UNIQUE IN THE CREATE OR ALTER FOR ROUTINE OR TRIGGER object-name
-592
NOT AUTHORIZED TO CREATE OR ALTER FUNCTIONS, PROCEDURES, OR TRIGGERS IN WLM ENVIRONMENT env-name
-601
THE NAME (VERSION OR VOLUME SERIAL NUMBER) OF THE OBJECT TO BE DEFINED OR THE TARGET OF A RENAME STATEMENT IS IDENTICAL TO THE EXISTING NAME (VERSION OR VOLUME SERIAL NUMBER) object-name OF THE OBJECT TYPE object-type
-607
OPERATION OR OPTION operation IS NOT DEFINED FOR THIS OBJECT
-613
THE PRIMARY KEY OR A HASH KEY OR A UNIQUE CONSTRAINT IS TOO LONG OR HAS TOO MANY COLUMNS AND PERIODS
-614
THE INDEX CANNOT BE CREATED OR ALTERED, OR THE LENGTH OF A COLUMN CANNOT BE CHANGED BECAUSE THE SUM OF THE INTERNAL LENGTHS OF THE COLUMNS FOR THE INDEX IS GREATER THAN THE ALLOWABLE MAXIMUM
-615
operation-type IS NOT ALLOWED ON A PACKAGE IN USE
-627
THE ALTER STATEMENT IS INVALID BECAUSE THE TABLE SPACE OR INDEX HAS USER-MANAGED DATA SETS
-628
THE CLAUSES ARE MUTUALLY EXCLUSIVE
-633
THE DELETE RULE MUST BE delete-rule
-636
RANGES SPECIFIED FOR PARTITION part-num ARE NOT VALID
-646
TABLE table-name CANNOT BE CREATED IN OR MOVED TO SPECIFIED TABLE SPACE table-space-name BECAUSE IT ALREADY CONTAINS A TABLE
-650
THE ALTER STATEMENT CANNOT BE EXECUTED, REASON reason-code
-669
THE OBJECT CANNOT BE EXPLICITLY DROPPED. REASON reason-code
-670
THE RECORD LENGTH OF THE TABLE EXCEEDS THE PAGE SIZE LIMIT
-736
INVALID OBID obid SPECIFIED
-740
FUNCTION name IS DEFINED WITH THE OPTION MODIFIES SQL DATA WHICH IS NOT VALID IN THE CONTEXT IN WHICH IT WAS INVOKED
-763
INVALID TABLE SPACE NAME space-name
-766
THE OBJECT OF A STATEMENT IS A TABLE FOR WHICH THE REQUESTED OPERATION IS NOT PERMITTED
-771
INVALID SPECIFICATION OF A ROWID COLUMN
-797
THE TRIGGER trigger-name IS DEFINED WITH AN UNSUPPORTED TRIGGERED SQL STATEMENT
-802
EXCEPTION ERROR exception-type HAS OCCURRED DURING operation-type OPERATION ON data-type DATA, POSITION position-number
-804
AN ERROR WAS FOUND IN THE APPLICATION PROGRAM INPUT PARAMETERS FOR THE SQL STATEMENT, REASON reason
-805
PACKAGE NAME location-name.collection-id.dbrm-name.consistency-token NOT FOUND IN PLAN plan-name. REASON reason-code
-846
INVALID SPECIFICATION OF AN IDENTITY COLUMN OR SEQUENCE OBJECT object-type object-name. REASON CODE = reason-code
-873
THE STATEMENT REFERENCED DATA ENCODED WITH DIFFERENT ENCODING SCHEMES OR CCSIDS IN AN INVALID CONTEXT
-874
THE ENCODING SCHEME SPECIFIED FOR THE object-type MUST BE THE SAME AS THE CONTAINING OR TARGET TABLE SPACE OR OTHER PARAMETERS
-904
UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name
-909
THE OBJECT HAS BEEN DELETED OR ALTERED
-910
THE SQL STATEMENT CANNOT ACCESS AN OBJECT ON WHICH UNCOMMITTED CHANGES ARE PENDING
-4700
ATTEMPT TO USE NEW FUNCTION BEFORE FUNCTION LEVEL IS ACTIVATED
-4701
TABLE SPACE PARTITIONS EXCEED SYSTEM LIMIT (system-limit) REASON reason-code
-4705
option SPECIFIED ON ALTER STATEMENT FOR object-name (object-type) IS NOT VALID
-4706
THE STATEMENT FOR AN SQL ROUTINE OR ADVANCED TRIGGER CANNOT BE PROCESSED BECAUSE THE OPTIONS CURRENTLY IN EFFECT (ENVID current-envid) ARE NOT THE SAME AS THOSE THAT WERE IN EFFECT (ENVID defined-envid) WHEN THE OBJECT OR VERSION WAS FIRST DEFINED
-4728
ANOTHER VERSION OF OBJECT object-name EXISTS AND IS DEFINED WITH AN INCOMPATIBLE OPTION. THE OPTION IS option-name.
-4732
THE MAXIMUM NUMBER OF ALTERS ALLOWED HAS BEEN EXCEEDED FOR object-type
-4742
THE STATEMENT CANNOT BE EXECUTED BY DB2 OR IN THE ACCELERATOR (REASON reason-code)
-4743
ATTEMPT TO USE NEW FUNCTION WHEN THE APPLICATION COMPATIBILITY SETTING IS SET FOR A PREVIOUS LEVEL
-4747
THE CREATE OR ALTER TABLE STATEMENT FAILED BECAUSE SOME FUNCTIONALITY WAS SPECIFIED IN THE TABLE DEFINITION THAT IS NOT SUPPORTED WITH THE TABLE TYPE. UNSUPPORTED FUNCTIONALITY:functionality-keyword.
-7008
object-name NOT VALID FOR OPERATION (reason-code)
-16068
THE REGULAR EXPRESSION ARGUMENT VALUE PASSED TO THE FUNCTION function-name IS NOT VALID. ERROR QNAME= err:FORX0002
-16080
AN XQUERY expression-type UPDATING EXPRESSION IS USED IN AN INVALID CONTEXT. ERROR QNAME=err:XUST0001.
-20008
ATTEMPT TO USE UNSUPPORTED FEATURE msg-token. REASON CODE: reason-code
-20038
THE STATEMENT COULD NOT BE PROCESSED BECAUSE THE STATEMENT CONTAINS THE FOLLOWING INCOMPATIBLE CLAUSES OR ELEMENTS: keywords1 AND keywords2.
-20058
THE FULLSELECT SPECIFIED FOR MATERIALIZED QUERY TABLE table-name IS NOT VALID.
-20071
WLM ENVIRONMENT NAME MUST BE SPECIFIED function-name
-20072
csect-name bind-type bind-subtype ERROR USING authorization-id AUTHORITY. OPERATION IS NOT ALLOWED ON A package-type PACKAGE package-name
-20100
AN ERROR OCCURRED WHEN BINDING A TRIGGERED SQL STATEMENT. INFORMATION RETURNED: SECTION NUMBER : section-number SQLCODE sqlerror, SQLSTATE sqlstate, AND MESSAGE TOKENS token-list
-20106
THE CCSID FOR THE TABLE SPACE OR DATABASE CANNOT BE CHANGED BECAUSE THE TABLE SPACE OR DATABASE ALREADY CONTAINS A TABLE THAT IS REFERENCED IN EXISTING VIEW, OR MATERIALIZED QUERY TABLE DEFINITIONS OR AN EXTENDED INDEX
-20181
COLUMN CANNOT BE ADDED TO INDEX index-name
-20183
THE PARTITIONED, ADD PARTITION, ADD PARTITIONING KEY, ALTER PARTITION, ROTATE PARTITION, OR PARTITION BY RANGE CLAUSE SPECIFIED ON CREATE OR ALTER FOR table-name IS NOT VALID
-20186
A CLAUSE SPECIFIED FOR THE DYNAMIC SQL STATEMENT BEING PROCESSED IS NOT VALID
-20211
THE SPECIFICATION ORDER BY, OFFSET, OR FETCH FIRST N ROWS ONLY IS INVALID
-20223
THE OPERATION FAILED. ENCRYPTION FACILITY NOT AVAILABLE return-code, reason-code
-20248
ATTEMPTED TO EXPLAIN STATEMENT WITH STMTID OR STMTTOKEN ID-token BUT THE REQUIRED EXPLAIN INFORMATION IS NOT ACCESSIBLE. REASON reason-code
-20267
THE FUNCTION function-name (SPECIFIC specific-name) MODIFIES SQL DATA AND IS INVOKED IN AN ILLEGAL CONTEXT. REASON CODE reason-code
-20276
The XML namespace prefix xml-namespace-prefix is not valid. Reason code = reason-code
-20279
THE VIEW view-name CANNOT BE ENABLED FOR QUERY OPTIMIZATION. REASON CODE = reason-code
-20313
DEBUG MODE OPTION FOR OBJECT object-name CANNOT BE CHANGED
-20315
THE CURRENTLY ACTIVE VERSION FOR OBJECT object-name (object-type) CANNOT BE DROPPED
-20354
INVALID SPECIFICATION OF A ROW CHANGE TIMESTAMP COLUMN FOR TABLE table-name
-20385
THE STATEMENT CANNOT BE PROCESSED BECAUSE THERE ARE PENDING DEFINITION CHANGES FOR OBJECT object-name OF TYPE object- type (REASON reason-code)
-20435
THE SELECT CLAUSE INCLUDES MULTIPLE INVOCATIONS OF THE ARRAY_AGG FUNCTION. ALL INVOCATIONS THAT EXPLICITLY SPECIFY AN ORDER BY CLAUSE MUST SPECIFY THE SAME ORDER.
-20439
AN ARRAY INDEX VALUE, value, IS NULL OR OUT OF RANGE, OR AN ARRAY ELEMENT WITH THAT INDEX VALUE DOES NOT EXIST.
-20441
type-name TYPE IS NOT VALID WHERE SPECIFIED. REASON CODE reason-code.
-20469
ROW OR COLUMN ACCESS CONTROL CANNOT BE ACTIVATED FOR TABLE table-name FOR REASON reason-code. object-type object-name IS NOT IN A VALID STATE FOR ACTIVATING ACCESS CONTROL FOR THIS TABLE
-20474
PERMISSION OR MASK CANNOT BE CREATED FOR THE object-name OBJECT OF THE object-type TYPE. REASON CODE reason-code.
-20522
INVALID SPECIFICATION OF WITHOUT OVERLAPS OR PERIOD CLAUSE. REASON CODE reason-code.
-20555
AN ARCHIVE-ENABLED TABLE IS NOT ALLOWED IN THE SPECIFIED CONTEXT. REASON CODE reason-code.
-30025
EXECUTION FAILED BECAUSE FUNCTION IS NOT SUPPORTED BY THE SERVER WHICH CAUSED TERMINATION OF THE CONNECTION: LOCATION location PRODUCT ID identifier REASON reason-code (sub-code)
-30047
STATEMENT FAILED BECAUSE OBJECT OF TYPE resource-type-code CANNOT BE ACCESSED USING DIFFERENT DISTRIBUTED PROTOCOLS ON A CONNECTION FROM server-name-1 TO server-name-2
-30090
REMOTE OPERATION INVALID FOR APPLICATION EXECUTION ENVIRONMENT
+395
A USER SPECIFIED OPTIMIZATION HINT IS INVALID (REASON CODE = reason-code)
+610
A CREATE/ALTER ON OBJECT object-name HAS PLACED OBJECT IN utility-name PENDING
+799
THE STATEMENT set-stmt REFERENCES A SPECIAL REGISTER OR BUILT_IN GLOBAL VARIABLE THAT DOES NOT EXIST AT THE SERVER SITE
+904
A RESOURCE IS UNAVAILABLE BUT PROCESSING CONTINUES. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name
+4754
THE ACCELERATOR accelerator-name DOES NOT EXIST.
+20271
THE NAME AT ORDINAL POSITION position-number IN THE STATEMENT, WITH NAME object-name, WAS TRUNCATED.
+20278
THE VIEW view-name MAY NOT BE USED TO OPTIMIZE THE PROCESSING OF QUERIES
+20368
TRUSTED CONTEXT context-name IS NO LONGER DEFINED TO BE USED BY SPECIFIC VALUES FOR ATTRIBUTE attribute-name.
+20520
ATTEMPT TO USE A DEPRECATED FEATURE msg-token. REASON CODE reason-code

Parent topic: New, changed, and deleted codes