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
- 9615 Views
- iGate, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is the use of sflnxtchg?
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.
what is file information data structure?
Q:HI friends accually ihave one problem plesase let me know the alternate code of this code. Related field description of code: Add a field, CALvsPRD, "Calendar Day Starts Before/After Production Day" to the parameter set WRKORDER which accepts values 'A' or 'B' o B = Calendar Day Starts Before Production Day o A = Calendar Day Starts After Production Day o Any other value indicates the production and calendar dates are always the same. code: Automatic Execution Of *INZSR Subroutine /Z01 * retrieves WRKORDER field values. /Z01 * Calculate default Production Date and return it to caller. /Z01 * Production date defaults to system date /Z01 C Eval P@Pdate = %DATE() /Z01 * unless Calendar date starts Before PDN(production) date and /Z01 * system time is before PDN Start Time then /Z01 * PDN date is yesterday. /Z01 C If W@CALvsPRD = 'B' and /Z01 C %TIME() < %TIME (W@Strtime) /Z01 C Eval P@Pdate -= %Day(1) /Z01 * unless Calendar date starts After PDN date and /Z01 * system time is *GE PDN(production) Start Time then /Z01 * PDN date is tomorrow. /Z01 C ElseIf W@CALvsPRD = 'A' and W@Strtime > *Zero and /Z01 C %TIME() >= %TIME (W@STrtime) /Z01 C Eval P@Pdate += %Day(1) /Z01 C EndIf /Z01 C Eval *InLr = *On
how can I tell when to replace the array?
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?
Interviewer asked me write down DDS for load all subfile .can anybody write dds
what is data area and how it is used in rpg program ?
How to write record if no field or the field are different in physical file in rpgle ?
how do I declare a table or array in rpg iv?
What are the types of identifiers?
what is the procedure and explain about real time scenario.
What is a record lock error?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
what is kids-rpg?
