Skip to Main Content
IBM Data and AI Ideas Portal for Customers


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:

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

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Additional Information

To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

IBM Employees:

The correct URL for entering your ideas is: https://hybridcloudunit-internal.ideas.aha.io


Status Future 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
    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
    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
    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
    Jan 28, 2021

    can be useful

  • Guest
    Jan 28, 2021

    Great idea.