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

%ParentPKDecl()

Lists the primary key elements of the parent table in the relationship followed by their datatypes.

Syntax

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

Syntax Example

%ParentPKDecl(,new)

Expansion

new_master_number INTEGER,

new_movie_copy_number INTEGER

Full Syntax

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

Full Syntax Example

%ParentPKDecl(,new,", ",IN)

Expansion

new_master_number IN INTEGER,

new_movie_copy_number IN INTEGER

Usage

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