Thanks for your enthusiastic rebuttal or shall I say reassurance that
my impressions are wholly unfounded.
But let me clarify , DPF I presume is partitioning, my database is not
partitioned. There is only one instance.
I'm trying to execute a SELECT with COUNT and other aggregates at
Runtime and store the returned values into a Table for tracking,
analysis etc,.
The process requires to be dynamic as there will be an increasing
number of tables in this workflow and I do not want to hard code the
table names or the Conditions or the GROUP BY's for their aggregates
into huge stored procedures.
I did not anticipate anything to do with nodes or instances as these
are all occuring within the same database.
From your reply its quite clear SCROLLABLE cursors are out favor for
SQL Stored Procedures.
However What do I do about the error that appears say Stored Procedures
(in SQL) are not allowed to have Dynamic SELECT or VALUES clause.
your expertise is appreciated.
Thanks