Interested to Buy Any Domain ? << Click Here >> for more details...
can we use cl programming to update or delete physical files
- 12 Answers
- 49404 Views
- I also Faced
- E-Mail Answers
Answer Posted / anish
Although there are no keywords to update or insert or
delete records in a CL program, we can do the same with the
help of a 'RUNSQLSTM' statement. With this command we can
runa query directly from the CL program and do an
insert/update/delete without calling an RPG program.
Plzz let me know if my understanding is corerct.
| Is This Answer Correct ? | 32 Yes | 4 No |
Post New Answer View All Answers
are there any useful c runtime apis that I can call from rpg iv?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
how do I play {insert rpg system here}?
what is a rpg?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
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
can I touch the array during treatments?
How to select highest score of each subject or how to select highest income of every month?
what is file information data structure?
how does the rpg element work?
how do you use commitment control in rpg?
can you debug ile rpg program using isdb?
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 the use of sflnxtchg?
