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



1.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Fre..

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

1.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Fre..

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

1.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Fre..

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

Post New Answer

More RPG400 Interview Questions

suppose i i am changing / updating record of subfile and i want to change the record in reverse order . means i want to change the bottom record first and so on through readc . how i do it please any one explain .

4 Answers   CSC,


Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?

0 Answers  


how to change the length of the field in a physicalfile?

12 Answers  


WHAT IS MENT BY RECORD LEVEL IDENTIFIER ? WHAT IS THE PURPOSE OF THIS?

1 Answers  


1) How to declare a file? 2) How to define a display file? 3) How to monitor error messages in RPG? 4) How to find the attributes for subfiles? and what is the DDS for subfiles?

2 Answers   TCS,






please help me answer to this question what is the difference between the binding and srvpgm in ilerpg?

4 Answers   HCL,


i have a file with the values 10, 20, 30, 40, if am setll with the value 25 then readp, so what it will return?

6 Answers   Mind Tree,


in which journalling which attributes are necessary

2 Answers   CTS,


how do u track msg in cl pgm???

1 Answers   CTS,


How Chain operation copies the record's data to the input buffer for the program?

0 Answers   IBM,


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.

0 Answers  


3 members in a databasefile .how to read records from all the members?????????

4 Answers   CTS,


Categories