I am trying to select only a certain number of records from a table.
It is easy enough with "fetch first" syntax.  What complicates this a
bit is the fact that I need to retrieve the number of rows from another
table.  So:

begin atomic
declare num_records int default 0;
set num_records = (select number_of_rows from master_table);
select * from main_table fetch first num_records rows only;
end

However, this does not seem to work as DB2 is expecting a literal
integer value in the "fetch first" clause.  Is there a way around this?

Thanks in advance!