IBM Data and AI Ideas Portal for Customers
This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. 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).
Shape the future of IBM!
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:
Search existing ideas
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 your ideas
Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
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.
IBM Employees should enter Ideas at https://ideas.ibm.com
Hello Erik, I just learned that the id is db2zinfo@us.ibm.com (note the 'z' for z/OS). Please re-send. We're keeping an eye out for your email information. Thanks!
Hello Erik, I've notified development of your request to discuss further.
Please send your contact information to db2info@us.ibm.com, include the Aha! DB24ZOS-I-1413 number and indicate you are following up with with Janet F? Thank you.
Is it possible to contact me directly, I would like a little follow up on this outside of the ideas portal.
Dear Erik, Our Db2 for z/OS team re-reviewed this Aha! Idea and determined that they cannot consider delivering DSNHBNFE in EBNF format, since in DSNHBNFE is licensed material and not a published interface: This licensed material is not a published interface, reverse engineering of this material or use of this material to develop a programming interface are violations of the license terms and are strictly prohibited.
Therefore, we will not be considering this Aha! idea.
Sincerely,
The Db2 for z/OS Team
Dear Erik, Thank you! You are absolutely correct. I've worked with the Db2 for z/OS developer and determined the next course of action.
For this Aha! idea, it's been set back to Under Review.
We hope to provide an update for you soon.
Sincerely,
The Db2 for z/OS Team
Hello Janet, I think there is a mixup somewhere, cause this request has no relation to DCLGEN or hidden columns...
Dear Erik,
Thank you for submitting this Db2 for z/OS enhancement request. After giving the request a comprehensive review, we have determined that we cannot include it as a candidate in a future deliverable because it is not consistent with the product purpose. This request will affect all DCLGEN users and is also against the purpose we designed for the hidden column. Consequently, we will not be implementing this request.
We appreciate your input to the Db2 for z/OS development team. We also hope that you will continue to submit ideas for improvements as customer feedback is a key component to shaping the future direction of Db2 for z/OS.
Sincerely,
Db2 for z/OS Team
In order to get this working, the DSNHBNFE member should reflect the actual syntax. But member DB2.V13R1M00.SDSNSAMP(DSNHBNFE) is exactly the same as the V12R1M48 and V12R1M46 members...
Forgotten to update? Or is this path not suitable for our goal?
What would IBM suggest to use instead?
In order to be able to use the DSNHBNFE member as a basis for grammer-validation, it is of most importance that this file reflects the actual syntax.
We see in DB2.V13R1M00.SDSNSAMP(DSNHBNFE) that this file is not amended for v13. The contenteven reflects the DB2 version V12R1M46 (and was also not updated in V12R1M48).
Is there any other file/setup that IBM uses themselves to validate the syntax automatically in their build pipelines?
The Dutch Tax & Customs Authority would be very happy with this feature.
Building anltr files using BNF format definitions is very difficult and very high in maintenance costs.
Creating a modern solution here will benefit all IBM customers in creating fully automated SQL syntax validation in delivery pipelines.