I've Report to print using SQLRPGLE
The Report criteria screen has around 15-20 select conditions...based on the conditions entered by the user, I build a query of type
Select * from emp1 where val1 = ? and val2 =? and val3 = ? and...........
This is the first time I'm dealing with so many select criteria in my query. At the point of executing this query, when I open cursor with following statement
C/Exec SQL C+ Open C1 USING :FLD1, :FLD2, :FLD3, ..... C/End-Exec
How will I check what fields to pass in Using class. I understand that if the field is not blank or zero then I have to pass it but if 20 fields then how to write this code
October 14, 2009 10:05 PM
October 21, 2009 3:17 PM