Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can we search particular records from the database file
in RPG.
For example, there are
100 records in the file.i need to retrieve all the records
matching/equal to the particular 'NAME' field. How can we
do the above using SEARCH criteria other than using the IF
cond?

Answer Posted / maha

by using runqry *n file name rcdformat(*slt)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to call one program from another program in RPG? please help me with the code

1670


When it is desirable to describe files Internally?

1646


thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

2267


Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?

1985


What is file identifier where we can use?

1072


how do I preserve and clean the array?

1081


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

1099


how can I tell when to replace the array?

1152


What is the difference between iter and do?

1150


How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique

953


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?

5060


How Chain operation copies the record's data to the input buffer for the program?

1535


how do I declare a minor?

1108


can you debug ile rpg program using isdb?

1186


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

1123