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
- 8324 Views
- I also Faced
- E-Mail Answers
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 |
1.I Have a physical file , i want to read the data from the each and every member of the File in the CL Program.How do you achieve this. 2.How do you do the same in RPG?. do think is it possible to read data from all the members in the RPG?
I have to change a program. This program is calling a subroutine mor than 100times within it. so will it have any performance issue? if yes than what changes i can make. Thanx for ur valuable answer.
how do u find whether a record is locked or not??
1..Write an sql query to find the employee name who is having 2 phone numebr? 2.Write an sql query to the the second highest salary of the employee?
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 read a particular record from the database file which is not having DDS (Flat File). For example, there are 100 records in the flat file. How can we retrive 15th record in RPG/400 program (Without using CL)
Why did we give STRSRVJOB while debugging batch program
Can we journel logical file and access path? Can we use commitment control for non-join L.F?
can any body correct the following code? Following a procedure which returns the maximum of two numbers.Correct the following code. P GETMAX B D GETMAX PI D NUM1 35 0 D NUM2 45 0 C IF NUM1 > NUM2 C RETURN NUM1 C ELSE C RETURN NUM2 C ENDIF P GETMAX E
How to update selected fields from pf without using update opcode. How to read all member in Rpg-3,without using any cl command?
Why we cannot call a service program? If I add a PEP can i call the service program?
What is the difference between inner join @ outer join
RPG400 
