Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve particular field records from a physical
file,say i have a physical file called 'employee' in it i
have to retrieve the records of a field 'admin' present in
pf 'employee' using rpg,but i should not use logical file
or openquery file.
- 3 Answers
- 9504 Views
- iGate, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gagandeep kaur
We can use embedded SQL in RPG to retreive records.It works
faster as comapred to other methods
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / satya
If this is a keyfld, u can directly call the record in 'factor1' setll filename then read.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between copybooks and subprocedures in as400?
Can more than one subfile record be displayed on one line?
Please help me, I have created window subfile,I have created Footer with same lengh and postion of window SFL. When I call the pgm, first is shows only Footer and then it shows subfile records.This time Footer is not showsing ..plz hel me how can i do it...? Sameple DDS and RPG: A R WIN1 SFL A*%%TS SD 20090130 165346 MUNSHIJ REL-V4R2M0 5769- PW1 A FLD001 1Y 0B 4 3EDTCDE (Z) A ATFILE R O 4 7REFFLD (QWHFDBAS/ATFILE LIB/LIBF- A ILE) A R WINCTL SFLCTL (WIN1) A*%%TS SD 20090202 123459 MUNSHIJ REL-V4R2M0 5769- PW1 A ALTNAME ('y') A SFLSIZ (0004) A SFLPAG (0004) A WINDOW (FOOTER) A ROLLUP (27) A ROLLDOWN (28) A CF12 (12 'Cancel') A 50 SFLDSP A N51 SFLDSPCTL A 51 SFLCLR A 1 2'Select Option,Press enter' A 2 3'1= Select' A R FOOTER A* A WINDOW(8 31 9 43) A 8 4'F12 = Cancel' A R DUMMY ASSUME A 24 10' ' in RPG: Dow *IN12 = *Off Write Footer Fxfmt WInCTL
In case if I want to know whether a record exists in a file, which one do you prefer CHAIN or a SETLL and why ?
How to search particular records from the database file in rpg?
1.I Have a physical file , i want to read the data from the each and every member of the File in the CL Program.How do you achieve this. 2.How do you do the same in RPG?. do think is it possible to read data from all the members in the RPG?
we hav job which is running as batch. it takes atleast 06hours to complete tht job. bu i wana do tht job with in 3hours.........? so plz post ur answers
how can I tell when to replace the array?
WHAT IS MONMSG IDENTIFIER FOR STRTCPFTP command IN cl (as/400)?
Can we have a Physical file without any member ? Please let me know
1.I have a Batch job, Running for 4 hours, i want to reduce the executing time to 2 hours what should you do?
I have two sessions S1 & S2 under this 3 jobs(say j1,j2,j3 under session S1) And 2 jobs(Say j4, j5 Under session S2)is running. How many QTEMP & how many LDA will create for the same.
RPG400 
