Datacom DBSQLPR Return Codes RC 2001 to 2018 are documented in 15.0 Message Reference Guide but are missing from 14.0 guide.

Document ID : KB000056723
Last Modified Date : 14/02/2018
Show Technical Document Details

The CA Datacom/DB Message Reference Guide Version 14.0 is missing information on the DBSQLPR return codes 2001 to 2018.

However, the CA Datacom/DB Message Reference Guide Version 15.00 properly documents them as follows:

On page 9: 

? DBSQLPR Return Codes

RC 2001 (see page 773) - FILE filename (MODE mode) OPEN ERROR msg: USING DEFAULTS

RC 2002 (see page 773) - (option) EXCEEDS nnnn CHARACTER(S) or SQL STATEMENT EXCEEDS 65530 CHARACTER(S)

RC 2003 (see page 773) - OPTION (filename) FILE ALREADY OPEN: MOVE TO 'PARM=' SPEC

RC 2004 (see page 774) - (option) OPTION VALUE INVALID: CORRECTED BY LATER SPEC. or (option) OPTION VALUE INVALID: (error description)

RC 2005 (see page 774) - WARNING - INCOMPLETE STATEMENT FOUND

RC 2006 (see page 774) - OPTION SPECIFICATION '<option>' IS INVALID

RC 2007 (see page 775) - UNABLE TO PRINT TABULAR FORMAT OUTPUT: OVER nnnn COLUMNS or UNABLE TO PRINT TABLUAR FORMAT OUTPUT: PRTWIDTH SPEC nnnn EXCEEDED

RC 2008 (see page 775) - MISSING (error)

RC 2009 (see page 775) - (SQL element) (Type of limit) OF nnnn EXCEEDED

RC 2010 (see page 776) - ALLOCATION OF nnnn BYTES FOR (control block) FAILED

RC 2011 (see page 776) - COLUMN (col name) WIDTH OF nnnn EXCEEDS DEFINED LENGTH

 - RC 2012 (see page 776) - (not printed: cannot open print file)

RC 2013 (see page 776) - WARNING - NO STATEMENTS FOUND

RC 2014 (see page 777) - DB <DB Command> COMMAND RECEIVED RETURN CODE nn (XX)

RC 2015 (see page 777) - WARNING: DUPLICATE '<option>' SPECIFICATION IGNORED

RC 2016 (see page 777) - WARNING: OPTION <option> VALUE TOO <SMALL or LARGE>, RESET TO nnnn (NEAREST LIMIT)

RC 2017 (see page 778) - WARNING: *$ENDLOOP COMMAND OUTSIDE OF LOOP WAS IGNORED

RC 2018 (see page 778) - SIMULATED PROCEDURE LABEL <procedure name> MAY NOT MATCH PLANNAME OPTION

 

The link to the public CA Datacom/DB Message Reference Guide Version 15.00 is

https://support.ca.com/cadocs/0/CA%20Datacom%20V15%200%20Public-ENU/Bookshelf_Files/PDF/DatacomDB15--Message_Ref_ENU.pdf