Use the Declare REFERENCING Clause window to construct the REFERENCING clause for the SPL function that you are creating. The REFERENCING clause declares a correlation name that can be used to qualify column values in the triggering table.
To open the Declare REFERENCING Clause window:
- In the Procedure view of the IBM Procedure Designer, click the
button next to the
REFERENCING field. - In the Function view of the IBM Function Designer, click the
button next to the
REFERENCING field.
- New row
- Specify a correlation name for the new value of the column in the triggering table after the triggering statement runs.
- Old row
- Specify a correlation name for the old value of the column in the triggering table before the triggering statement runs.
- Owner
- Specify the user ID of the owner of the triggering table.
- Table name
- Specify the name of the triggering table.
See Also
Function, Designer | Creating SQL and SPL Functions
.NET Development Forum IDS FAQs
© Copyright IBM Corporation 2002, 2019. All Rights Reserved.