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 Employees should enter Ideas at https://ideas.ibm.com


Status Not under consideration
Workspace Db2 for z/OS
Created by Guest
Created on Jan 27, 2021

Expand error message -532 and and output parent table name and child table name

Table1 has 4 level foreign key

Table1 to Table2 --> FK_01

Table2 to Table3 -->FK_01, FK_02

Table3 to Table4-->FK_01, FK_02

Table4 to Table5 --> FK_01

If I delete row in Table1, I get the message:

DSNT408I SQLCODE = -532, ERROR: THE RELATIONSHIP FK_01

RESTRICTS THE DELETION OF ROW WITH RID X'0000008201'


But witch one of all FK_01 is it?

I have realy a big problem to find the foreign key causes the error message.

It is not impossible to find out, but very time-consuming .

Needed by Date Mar 1, 2021
  • Admin
    Janet Figone
    Reply
    |
    Mar 18, 2021

    Hello Eva, I believe the information needed, in this case, is one Db2 z development team is seeking information from another Db2 z development team. Will keep you posted if anything further is needed. Thank you.

  • Admin
    Janet Figone
    Reply
    |
    Feb 17, 2021

    Hello, I have asked the Db2z engineer to specify the additional information they need and will post it here when they respond. Thank you.

  • Guest
    Reply
    |
    Jan 29, 2021

    Hello,

    What information do You need?

    Eva Bartulej

    Eva Bartulej
    Abteilung Informatik - Betrieb

    HUK-COBURG
    Bahnhofsplatz
    96444 Coburg
    Telefon: 09561 96-44142
    Telefax: 09561 96-44104
    E-Mail: Eva.Bartulej@huk-coburg.de
    Internet: www.huk.de
    ________________________________
    HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
    Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
    Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
    Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
    Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer, Sarah Rössler, Thomas Sehn, Daniel Thomas.
    ________________________________
    Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
    Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
    informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
    Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

    This information may contain confidential and/or privileged information.
    If you are not the intended recipient (or have received this information in error) please notify the
    sender immediately and destroy this information.
    Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
    ________________________________
    Von: IBM Data and AI Ideas (Janet Figone)
    Gesendet: Donnerstag, 28. Januar 2021 00:56
    An: Bartulej, Eva
    Betreff: Expand error message -532 and and output parent table name and child table name status has changed to Needs more information

    Antworten Sie auf diese Nachricht und Ihre Antwort wird zur Idee hinzugefügt

    [Das Bild wurde vom Absender entfernt. IBM Data and AI Ideas Portal for Clients]

    Expand error message -532 and and output parent table name and child table name has changed status to: Needs more information

    Table1 has 4 level foreign key

    Table1 to Table2 --> FK_01

    Table2 to Table3 -->FK_01, FK_02

    Table3 to Table4-->FK_01, FK_02

    Table4 to Table5 --> FK_01

    If I delete row in Table1, I get the message:

    DSNT408I SQLCODE = -532, ERROR: THE RELATIONSHIP FK_01

    RESTRICTS THE DELETION OF ROW WITH RID X'0000008201'

    But witch one of all FK_01 is it?

    I have realy a big problem to find the foreign key causes the error message.

    It is not impossible to find out, but very time-consuming
    .

    View Your Idea

    Sie erhalten Benachrichtigungen, weil Sie diese Idee abonniert haben. Sie können das Update von diese spezifische Idee oder von alle Ideen in IBM Data and AI Ideas Portal for Clients abbestellen.

  • Guest
    Reply
    |
    Jan 28, 2021

    can be useful

  • Guest
    Reply
    |
    Jan 28, 2021

    Great idea.