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
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
how do you use commitment control in rpg?
Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
How to call one program from another program in RPG? please help me with the code
What are the types of identifiers?
can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.
explain sflclr, sflend, sfldlt, and sflcsrrrn?
what is the rpg system?
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........
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
How to handle duplicate error handling in RPG?
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
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg