Skip to Main Content
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,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. 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 Data & AI Roadmaps (http://ibm.biz/Data-and-AI-Roadmaps) - Use this site to view roadmaps for Data & AI products.

IBM Employees should enter Ideas at https://hybridcloudunit-internal.ideas.aha.io/


Status Not under consideration
Workspace Db2 for z/OS
Created by Guest
Created on Nov 14, 2022

Deliver DSNHBNFE from SDSNSAMP in EBNF format

The DSNHBNFE member delivers a formal definition of the Db2 syntax in BNF format. However, tools like ANTLR can generate lexers/parsers automatically if the language is delivered in a EBNF format.

https://en.wikipedia.org/wiki/Extended_Backus%E2%80%93Naur_form

Delivering (an alternative for) DSNHBNFE in EBNF format would make it much more easy to generate tools that can do code quality checks.

Needed By Not sure -- Just thought it was cool
  • Admin
    Janet Figone
    Dec 2, 2022

    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!

  • Guest
    Dec 2, 2022
    Hello Janet, Are you sure that email address is correct? When I send an email to it it bounced with a 'user unknown' message.
  • Admin
    Janet Figone
    Dec 2, 2022

    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.

  • Guest
    Dec 1, 2022

    Is it possible to contact me directly, I would like a little follow up on this outside of the ideas portal.

  • Guest
    Dec 1, 2022
    Let me rephrase that a bit, we have not used it in any, since in it's current format it is not practically usable for what we were trying to do, but I will make sure we won't use this human readable formal definition of your own language that you distribute in your own SDSNSAMP.
  • Guest
    Dec 1, 2022
    What a nonsense, why is it delivered in the SDSNSAMP if it is considered unpublished? Anyways, so far for IBM's commitment to open source. But the answer is perfectly clear, we will not use this any more.
  • Admin
    Janet Figone
    Nov 30, 2022

    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

  • Admin
    Janet Figone
    Nov 29, 2022

    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

  • Guest
    Nov 29, 2022

    Hello Janet, I think there is a mixup somewhere, cause this request has no relation to DCLGEN or hidden columns...

  • Admin
    Janet Figone
    Nov 28, 2022

    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

  • Guest
    Nov 17, 2022

    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?

  • Guest
    Nov 17, 2022

    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?

  • Guest
    Nov 14, 2022

    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.