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

%ParentNKDecl()

Lists the non-key columns of the parent table in the relationship followed by their datatypes.

Syntax

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

Syntax Example

%ParentNKDecl(,new)

Expansion

new_general_condition VARCHAR(10)

Full Syntax

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

Full Syntax Example

%ParentNKDecl(,new,", ",IN))

Expansion

new_general_condition IN VARCHAR(10)

Usage

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