SPL
Dear All,
I have a SP for selecting all the fields from a table, as show below:
----------------------------------------------
create procedure sp_bank()
returning char(1), char(40);Define t_field1 like table1.field1,
t_field2 like table1.field2;
FOREACH SELECT field1, field2 INTO t_field1, t_field2 FROM table1
RETURN t_field1, t_field2 WITH RESUME;
END FOREACH
end procedure
-----------------------------------------------
Is there a workaround (alternative solution) that I can use to select all fields and return all fields without
specifying individual fields/variable ?? Something like:
-------------------------------------------------------------------------
CREATE PROCEDURE sp_name()
RETURING temp_table.*;
SELECT * INTO temp_table.* FROM tablename
RETURN temp_table.*
--------------------------------------------------------------------------
Any advice appreciated.
Regards.
Richard W Sinyem