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

%ChildParamDecl()

Lists all the columns and datatypes of the child table in the relationship.

Syntax

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

Syntax Example

%ChildParamDecl(,new)

Expansion

new_renting_customer INTEGER,

new_master_number INTEGER,

new_movie_copy_number INTEGER,

new_rental_record_date DATE,

new_rental_date DATE

Full Syntax

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

Full Syntax Example

%ChildParamDecl(,new,", ",IN)

Expansion

new_renting_customer IN INTEGER,

new_master_number IN INTEGER,

new_movie_copy_number IN INTEGER,

new_rental_record_date IN DATE,

new_rental_date IN DATE

Usage

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

Tip: This macro is useful when declaring parameters in stored procedures.