i have 1000 records in pf.what are all the ways to read a
particular name records in rpg?? ie.. in pf i have a name
called demo appeared around 52 times hw will we read this
particular records in rpg/400?.
Answer Posted / rajkalyanam
Say Physical file name is PF001 and Field name is NAME
and i want to select all records having their name as DEMO
then i will use SQLRPG,please correct me if i'm wrong
Select * from PF001 where name = 'DEMO'
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what are the key words you must use when using a subfile?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
How can we override a file during runtime in rpg?
Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?
is this a rpg channel?
can you debug ile rpg program using isdb?
what is program status data structure?
how do I declare a minor?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
how can you display specific subfile page on the screen in unequal subfile?
what is an online rpg?
How can we know running job is batch or interactive?
what is the use of sflnxtchg?
what was the robotech rpg?
What is the purpose of record level identifier?