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 |
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 .
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?
how to change the length of the field in a physicalfile?
WHAT IS MENT BY RECORD LEVEL IDENTIFIER ? WHAT IS THE PURPOSE OF THIS?
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?
please help me answer to this question what is the difference between the binding and srvpgm in ilerpg?
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?
in which journalling which attributes are necessary
how do u track msg in cl pgm???
How Chain operation copies the record's data to the input buffer for the program?
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.
3 members in a databasefile .how to read records from all the members?????????