DBSQLPR gets RC 2020 after upgrading Datacom to 15.0

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

An SQL query is executed via DBSQLPR and the selected rows are saved on an z/OS dataset with LRECL 80 (allocated to STDOUT dataset). The job ran fine when running Datacom 14.0 but after the upgrade to 15.0, it gets RC 2020.

Environment

CA Datacom 15.0 and above

Cause

Datacom 15.0 corrected some DBSQLPR errors to file management, so some functions have changed.

Resolution

The problem occurs when the STDOUT dataset has a LRECL=121 or less. 
If so, a PRTWIDTH option must be specified for DBSQLPR. The value of this option must match the LRECL of the STDOUT dataset. SQL 15.0 APAR ST07726 (or SQL 15.1 ST07727) must be applied too.
 

Additional Information

A quick workaround:
If adding any of the following options: 
NOECHO 
NOPAGEHDR 
NOPAGES 
it works fine on 15.0 too.