Dynamic SQL Statement using Stored Proc

[K.Forsythe]

To do that something that flexible you need to describe the statement into the SQLDA.

[Guest.Visitor]

Dynamic SQL Statement using Stored Proc

I just want to clarify that I am using SQL (Stored Proc) to build this not the Embedded SQL in RPG?

[Guest.Visitor]

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?

[K.Forsythe]

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