Working with Data Models › Macro Toolbox › Relationship Macros › %ChildNK()

%ChildNK()

Lists non-key elements of the child entity and performs the specified action on each.

Syntax

%ChildNK()

Syntax Example

%ChildNK()

Expansion

rental_date, due_date, …

Full Syntax

%ChildNK(<separator>,<function>, <prefix>)

Full Syntax Example

%ChildNK(" or ",update,%Child)

Expansion

update(MOVIE_RENTAL_RECOR.rental_date) or

update(MOVIE_RENTAL_RECOR.due_date)

Usage

Classified as a Relationship macro that you can use in RI or Rel Override, %ForEachParentRel, %ForEachChildRel.