Yes! We ran into the exact same issue.
You will have to add:
":RRIPEMPTYLIMIT :RRIPEMPTYLIMIT_IND ,",
":RRTPBGSPACEPCT :RRTPBGSPACEPCT_IND ";
Into the sqlstmt = "FETCH C102 INTO ", statement
You will get and SQL -104 if they are not there ...
Also you might see sql -305s in query monitor with the use of this
routine .. they are working on a fix for that. The error
Does not cause any issues with the performance of the routine.
Get Outlook for iOS https://aka.ms/o0ukef
From: Chris Louden <[login to unmask email]>
Sent: Monday, May 18, 2020 7:25:23 AM
To: [login to unmask email] <[login to unmask email]>
Subject: [EXT] [DB2-L] - XMPACCOX REXX to call DSNACCOX - updated
for Db2 12?
Our shop has been using the XMPACCOX REXX script to call DSNACCOX
for Db2 on Z maintenance recommendations for a few years now. Link
It hasn't been updated since Db2 10, and now there are new output
parameters in the DSNACCOX stored procedure that are returned after
moving to Db2 12 M500+ and they seem to break this script. Before
we get too involved in hacking this code to get it working
correctly, I was just wondering if anyone else was using this REXX
and had already modified for Db2 12?
-----End Original Message-----