This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,
Post an idea.
Get feedback from the IBM team and other customers to refine your idea.
Follow the idea through the IBM Ideas process.
Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.
IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.
ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.
Hi Paul, I have discussed this with the developer for the system debugger, and he says that the support for single-step in the SQL source view has been available for several years. He says that for 7.1, please apply PTFs SI62153 and SI62152; for 7.2 PTFs SI62495, SI62150, SI62154; for 7.3 PTFs SI62494, SI62038, and SI62111.
If you have those PTFs, and you are still finding that you have to do multiple steps for an EXEC SQL statement when using the SQL source view, please open a PMR.
Reading your statement that a DBGVIEW(*SOURCE) only requires a single step is NOT correct !
This RFE has therefore been closed based on incorrect information !
After further investigation, we have found that the system debugger already requires only a single step to step over an EXEC SQL statement when using the source view, but allows stepping through the individual statements when using the listing view. If the RPG compiler implemented OPTIONI*NODEBUGIO), it would prevent the ability to get a breakpoint on the individual generated statements when using the listing view.
Since the system debugger has already alleviated this problem, IBM does not intend to provide OPTION(*NODEBUGSQL) at this time, so this RFE is being closed.
There is another RFE regarding debugging SQL source using the RDi debugger. That RFE specifically requests single stepping over an EXEC SQL statement. Please vote for that RFE if you use the RFE debugger.
https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=122252
IBM will use this request as input to planning but no commitment is made or implied. This request will be updated in the future if IBM implements it. IBM will use votes and comments from others in the community to help prioritize this request.
The CAAC has reviewed this requirement and recommends that IBM view this as a high priority requirement that is important to be addressed. With imbedded SQL, there are many hidden steps that should be stepped over in the debugger to lower the frustration level, and speed up debugging process.
Background: The COMMON Americas Advisory Council (CAAC) members have a broad range of experience in working with small and medium-sized IBM i customers. CAAC has a key role in working with IBM i development to help assess the value and impact of individual RFEs on the broader IBM i community, and has therefore reviewed your RFE.
For more information about CAAC, see www.common.org/caac
For more details about CAAC's role with RFEs, see http://www.ibmsystemsmag.com/Blogs/i-Can/May-2017/COMMON-Americas-Advisory-Council-%28CAAC%29-and-RFEs/
Nancy Uthke-Schmucki - CAAC Program Manager
.IBM has received the requirement and is evaluating it. IBM will provide a response after evaluation is complete.