suppose if we want to update the data in cl what we will do?
Answer Posted / surya siram
Normally we cannot update the data in physical file by using CL program, But by using RUNSQLSTM or RUNSQL commands we can run the sequel to update the data in physical files.
But we can update the data in display file using SNDRCV command
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is *place and *auto keyword in prtf ?plz explain
How can we override a file during runtime in rpg?
When it is desirable to describe files Internally?
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 Chain operation copies the record's data to the input buffer for the program?
What is the purpose of record level identifier?
what is an online rpg?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
How to write record if no field or the field are different in physical file in rpgle ?
what was the robotech rpg?
what is the necessary keyword needed to scroll subfile records?
What is the difference between copybooks and subprocedures in as400?
how can I tell when to replace the array?
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?
How to call one program from another program in RPG? please help me with the code