Skip to Main Content
IBM Z Software


This portal is to open public enhancement requests against IBM Z Software products. 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
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


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.

Status Not under consideration
Created by Guest
Created on Nov 30, 2015

Support des colonnes DB2 XML dans la génération des DDL et des accès SQL

Bonjour,

Merci d'ajouter le support des colonnes XML pour le SGBD DB2 (z/OS).
Ceci concerne :
- la g?n?ration de DDL ? partir de Bloc Base de Donn?es
- la g?n?ration de hosts-variables compatibles avec les colonnes XML des structures en organisation "2" (? noter que les hosts-variables "BLOB"/"CLOB" sont compatibles avec les colonnes XML).

Pour cela nous sugg?rons de g?rer un nouveau type de Rubrique "X" de fa?on similaire au type "L", avec les m?mes usages :
- Type "X" + Usage "1" : XML BINARY
- Type "X" + Usage "2" : XML CHARACTERS

Cordialement,

Denis FALLAI
IT-CE groupe BPCE

Idea priority Medium
  • Guest
    Reply
    |
    Nov 16, 2020

    We have evaluated this request and determined that it cannot be implemented at this time because it does not fall into IBMs delivery plans for the next 12 month. Whilst this RFE might be valid and we might look to deliver longer term, this RFE is being rejected at this time.

  • Guest
    Reply
    |
    Feb 6, 2018

    A preliminary evaluation of this request indicates that it is consistent with our business strategy. Further evaluation of this RFE is underway.

  • Guest
    Reply
    |
    Dec 4, 2017

    Thank you for submitting this request for enhancement; we are evaluating it.

  • Guest
    Reply
    |
    Dec 4, 2017

    Actuellement le type de rubrique L propose les usages 1 à 9 pour générer respectivement BLOB, CLOB, DBCLOB, BLOB-LOCATOR, CLOB-LOCATOR, DBCLOB-LOCATOR, BLOB-FILE, CLOB-FILE, DBCLOB-FILE.
    Nous proposons de gérer une type X avec les usages 1, 2, 3, 7, 8, 9 pour générer XML AS BLOB, XML AS CLOB, XML AS DBCLOB, XML AS BLOB-FILE, XML AS CLOB-FILE et XML AS DBCLOB-FILE
    Celà vous convient-il ?

  • Guest
    Reply
    |
    Oct 10, 2017

    Although the theme of this request is consistent with our business strategy, it is not committed to the release that is currently under development.

  • Guest
    Reply
    |
    Feb 24, 2016

    La mise en œuvre de colonnes DB2 XML doit être vu à deux niveaux :
    - génération du DDL
    - génération des hosts-variables dans les programmes

    Génération du DDL : il n'existe qu'un seul type qui est "XML"

    Génération des hosts-variables : il faut pouvoir déclarer de hosts-variables "XML AS xLOB" en correspondance avec un appel de Rubrique dans le Segment support de la description de table (génération du DDL), ainsi que des hosts-variables "XML AS xLOB-LOCATOR" et "XML AS xLOB-FILE" non en correspondance avec un appel de Rubrique dans le Segment support de la description de la table (génération du DDL).
    xLOB pour "CLOB", "BLOB" et "DBCLOB".

    A noter que DB2 permet l'utilisation de hosts-variables Large Object non spécifiquement XML et de hosts-variables "XML AS" surchargeant un Large Object. Nous n'avons pas vu à cette heure de différence de comportement à l'exécution entre ces deux utilisations, même si la génération des structures SQLDA est légèrement différente.