ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

UDF in Check Constratint

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

  • UDF in Check Constratint

    Will User Defined Functions ever be allowed for use as part of a Check Constraint (eg. the sql code below)? Or, am I just doing it wrong?

    Consider that the columns label_type_id and label_category_id are part of the table being updated/inserted.

    ALTER TABLE mf_product_label ADD CONSTRAINT mf_product_label_CK3 CHECK (labelTypeCategoryId(label_type_id) = label_category_id);


    Thanks in advance.

    Walt
Working...
X