Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO DELETE THE RECORD FROM MASTER FILE WHICH IS LINK BY
ANOTHER TRASATION FILE WITH REFERTIAL INTYGRITY?
- 1 Answers
- 5993 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / maheshg
Delete the record from dependent file where it has
REFERTIAL INTYGRITY then delete the record from master
file.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
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.
How can we override a file during runtime 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 file identifier where we can use?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
How would display prime numbers using CL program?
How can we know running job is batch or interactive?
what is program status data structure?
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?
What is the purpose of record level identifier?
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
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
What is difference between bind by copy and bind by reference?
are there any useful c runtime apis that I can call from rpg iv?
