1.What is referential Integrity?
2.What is Foreign Key?
3.What is Transfer Control?
4.What is Free format?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / syam
This is Free Format in ILERPG
/Free
If
Uokoa<>0;
*In50 =
*On;
Endif;
If Udatu >= Todt And Udatu <=
Date;
If Uaspl <> 29 And Uaspl <> 79 And Uaspl <> 91 And
Uaspl <> 48;
If *In50 =
*off;
ExSr
Proces;
EndIf;
EndIf;
EndIf;
/End-
Free
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / david lex
3. TFRCTL (Transfer Control) is a control language command
which 'hands off' execution to the program listed as the
receiving program.
Once this happens, the original program drops from the call
stack and can not be returned to.
Hence, ANY code following a TFRCTL is wholly skipped,
unless some type of flow control is designed in the program
which could possible skip the TFRCTL.
| Is This Answer Correct ? | 1 Yes | 0 No |
Need a sql query: retrieve all duplicate records in table?
How to print output from openquery in as400 ?
what is ment by "MDT"
Can we trigger an rpg program which has user interaction with display file when updating a file using the command ADDPFTRG?
How to get only unique records from a file which contains duplicate data using CPYF command ? Example : FILEA has duplicate records and FILEB is a UNIQUE defined.... and I want to get the data from FILEA to FILEB by eliminating all the duplicate records...
How to declare the more than one file in cl/400.
Hi, I am getting the error in RPG (All Record Formats for externally-described file ABCD ignored or dropped due to error; file ignored.) Please suggest any
wat is the difference between array and multiple occurence data structure?
How can we make use of SETLL operation in CL?
while i am using the dspmsg command on comman line in Mocha am getting error like Not authorized to message queue message my messagequeue Name? can anybody help me how to change my message queue Am anable to see my messages in message queue
Write a program to display prime numbers between 1 to 100 using RPGLE.
How would display prime numbers using CL program?