SE65945 - OSP-DB-MSGMCH3203 F/DBPMTRAP T/QQQOOODBOP USING RECURSIVE
COMMON TABLE EXPRESSION

APAR (Authorized Program Analysis Report)

Abstract

OSP-DB-MSGMCH3203 F/DBPMTRAP T/QQQOOODBOP USING RECURSIVE
COMMON TABLE EXPRESSION

Error Description

Running query with a recursive common table expression results  
in MSGMCH3203 f/DbpmTrap t/QQQOOODBOP.  The following SQL query
fails.                                                          
                                                               
with date_table (yymmdd) as                                    
   (select yymmdd from qtemp.primed                            
    union all                                                  
    select varchar(yymmdd) from date_table)                    
select * from date_table                                        

Problem Summary

Running query with a recursive common table expression results  
in MSGMCH3203 f/DbpmTrap t/QQQOOODBOP.  The following SQL query
fails.                                                          
                                                               
with date_table (yymmdd) as                                    
   (select yymmdd from qtemp.primed                            
    union all                                                  
    select varchar(yymmdd) from date_table)                    
select * from date_table                                        

Problem Conclusion

There was a problem with the mapping of a character field to a  
numeric field across the UNION subselects. This problem has been
corrected.                                                      

Temporary Fix

Comments

Circumvention

PTFs Available

R710 SI62836  7192

R720 SI62835  7068

R730 SI62830  7061

Affected Modules

Affected Publications

Summary Information

IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information