How can you delete records form a file in rpg without
using "Delete" OPCODE?
Answer Posted / surendra y mudliar
If you want to delete all the records then you can do by
using API QCMDEXC and pass the parameter as CLRPFM.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is a record lock error?
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 would display prime numbers using CL program?
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
do you use message subfiles? What are the necessary keywords required coding a message subfile?
How to handle duplicate error handling in RPG?
what is the use of sflnxtchg?
how do I declare a minor?
how do I play {insert rpg system here}?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
what do you mean by an input subfile, what are the keywords required?
is this a rpg channel?
can I touch the array during treatments?
if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.
How to write record if no field or the field are different in physical file in rpgle ?