Interested to Buy Any Domain ? << Click Here >> for more details...
1.What is referential Integrity?
2.What is Foreign Key?
3.What is Transfer Control?
4.What is Free format?
- 3 Answers
- 8314 Views
- I also Faced
- E-Mail Answers
Answer Posted / manoj
1. Referential integrity maintains the integrity of a
database using key fields. Referential integrity is defined
as "the state of a database in which all values of all
foreign keys are valid"
2.A foreign key is a column or a set of columns in a table
whose values must match at least one primary key or unique
key value of a row in its parent table.
3.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
which program rpg or cl is efficent to update a transaction onto a database file and why ?
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 ment by record level identifier?
what is the use of sflnxtchg?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
How to handle duplicate error handling in RPG?
How to write record if no field or the field are different in physical file in rpgle ?
What are the types of identifiers?
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 do I preserve and clean the array?
What is a record lock error?
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
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.
explain sflclr, sflend, sfldlt, and sflcsrrrn?
We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?
