For purposes of debugging or writing stored procedures that are
specifically meant to work with local data only, it is useful to
disable cluster functionality.
This is done with the NO CLUSTER table option. This can be used
in the table option clause of a table in a FROM or in an update or
Specially when writing procedures to be called with DAQ, see
below, it us necessary to ensure that the procedures will not
access data outside of the host running them.
select count (*) from x table option (no cluster);
update x table option (no cluster) set y = y + 1;
update x set y = 1 where current of cr option (no cluster)
insert into xx key xx option (no cluster) (c1, c2) values (1, 2);
Note that for positioned (where current of) deletes and updates
the option is at the end. For searched ones it is after the table.
Use the explain () function to see the compilation of statements to
make sure about the locus of execution. If a table is to be
accessed across the cluster, this is indicated in the output.
All other SQL options work as with single server databases.