Copyright © Cloud Software Group, Inc. All Rights Reserved

REPLACE Statement

The REPLACE statement updates an occurrence in the database. You should first retrieve the data that you want to modify using a GET or FORALL statement.

Usage Notes

•	To alter the primary key value of an occurrence, you must DELETE the old occurrence and INSERT the new one.

•	No field selection is possible; the WHERE clause can specify only parameter values.

Exceptions

 

DATAREFERENCE	Signaled if an error is detected in the specification of selection criteria
INTEGRITYFAIL	Signaled if an attempt is made to violate data integrity Any exception lower in the hierarchy of the INTEGRITYFAIL group can also be signaled.
REPLACEFAIL	Signaled if the primary key does not exist or if an attempt is being made to update a table from a rule running in browse mode

Examples

1.	REPLACE STUDENTS;

2.	REPLACE CARS(INPUT.CITY);

About the Examples

•	Example 1 replaces data in the STUDENTS table.

•	Example 2 replaces data in the parameterized table CARS; it is parameterized by CITY. The values for the CITY parameter are provided by INPUT.CITY.

Copyright © Cloud Software Group, Inc. All Rights Reserved