SQL Abends

Negative values (Errors)

-102 String constant is too long.
-117 The number of values in the INSERT does not match the number of columns.
-180 Bad data in Date/Time/Timestamp.
-181 Bad data in Date/Time/Timestamp.
-199 Illegal use of the specified keyword.
-204 Object not defined to DB2.
-205 Column name not in table.
-206 Column does not exist in any table of the SELECT.
-216 Not the same number of expressions on both sides of the comparison in a SELECT .
-224 FETCH cannot make an INSENSITIVE cursor SENSITIVE.
-229 The locale specified in a SET LOCALE statement was not found.
-305 Null indicator needed.
-311 Varchar, insert or update. -LEN field with the right data length not set.
-482 The procedure returned no locators.
-501 Cursor not open on FETCH.
-502 Opening cursor that is already open.
-503 Updating column needs to be specified.
-530 Referential integrity preventing the INSERT/UPDATE
-532 Referential integrity (DELETE RESTRICT rule) preventing the DELETE.
-536 Referential integrity (DELETE RESTRICT rule) preventing the DELETE.
-545 Check constraint preventing the INSERT/UPDATE.
-551 Authorization failure
-747 The table is not available.
-803 Duplicate key on insert or update.
-805 DBRM or package not found in plan.
-811 More than one row retrieved in SELECT INTO.
-818 Plan and program: timestamp mismatch.
-904 Unavailable resource. Someone else is locking your data.
-911 Deadlock or timeout. Rollback has been done.
-913 Deadlock or timeout. No rollback.
-922 Authorization needed.
-927 The language interface was called but no connection had been made.
-936
-1741
-20000


Positive Values (Warnings)

+100 Row not found or end of cursor.
+222 Trying to fetch a row within a DELETE statement.
+223 Trying to fetch a row within an UPDATE statement.
+231 FETCH after a BEFORE or AFTER but not on a valid row.
+304 Value cannot be assigned to this host variable because it is out of range.
+802 The null indicator was set to -2 as an arithmetic statement didn't work.[


SQLCODE= -104 - ILLEGAL SYMBOL, ILLEGAL TOKEN IN SQL STATEMENT
SQLCODE= -110 - EMPTY TABLE, BAD QUERY
SQLCODE= -180 - THE STRING REPRESENTATION OF A DATETIME VALUE BAD DATA HAS INVALID SYNTAX
SQLCODE= -181 - THE STRING REPRESENTATION OF A DATETIME VALUE IS BAD DATA NOT A VALID DATETIME VALUE
SQLCODE= -204 - UNDEFINED TABLE NAME - TABLE NAME DOESN'T EXIST UNDEFINED ALIAS - ALIAS DOES NOT EXIST
SQLCODE= -305 - THE NULL VALUE CANNOT BE ASSIGNED TO OUTPUT BECAUSE NO INDICATOR VARIABLE IS SPECIFIED
SQLCODE= -501 - CURSOR IS CLOSED DUE TO PREVIOUS CONDITIONS
SQLCODE= -551 - DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION DROP ALIAS ON OBJECT
SQLCODE= -556 - CANNOT HAVE THE EXECUTE PRIVILEGE, REVOKED BY DB2DBA BECAUSE THE REVOKEE DOES NOT POSSESS THE PRIVILEGE OR THE REVOKER DID NOT MAKE THE GRANT
SQLCODE= -562 - A GRANT OF A PRIVILEGE WAS IGNORED BECAUSE THE GRANTEE ALREADY HAS THE PRIVILEGE FROM THE GRANTOR
SQLCODE= -626 - THE ALTER STATEMENT IS NOT EXECUTABLE BECAUSE PAGE SET IS NOT STOPPED - CALL DBA
SQLCODE= -803 - DATA PROBLEM - MAY BE BAD PART NUMBER COULD BE DUPLICATE VALUES IN EXISTING ROW
SQLCODE= -805 - BIND PROBLEM
SQLCODE= -811 - ERROR ON SQL TABLE
SQLCODE= -818 - LOAD MODULE AND DBR MODULE OUT OF SYNCH NEED TO DO BIND REPLACE OR REBIND
SQLCODE= -904 - CONTENTION
SQLCODE= -911 - CONTENTION
SQLCODE= -922 - TIME STAMP PROBLEM AFTER REBIND
SQLCODE= -923 - DB2 ERROR - SOME DB2 COMPONENT NOT AVAILABLE
SQLCODE= -924 - SUBSYSTEM NOT AVAIALABLE, CONTENTION IN DATABASE

ONCODE=9 - DATA PROBLEM
ONCODE=22 - LENGTH OF RECORD VARIABLE GREATER THAN RECORD LENGTH
ONCODE=0084 - UNDEFINED FILE CONDITION RAISE
ONCODE=1040 - SPACE PROBLEM
ONCODE=3920 - STORAGE PROBLEM
ONCODE=8094 - PROTECTION EXCEPTION - CAUSED BY BAD COMPILE - CALL ADM, B37(SPACE PROBLEM)
ONCODE=8097 - BAD DATA, DATA EXCEPTION
ONCODE=9050 - BAD DATA

MENSAGENS DE ERRO ENCONTRADAS EM JOB OUTPUT'S E QUE DEVEM SER LEVADAS EM CONTA:

'INVALID', 'ERROR', 'RESOURCE NOT AVAILABLE', 'PROGRAM NOT FOUND', 'INVALID RECORD LENGTH', 'FAILED', 'UTILITY NOT COMPATIBLE', 'DOES NOT MATCH', 'DUPLICATE', 'DATASET ALREADY USED'
DUPLICATE DATASET NAME - EITHER THE PROGRAM CONTAINS TWO DATASETS WITH THE SAME NAME, OR A DELETE UNCATALOG STEP IS NOT WORKING
'DUPLICATE UTILITY' AND 'EMPTY DATASET'

EQC - EQUIPMENT CHECK
FBI - FAILED BY INITIATOR - CHECK THE JCL FOR THE CAUSE OF THE ABEND
PROTECTION EXCEPTION - CAUSED BY A BAD COMPILE. CONTACT A PROGRAMMER
OPEN - MESSAGE STATES THAT DATASETS ARE OPEN
SEQ - TAPE DRIVE PROBLEM
UNABLE TO ALLOCATE SORTWORK SPACE - NO SORTWORK SPACE AVAILABLE. WAIT
A LITTLE WHILE UNTIL SOME JOBS FINISH PROCESSING AND THEN RESUBMIT THE
JOBS.

WRONG PASSWORD OR ACCESS NOT ALLOWED - MEANS THAT THE JOB HAS NOT A SECURITY (ACF,RACF) RULE TO EXECUTE ON THAT SCHEDULLING TOOL OR FOR ONE DATASET, ETC.

REASON CODE 00E30083 - DEADLOCK - CONTENTION
REASON CODE 00D70024 - RESOURCE UNAVAILABLE
REASON CODE 00E40034 - STORAGE UNAVAILABLE
REASON CODE 1008 - FTP LINE DOWN
REASON CODE OOE40034 - STORAGE PROBLEM - NOT ENOUGH STORAGE
SIM - PROBLEM WITH DRIVE OR TAPE, I/O ERROR
JCL - ENVIRONMENT CHANGED. NOW UNABLE TO ALLOCATE

No hay comentarios: