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

%ChildNKDecl()

Lists the non-key elements and datatypes of the child table in the relationship.

Syntax

%ChildNKDecl(<old prefix>, <new prefix>)

Syntax Example

%ChildNKDecl(,new)

Expansion

new_rental_date DATE,

new_due_date DATE, …

Full Syntax

%ChildNKDecl(<old prefix>, <new prefix>,<separator>,<attribute/type separator>)

Full Syntax Example

%ChildNKDecl(,new,", ",IN)

Expansion

new_rental_date IN DATE,

new_due_date IN DATE, …

Usage

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