Hi Viewers can any body explain me how to update and ahange
the already existed data in physical file using subfile ?
please explain me with the code if possible?
Answer Posted / dx
first read all records from physical file and move to subfile
then read change records from subfile format by opcode READC
in loop it will work
eg- readc sfl 56
*in56 downe *on
move dspfile physical file
updat sfl
enddo
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How to handle duplicate error handling in RPG?
what is the necessary keyword needed to scroll subfile records?
what was the robotech rpg?
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
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...?
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
what is the use of sflnxtchg?
is this a rpg channel?
What is the difference between iter and do?
write an RPG program to calculate the marks of 5 students (A,B, C, D, E)in 3 different subjects (eng, math, sci) an display on the screen
which program rpg or cl is efficent to update a transaction onto a database file and why ?
how do I play {insert rpg system here}?
what is kids-rpg?
are there any useful c runtime apis that I can call from rpg iv?
How Chain operation copies the record's data to the input buffer for the program?