How can you delete records form a file in rpg without
using "Delete" OPCODE?
Answer Posted / syam
Hi Kumar...Not SQL.....directly from RPG program
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the necessary keyword needed to scroll subfile records?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
What is the difference between iter and do?
How many program bind in one module....
How to handle duplicate error handling in RPG?
how do I declare a minor?
How to write record if no field or the field are different in physical file in rpgle ?
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 to select highest score of each subject or how to select highest income of every month?
How to call one program from another program in RPG? please help me with the code
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
how does the rpg element work?
can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com
When it is desirable to describe files Internally?
what is the use of sflnxtchg?