SQL in an SQLRPGLE program
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/EXEC SQL C+ DECLARE C1 CURSOR FOR SELECT * FROM F0101JN WHERE ALADDZ = :SZIP C+ AND ABALPH LIKE :SINNME ORDER BY ABAN8 [...]

Answer Question   |  April 20, 2009  7:35 AM
C+, Embedded SQL, LIKE statement, SQL, SQL/400, SQLRPGLE

Fetch to datastructure in RPG/400
I have one rpg pgm in which I am creating a cursor on select to slect some records.After then I am opening cursor and fetching its data to an external data structure.Now my question is whether the external data structure takes only one record(first record) or it will have all records selected through select ststament. [...]

Answer Question   |  May 4, 2010  12:50 PM
C+, Data structures, RPG, RPG/400