In the context of SQL, you can use the
EGL set statement
to reset all the fields in an SQL record variable.
Syntax
SQLRecordVariable
The name of an SQL record variable whose fields the set statement
resets.
value
The value to be assigned to the target SQL record variable. Choose
from
the following values:
empty
Here the set statement works recursively
through
any record variables contained within the record, or, in the case
of a structured
record, works down to the lowest level of the structure. Primitive
types have
the following settings:
Numeric fields are set to zero.
Character
fields are set to blanks.
Date/time fields are set to the
current date or time, and INTERVAL fields
are set to zero.
Fields of type ANY are set according to the
type of their current value;
if they do not currently have a value, the set statement
has no effect on them.
initial
An SQL record variable within a Handler part can specify an initial
value
for each of its fields. The initial modifier
resets
the values of those fields to the ones specified in the record definition.
If the record definition does not specify any initial values, or if
the record
is not in a Handler part, the effect of the initial modifier
is the same as that of the empty modifier.
Example
The following example clears all fields in the myCustomer customer
record variable: