To do that something that flexible you need to describe the statement into the SQLDA.
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Dynamic SQL Statement using Stored Proc
Collapse
X
-
Dynamic SQL Statement using Stored Proc
How can I execute a dynamic sql statement using stored proc? My select statement is inside a variable like sql = 'Select ' + Field1 + ', ' + Field2 + ' from mytable' I want to return the results set from the stored procedure using the above sql statement. Please guide?
Comment
-
Dynamic SQL Statement using Stored Proc
create procedure yourlib/testcursor2 (in file char(10)) language sql dynamic result sets 1 begin declare stmt char(50); declare c1 cursor for s1; set stmt = 'SELECT * FROM ' || file || ' WHERE CODE > 0'; prepare s1 from stmt; open c1; return; end
Comment
Comment