Messages › New Return Codes

New Return Codes

Datadictionary

CA Datacom/DB

• 75 (001) - UNEXPECTED CONDITION CXX
• 75 (002) - KEY INVALID, ALTER-CREATE-DROP
• 76 (011) - INIT DISP OLD
• 76 (015) - TOO MANY TRACKS
• 94 (147) - LOG LRSN MAX
• 94 (148) - LOG LBSN MAX
• 94 (149) - LBSN NEAR MAX

DSF Return Codes for the 1000 SWAP Transaction

• IKS - INTERNAL - INVALID KEY SWAP
• KS1 - KEY SWAP - LENGTHS DO NOT MATCH
• KS2 - KEY SWAP - FIELD LISTS DIFFERENT
• KS3 - KEY SWAP - DATACOM-ID VALUES EQUAL
• KS4 - KEY TYPE NOT INDEX
• KS5 - KEY SWAP - FLD ASCEND/DESCEND ERR
• KS6 - KEY SWAP - INVALID INCLUDE NIL CHG
• KS7 - KEY SWAP - FLD DATA-SENSITIVE ERR

DSF Return Codes for KEY-KU2 - USAGE

• KU1 - KEY-USAGE NOT "A" FOR MASTER OR NATIVE KEY
• KU2 - KEY-USAGE NOT “A” FOR A PARTITION OR FOREIGN KEY
• KU3 - KEY-USAGE NOT “A” FOR DATACOM DATABASES
• KU4 - KEY-USAGE MUST BE A FOR CONSTRAINT

DBSQLPR Return Codes

• RC 2001 FILE filename (MODE mode) OPEN ERROR msg: USING DEFAULTS
• RC 2002 (option) EXCEEDS nnnn CHARACTER(S) or SQL STATEMENT EXCEEDS 65530 CHARACTER(S)
• RC 2003 OPTION (filename) FILE ALREADY OPEN: MOVE TO 'PARM=' SPEC
• RC 2004 (option) OPTION VALUE INVALID: CORRECTED BY LATER SPEC. or (option) OPTION VALUE INVALID: (error description)
• RC 2005 WARNING - INCOMPLETE STATEMENT FOUND
• RC 2006 OPTION SPECIFICATION '<option>' IS INVALID
• RC 2007 UNABLE TO PRINT TABULAR FORMAT OUTPUT: OVER nnnn COLUMNS or UNABLE TO PRINT TABLUAR FORMAT OUTPUT: PRTWIDTH SPEC nnnn EXCEEDED
• RC 2008 MISSING (error)
• RC 2009 (SQL element) (Type of limit) OF nnnn EXCEEDED
• RC 2010 ALLOCATION OF nnnn BYTES FOR (control block) FAILED
• RC 2011 COLUMN (col name) WIDTH OF nnnn EXCEEDS DEFINED LENGTH
• RC 2012 (not printed: cannot open print file)
• RC 2013 WARNING - NO STATEMENTS FOUND
• RC 2014 DB <DB Command> COMMAND RECEIVED RETURN CODE nn (XX)
• RC 2015 WARNING: DUPLICATE '<option>' SPECIFICATION IGNORED
• RC 2016 WARNING: OPTION <option> VALUE TOO <SMALL or LARGE>, RESET TO nnnn (NEAREST LIMIT)
• RC 2017 WARNING: *$ENDLOOP COMMAND OUTSIDE OF LOOP WAS IGNORED
• RC 2018 SIMULATED PROCEDURE LABEL <procedure name> MAY NOT MATCH PLANNAME OPTION

SQL

• -571 - SOURCE CACHE ERROR: msg-string

Improved Error Handling, Master List Buffer Dumping

The number of return codes that requires a buffer dump in addition to a Master List has been reduced. Additionally, buffer dumps are no longer written to the PXXML or PXX because they are documented using a z/OS System dump (IPCS).