Inserts a record into an existing relation. You can add a
record to only one relation with a single STORE statement.
The statements between the keywords STORE and END_STORE form a
context block. You cannot store records into views defined by any
of the following record selection expression (RSE) clauses:
o WITH
o CROSS
o REDUCED
o FIRST
Trying to store into views that were defined with any of the
above clauses could cause unexpected results in your database.
You can use the GET statement within the bounds of the STORE ...
END_STORE block. Note that any valid format of the GET statement
is permitted within this block.
You may find it particularly useful to use the GET statement to
place the database key (dbkey) of the record you are storing into
a host variable. Use the GET...RDB$DB_KEY construct to assign the
value of the dbkey to the host variable.
Additional Information:
explode
extract