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


Please Help Members By Posting Answers For Below Questions

what are the key words you must use when using a subfile?

696


what happens when sflsiz = sflpag? What are the advantages and disadvantages?

718


How can we override a file during runtime in rpg?

695


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?

4225


is this a rpg channel?

689






can you debug ile rpg program using isdb?

748


what is program status data structure?

1403


how do I declare a minor?

722


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.

762


how can you display specific subfile page on the screen in unequal subfile?

681


what is an online rpg?

741


How can we know running job is batch or interactive?

663


what is the use of sflnxtchg?

820


what was the robotech rpg?

691


What is the purpose of record level identifier?

737