I want to use embedded SQL in an SQLRPGLE program to search a file for a field entered in a screen to select data using the LIKE operand.
This is my code
C+ DECLARE C1 CURSOR FOR SELECT * FROM F0101JN WHERE ALADDZ = :SZIP
C+ AND ABALPH LIKE :SINNME ORDER BY ABAN8
I entered %VALLEY% into screen field SINNME but the statement did not select any records.
April 10, 2009 7:35 AM
April 20, 2009 3:11 PM