IBM Support

SE70340 - ILEC-CMPL-MSGCPF2110 SQL COMPILATION WITHOUT QSYSINC

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 APAR (Authorized Program Analysis Report)

Abstract

ILEC-CMPL-MSGCPF2110 SQL COMPILATION WITHOUT QSYSINC

Error Description

In order to support SQL include enhancement, ILE C compiler was
updated to add QSYSINC into library list when it is invoked from
SQL.  This was done by APAR SE66029.                            
                                                               
But if QSYSINC (5770SS1 option 13) is not installed on the      
system, compilation will fail with MSGCPF2110 and MSGMCH3601,  
and SQL procedure creation will fail with MSGSQL7032.  For SQL  
procedure creation, if header files in QSYSINC are not used,    
compilation should not fail even if QSYSINC is not installed.  
This was fixed by APAR SE67251.                                
                                                               
With the above fix, MSGCPF2110 is still generated for a        
successful compilation.  This causes a confusion.              

Problem Summary

When ILE C compiler is invoked by STRSQL session or RUNSQL      
command, MSGCPF2110 will be generated if library QSYSINC        
(5770SS1 option 13) is not installed.  This causes a confusion  
for successful compilation.                                    

Problem Conclusion

The ILE C compiler will be updated to fix this problem.        
MSGCPF2110 will not be generated for STRSQL and RUNSQL if      
library QSYSINC (5770SS1 option 13) is not installed.          

Temporary Fix

Comments

Circumvention


PTFs Available

R710 SI68827 PTF Cover Letter   1000
R720 SI68824 PTF Cover Letter   9123
R730 SI68823 PTF Cover Letter   9116

Affected Modules

         
         

Affected Publications

Summary Information

Status............................................ CLOSED PER
HIPER........................................... No
Component.................................. 5770SS118
Failing Module.......................... RCHMGR
Reported Release................... R710
Duplicate Of..............................




IBM i Support

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 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

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15Q","label":"APARs - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0;V7R2M0;V7R3M0;V7R4M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 May 2019