Interested to Buy Any Domain ? << Click Here >> for more details...
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?.
- 11 Answers
- 20441 Views
- IBM, I also Faced
- E-Mail Answers
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
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...........
what is a rpg?
if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.
How to call one program from another program in RPG? please help me with the code
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?
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 would display prime numbers using CL program?
how do I play {insert rpg system here}?
What is a record lock error?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
How can we know running job is batch or interactive?
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...?
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?
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
explain sflclr, sflend, sfldlt, and sflcsrrrn?
