Transcription
MAINFRAMEA one-stopReference DocumentbyRamkumar. SMainframe – Abend Codes and DetailsPage 17/30/2008
CONTENTS: SQL CODES COBOL / VSAM FILE-STATUS CODES IMS ERROR CODES PL/1 ONCODES SYSTEM ABEND CODES MORE DETAILS on SYSTEM ABEND CODES MORE DETAILS on USER ABEND CODESMainframe – Abend Codes and DetailsPage 27/30/2008
SQL CODESSuccessful Execution SQLCODE:000SUCCESSFUL EXECUTIONWarning SQLCODES: 100ROW NOT FOUND FOR FETCH, UPDATE OR DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE 162TABLE SPACE 304A VALUE WITH DATA TYPE data-type1 CANNOT BE ASSIGNED TO A HOST VARIABLE BECAUSE THE VALUE IS NOT WITHIN THERANGE OF THE HOST VARIABLE IN POSITIONposition-number WITH DATA TYPE data-type2 402LOCATION location IS UNKNOWN 403THE LOCAL OBJECT REFERENCED BY THE CREATE ALIAS STATEMENT DOES NOT EXIST 558THE WITH GRANT OPTION IS IGNORED BECAUSE GRANT IS TO PUBLIC 560THE WITH GRANT OPTION IS IGNORED FOR UPDATE (COLUMN-LIST) 561THE ALTER AND INDEX PRIVILEGES CANNOT BE GRANTED TO “PUBLIC AT ALL LOCATIONS” 625THE DEFINITION OF TABLE table-name HAS BEEN CHANGED TO INCOMPLETE 802EXCEPTION ERROR exception-type HAS OCCURRED DURING operation-type OPERATION ON data-type DATA, POSITION positionnumber.database-name, tablespace-name HAS BEEN PLACED IN CHECK PENDINGError SQLCODES:-007STATEMENT CONTAINS THE ILLEGAL CHARACTER character-010THE STRING CONSTANT BEGINNING string IS NOT TERMINATED-060INVALID type SPECIFICATION: spec-084UNACCEPTABLE SQL STATEMENT-101THE STATEMENT IS TOO LONG OR TOO COMPLEX-102THE LENGTH OF THE STRING CONSTANT BEGINNING string IS GREATER THAN 254 CHARACTERS OR 124GRAPHIC CHARACTERS-103literal IS AN INVALID NUMERIC LITERAL-104ILLEGAL SYMBOL token VALID SYMBOLS ARE token-list-105INVALID STRING-107THE NAME name IS TOO LONG. MAXIMUM ALLOWABLE SIZE IS size-109clause CLAUSE IS NOT PERMITTED-110INVALID HEXADECIMAL LITERAL BEGINNING string-111A COLUMN FUNCTION DOES NOT INCLUDE A COLUMN NAME-112THE OPERAND OF A COLUMN FUNCTION IS ANOTHER COLUMN FUNCTION OR DISTINCT FOLLOWED BY AN EXPRESSION-113INVALID CHARACTER FOUND IN NAME: name-115A PREDICATE IS INVALID BECAUSE THE COMPARISON OPERATOR operator IS FOLLOWED BY A PARENTHESIZED LIST OR BY ANYOR ALL WITHOUT A SUBQUERY-117THE NUMBER OF INSERT VALUES IS NOT THE SAME AS THE NEMBER OF OBJECT COLUMNS-118THE OBJECT TABLE OR VIEW OF THE INSERT, DELETE, OR UPDATE STATEMENT IS ALSO INDENTIFIED IN A FROM CLAUSE-119A COLUMN IDENTIFIED IN A HAVING CLAUSE IS NOT INCLUDED IN THE GROUP BY CLAUSE-120A WHERE CLAUSE OR SET CLAUSE INCLUDES A COLUMN FUNCTION OR A WHERE CLAUSE REFERENCES A COLUMN [columnname] WHICH IS DERIVED FROM A COLUMN FUNCTION OR EXPRESSION IN A VIEW DEFINITION-121THE COLUMN name IS IDENTIFIED MORE THAN ONCE IN THE INSERT OR UPDATE STATEMENT-122A SELECT STATEMENT WITH NO GROUP BY CLAUSE CONTAINS A COLUMN NAME AND A COLUMN FUNCTION IN THE SELECTCLAUSE OR A COLUMN NAME IS CONTAINED IN THE SELECT CLAUSE BUT NOT IN THE GROUP BY CLAUSE-125AN INTEGER IN THE ORDER BY CLAUSE DOES NOT IDENTIFY A COLUMN OF THE RESULT-126THE SELECT STATEMENT CONTAINS BOTH AN UPDATE CLAUSE AND AN ORDER BY CLAUSEMainframe – Abend Codes and DetailsPage 37/30/2008
-127DISTINCT IS SPECIFIED MORE THAN ONCE IN A SUBSELECT-128INVALID USE OF NULL IN A PREDICATE-129THE STATEMENT CONTAINS TOO MANY TABLE NAMES-131STATEMENT WITH LIKE PREDICATE HAS INCOMPATIBLE DATA TYPES-132A LIKE PREDICATE IS INVALID BECAUSE THE FIRST OPERAND IS NOT A COLUMN OR THE SECOND OPERAND IS NOT A STRING-133A COLUMN FUNCTION IN A SUBQUERY OF A HAVING CLAUSE IS INVALID BECAUSE IT INCLUDES AN EXPRESSION THAT APPLIESAN OPERATIOR TO A CORRELATED REFERENCE-134IMPROPER USE OF LONG STRING COLUMN column-name OR A HOST VARIABLE OF MAXIMUM LENGTH GREATER THAN 254-136SORT CANNOT BE EXECUTED BECAUSE THE SORT KEY LENGTH IS GREATER THAN 4000 BYTES-137RESULT OF CONCATENATION TOO LONG-138THE SECOND OR THIRD ARGUMENT OF THE SUBSTR FUNCTION IS OUT OF RANGE-150THE OBJECT OF THE INSERT, DELETE, OR UPDATE STATEMENT IS A VIEW FOR WHICH THE REQUESTED OPERATION IS NOTPERMITTED-151THE UPDATE STATEMENT IS INVALID BECAUSE THE CATALOG DESCRIPTION OF COLUMN column-name INDICATES THAT ITCANNOT BE UPDATED-153THE CREATE VIEW STATEMENT DOES NOT INCLUDE A REQUIRED COLUMN LIST-154THE CREATE VIEW FAILED BECAUSE THE VIEW DEFINITION CONTAINS A UNION, A UNION ALL, OR A REMOTE OBJECT-156THE STATEMENT DOES NOT IDENTIFY A TABLE-157ONLY A TABLE NAME CAN BE SPECIFIED IN A FOREIGN KEY CLAUSE. Object-name IS NOT THE NAME OF A TABLE-158THE NUMBER OF COLUMNS SPECIFIED FOR THE VIEW IS NOT THE SAME AS THE NUMBER OF COLUMNS SPECIFIED BY THESELECT CLAUSE-159DROP OR COMMENT ON token IDENTIFIES A(N) token RATHER THAN A(N) token-160THE WITH CHECK OPTION CANNOT BE USED FOR THE SPECIFIED VIEW-172function-name IS NOT A VALID FUNCTION NAME-180THE STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX-181THE STRING REPRESENTATION OF A DATETIME VALUE IS NOT A VALID VALUE-182AN ARITHMETIC EXPRESSION WITH DATETIME VALUE IS INVALID-183AN ARITHMETIC OPERATION ON A DATE OR TIMESTAMP HAS A RESULT THAT IS NOT WITHIN VALID RANGE OF DATES-184AN ARITHMETIC EXPRESSION WITH A DATETIME VALUE CONTAINS A PARAMETER MARAKER-185THE LOCAL FORMAT OPTION HAS BEEN USED WITH A DATE OR TIME AND NO LOCAL EXIT HAS BEEN INSTALLED-186THE LOCAL DATE OR TIME LENGTH HAS BEEN INCREASED AND EXECUTING PROGRAM RELIES ON OLD LENGTH-187A REFERENCE TO A CURRENT DATE/TIME SPECIAL REGISTER IS INVALID BECAUSE THE MVS TOO CLOCT IS BAD OR THE MVSPARMTE IS OUT OF RANGE-198THE OPERAND OF THE PREPARE OF THE EXECUTE IMMEDIATE STATEMENT IS BLANK OR EMPTY-199ILLEGAL USE OF KEYWORD keyword, TOKEN token-list WAS EXPECTED-203A REFERENCE TO COLUMN col-name IS AMBIGOUS-204name IS AN UNQUALIFIED NAME-205column-name IS NOT A COLUMN OF TABLE table-name-206column-name IS NOT A COLUMN OF AN INSERTED TABLE, UPDATED TABLE OR ANY TABLE IDENTIFIED IN THE FROM CLAUSE-207ORDER BY CLAUSE IS INVALID BECAUSE IT INCLUDES A COLUMN NAME BUT IT APPLIES TO RESULT OF A UNION OR UNION ALL-208THE ORDER BY CLAUSE IS INVALID BECAUSE COLUMN col-name IS NOT PART OF THE RESULT TABLE-219THE REQUIRED EXPLANATION TABLE table-name DOES NOT EXIST-220THE COLUMN NAME col-name IN EXPALANATION TABLE table-name IS NOT DEFINED PROPERLY-301THE VALUE OF THE INPUT HOST VARIABLE NUMBER position-num CANNOT BE USED AS SPECIFIED BECAUSE OF ITS DATA TYPE-302THE VALUE OF INPUT VARIBLE NUMBER position-num IS TOO LARGE TO THE TARGET COLUMNMainframe – Abend Codes and DetailsPage 47/30/2008
-303VALUE CANNOT BE ASSIGNED TO THE OUTPUT HOST VARIABLE NUMBER position-num BECAUSE DATA TYPES ARE NOTCOMPARABLE-304A VALUE WITH DATA TYPE data-type1 CANNOT BE ASSIGNED TO HOST VARIABLE BECAUSE THE VALUE IS NOT WITHIN RANGEOF HOST VARIABLE IN POSITION posit-num WITH DATATYPE data-type2-305THE NULL VALUE CANNOT BE ASSIGNED TO OUTPUT HOST VARIABLE NUMBER posit-num BECAUSE NO INDICATOR VARIABLE ISSPECIFIED-309A PREDICATE IS INVALID BECAUSE A REFERENCED HOST VARIABLEHAS THE NULL VALUE-312UNDEFINED OR UNUSABLE HOST VARIABLE variable-name-313THE NUMBER OF HOST VARIABLES SPECIFIED IS NOT EQUAL TO THE NUMBER OF PARAMETER MARKERS-401THE OPERANDS OF AN ARITHMETIC OR COMPARISON OPERATION ARE NOT COMPARABLE-402AN ARITHMETIC FUNCTION OR OPERATOR arith-top IS APPLIED TO CHARACTER OR DATETIME DATA-404THE UPDATE OR INSERT STATEMENT SPECIFIES A STRING THAT IS TOO LONG column-name-405THE NUMERIC LITERAL literal CANNOT BE USED AS SPECIFIED BECAUSE IT IS OUT OF RANGE-406A CALCULATED OR DERIVED NUMERIC VALUE IS NOT WITHIN THE RANGE OF ITS OBJECT COLUMN-407AN UPDATE OR INSERT VALUE IS NULL BUT THE OBJECT COLUMN column name CANNOT CONTAIN NULL VALUES-408AN UPDATE OR INSERT VALUE IS NOT COMPARABLE WITH THE DATA TYPE OF ITS OBJECT COLUMN column name-409INVALID OPERAND OF A COUNT FUNCTION-410THE FLOATING POINT LITERAL literal CONTAINS MORE THAN 30 CHARACTERS-411THE CURRENT DATETIME, CURRENT SQLID OR USER KEYWORD CANNOT BE USED AS SPECIFIED-412THE SELECT CLAUSE OF A SUBQUERY SPECIFIES MULTIPLE COLUMNS-414THE NUMERIC OR DATETIME COLUMN column-name IS SPECIFIED IN A LIKE PREDICATE-415THE CORRESPONDING COLUMNS, column-number, OF THE OPERANDS OF A UNION OR UNION ALL DO NOT HAVE COMPARABLECOLUMN DESCRIPTIONS-416AN OPERAND OF A UNION CONTAINS A LONG STRING COLUMN-417A STATEMENT STRING TO BE PREPARED INCLUDES PARAMENTER MARKERS AS THE OPERANDS, THE SAME OPERATOR-418STATEMENT STRING TO BE PREPARED OR AN EXECUTE IMMEDIATE STMNT CONTAINS INVALID US OF PARM MARKERS-419DECIMAL DIVIDE OPERATION IS INVALID BECAUSE RESULT WOULD HAVE A NEGATIVE SCALE-421THE OPERANDS OF A UNION OR UNION ALL DO NOT HAVE THE SAME NUMBER OF COLUMNS-501CURSOR INDENTIFIED IN FETCH OR CLOSE IS NOT OPEN-502CURSOR IDENTIFIED IN OPEN IS ALREADY OPEN-503A COLUMN CANNOT BE UPDATED BECAUSE IT IS NOT IDENTIFIED IN THE UPDATE CLAUSE OF THE SELECT STATEMENT OF THECURSOR-504THE CURSOR NAME cursor-name IS NOT DEFINED-507THE CURSOR IDENTIFIED IN THE UPDATE OR DELETE STATEMENT IS NOT OPEN-508THE CURSOR IDENTIFIED IN THE UPDATE OR DELETE STATEMENT IS NOT POSITIONED ON A ROW-509THE TABLE IDENTIFIED IN THE UPDATE OR DELETE STATEMENT IS NOT THE SAME TABLE DESIGNATED BY THE CURSOR-510THE TABLE DESIGNATED BY THE CURSOR OF THE UPDATE OR DELETE STATEMENT CANNOT BE MODIFIED-511THE FOR UPDATE CLAUSE CANNOT BE SPECIFIED BECAUSE TABLE DESIGNATED BY THE CURSOR CANNOT BE MODIFIED-514THE CURSOR cursor-name IS NOT IN A PREPARED STATE-516THE DESCRIBE STATEMENT DOES NOT IDENTIFY A PREPARED STATEMENT-517CURSOR cursor-name CANNOT BE USED BECAUSE ITS STATEMENT NAME DOES NOT IDENTIFY A PREPARED SELECT STATEMENT-518THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED STATEMENT-519THE PREPARE STATEMENT IDENTIFIES THE SELECT STATEMENT OF THE OPENED CURSOR cursor-name-530THE INSERT OR UPDATE VALUE OF FOREIGN DEY constraint-name IS INVALID-531THE PRIMARY KEY IN A PARENT ROW CANNOT BE UPDATED BECAUSE IT HAS ONE OR MORE DEPENDENT ROWS IN ARELATIONSHIP constraint-nameMainframe – Abend Codes and DetailsPage 57/30/2008
-532THE RELATIONSHIP constraint-name RESTRICTS THE DELETION OF ROW WITH RIX X ‘rid-number’-533INVALID MULTIPLE-ROW INSERT-534THE PRIMARY KEY CANNOT BE UPDATED BECAUSE OF MULTIPLE-ROW UPDATE-535INVALID UPDATE OR DELETE WITH WHERE CURRENT OF-536THE DELETE STATEMENT IS INVALID BECAUSE TABLE table-name CAN BE AFFECTED BY THE OPERATION-537THE PRIMARY KEY OR FOREIGN KEY CLAUSE IDENTIFIES COLUMN column-name MORE THEN ONCE-538FOREIGN KEY name DOES NOT CONFORM TO THE DESCRIPTION OF THE PRIMARY KEY OF TABLE table- name-539TABLE table-name DOES NOT HAVE A PRIMARY KEY-540THE DEFINITION OF TABLE table-name IS INCOMPLETE BECAUSE IT DOES NOT HAVE A PRIMARY INDEX-541FOREIGN KEY name IS INVALID BECAUSE IT IS A DUPLICATE REFERENTIAL CONSTRAINT-542column-name CANNOT BE A COLUMN OF A PRIMARY KEY BECAUSE IT CAN CONTAIN NULL VALUES-551auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation ON OBJECT object-name-552auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation-553auth-id SPECIFIED IS NOT ONE OF THE VALID AUTHORIZATION IDS-554AN AUTHORIZATION ID CANNOT GRANT A PRIVILEGE TO ITSELF-555AN AUTHORIZATION ID CANNOT REVOKE A PRIVILEGE FROM ITSELF-556A PRIVILEGE CANNOT BE REVOKED BECAUSE IT IS NOT POSSESSED BY authorization ID-557INCONSISTENT GRANT/REVOKE KEYWORD keyword. PERMITTED KEYWORDS ARE keyword-list-558INVALID CLAUSE OR COMBINATION OF CLAUSES ON A GRANT OR REVOKE-559ALL AUTHORIZATION FUNCTIONS HAVE BEEN DISABLED-571THE STATEMENT WOULD RESULT IN A MULTIPLE SITE UPDATE-601THE NAME OF THE OBJECT TO BE CREATED IS IDENTICAL TO THE EXISTING NAME name OF THE OBJECT TYPE obj-type-602TOO MANY COLUMNS SPECIFIED IN A CREATE INDEX-603A UNIQUE INDEX CANNOT BE CREATED BECAUSE THE TABLE CONTAINS ROWS WHICH ARE DUPLICATES WITH RESPECT TO THEVALUES OF THE IDENTIFIED COLUMNS-604A COLUMN DEFINITION SPECIFIES AN INVALID LENGTH, PRECISION, OR SCALE ATTRIBUTE-607OPERATION operation IS NOT DEFINED FOR SYSTEM TABLES-612column-name IS A DUPLICATE COLUMN NAME-613THE PRIMARY KEY IS TOO LONG OR HAS TOO MANY COLUMNS-614THE INDEX CANNOT BE CREATED BECAUSE THE SUM OF THE INTERNAL LENGTHS OF THE IDENTIFIED COLUMNS IS GREATERTHAN THE ALLOWABLE MAXIMUM-616obj-type1 obj-name1 CANNOT BE DROPPED BECAUSE IT IS REFERENCED BY obj-type2 obj-name2\-618OPERATION operation IS NOT ALLOWED ON SYSTEM DATA BASES-619OPERATION DISALLOWED BECAUSE THE WORKFILE DATA BASE IS NOT STOPPED-620KEYWORD keyword IN stmt type STATEMENT IS NOT PERMITTED FOR A TABLESPACE IN THE WORKFILE DATABASE-621DUPLICATE DBID dbid WAS DETECTED AND PREVIOUSLY ASSIGNED TO database-name-623A CLUSTERING INDEX ALREADY EXISTS ON TABLE table-name-624TABLE table-name ALREADY HAS A PRIMARY KEY-625TABLE table-name DOES NOT HAVE AN INDEX TO ENFORCE THE UNIQUENESS OF THE PRIMARY KEY-626THE ALTER STATEMENT IS NOT EXECUTABLE BECAUSE THE PAGESET IS NOT STOPPED-627THE ALTER STATEMENT IS INVALID BECAUSE THE PAGESET HAS USER-NANAGED DATA SETS-628A SEGMENTED TABLESPACE MAY NOT BE PARTITIONED-629SET NULL CANNOT BE SPECIFIED BECAUSE FOREIGN KEY NAME CANNOT CONTAIN NULL VALUES-631FOREIGN DEY NAME IS TOO LONG OR HAS TOO MANY COLUMNSMainframe – Abend Codes and DetailsPage 67/30/2008
-632THE TABLE CANNOT BE DEFINED AS DEPENDENT OF table-name BECAUSE OF DELETE RULE RESTRICTIONS-633THE DELETE RULE MUST BE delete-rule-634THE DELETE RULE MUST NOT BE CASCADE-635THE DELETE RULES CANNOT BE DIFFERENT OR CANNOT BE SET NULL-636THE PARTITIONING KEYS ARE NOT SPECIFIED IN ASCENDING OR DESCENDING ORDER-637DUPLICATE keyword KEYWORD-638TABLE table-name CANNOT BE CREATED BECAUSE COLUMN DEFINITION IS MISSING-639A NULLABLE COLUMN OF A FOREIGN DEY WITH A DELETE RULE OF SET NULL NCANNOT BE A COLUMN OF THE DEY OF APARTITIONED INDEX-644INVALID VALUE SPECIFIED FOR KEYWORD keyword IN STMT-TYPE STATEMENT-646TABLE table-name CANNOT BE CREATED IN PARTITIONED/DEFAULT TABLESPACE tspace-name BECAUSE IT ALREADY CONTAINSA TABLE-647BUFFERPOOL bp-name CANNOT BE SPECIFIED BECAUSE IT HAS NOT BEEN ACTIVATED-652VIOLATION OF INSTALLATION DEFINED EDIT OR VALIDATION PROCEDURE proc-name-653TABLE table-name IN PARTITIONED TABL
Mainframe – Abend Codes and Details Page 3 7/30/2008 SQL CODES Successful Execution SQLCODE: 000 SUCCESSFUL EXECUTION Warning SQLCODES: 100 ROW NOT FOUND FOR FETCH, UPDATE OR DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE
