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.
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 |
check existence of one record without using chain or read?
what is kids-rpg?
HOW TO DELETE THE RECORD FROM MASTER FILE WHICH IS LINK BY ANOTHER TRASATION FILE WITH REFERTIAL INTYGRITY?
What will be your approach in going either for OPNQRYF or Logical files. Which one to go for?
Let?s consider a variable X of length 20. Move value ?ABC? to it.How to determine how many characters does X have?
Can any body give the code for this quesition? Using the following details write C-Spec code to set Name to"AMMU LABS SYSTEM" D NAME1 S 10 INZ('AMMU') D NAME2 S 10 INZ('LABS') D NAME3 S 10 INZ('SYSTEM') D NAME S 20
Mr.Sidc sirfor my question{how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE} you have answered using MOVE opcode,can you illustrate me with a small example sir very kind of you.
what is edit word and edit code
1.Are there any errors in the following statement?If so then list them.DTAARA is a data area having a field EMP # and EMPNO is a field in the file EMPPF.Which has one record. READ EMPPF IF %FOUND(EMPPF) IN DTAARA EVAL EMP#=EMPNO OUT DTAARA ENDIF
What hapens when we use CPYF command to copy a LF? On which PF will it be dependent???
How do I link an existing logical file to it's Physical File without recompiling?
please help me answer to this question what is the difference between the binding and srvpgm in ilerpg?