![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
• If the table specified in tablespec is parameterized, you specify only the data parameters, not the location parameter.
• If you specify an empty string for select, all occurrences are deleted from the table and table instance.
• Specify a value for location only if the data is located on a different node.
In both cases the exception should be handled by the calling rule. More information describing the circumstances of the failure is available in the @OBJECTMSG.MSG field.The following rule deletes selected occurrences from the table EMPLOYEES_REMOTE. The rule is accessing local data.
The following rule deletes all occurrences of the DEPTS table, which is parameterized by region:
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |