ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

SQL equivalent to CHGPFCST FILE(ESPDEV/TABLE) CST(TABLE2_FK) STATE(*DISABLED)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL equivalent to CHGPFCST FILE(ESPDEV/TABLE) CST(TABLE2_FK) STATE(*DISABLED)

    Hi.

    In an SQL script I'd like to add a sentence to disable a Foreign key.
    I know how to do it using a command.
    But I'd like to use the equivalen SQL sentence (if it is possible).

    I know one option could be calling the procedure QCMDEXC, but I prefer to avoid that.


    Does, anyone of you, know if this is possible? (I've surfered through multiple webpages, but I can't find any correct answer).


    Thanks
Working...
X