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

Please help me, I have created window subfile,I have created Footer with same lengh and postion of window SFL. When I call the pgm, first is shows only Footer and then it shows subfile records.This time Footer is not showsing ..plz hel me how can i do it...? Sameple DDS and RPG: A R WIN1 SFL A*%%TS SD 20090130 165346 MUNSHIJ REL-V4R2M0 5769- PW1 A FLD001 1Y 0B 4 3EDTCDE (Z) A ATFILE R O 4 7REFFLD (QWHFDBAS/ATFILE LIB/LIBF- A ILE) A R WINCTL SFLCTL (WIN1) A*%%TS SD 20090202 123459 MUNSHIJ REL-V4R2M0 5769- PW1 A ALTNAME ('y') A SFLSIZ (0004) A SFLPAG (0004) A WINDOW (FOOTER) A ROLLUP (27) A ROLLDOWN (28) A CF12 (12 'Cancel') A 50 SFLDSP A N51 SFLDSPCTL A 51 SFLCLR A 1 2'Select Option,Press enter' A 2 3'1= Select' A R FOOTER A* A WINDOW(8 31 9 43) A 8 4'F12 = Cancel' A R DUMMY ASSUME A 24 10' ' in RPG: Dow *IN12 = *Off Write Footer Fxfmt WInCTL

2 Answers  


1.How to read a subfile in out put mode? 2.what are the keywords used to share same file? 3.using composite key which rpg code used?

3 Answers   HSBC,


How can we call CL program to RPG? How many number of parameter we can pass

2 Answers   TCS,


how do I play {insert rpg system here}?

0 Answers   IBM,


What is Multi Occurrence Data Structure(MODS)?

1 Answers   CTS,






wat is the difference between array and multiple occurence data structure?

4 Answers   Four soft,


How do I read records from Subfile? what is the purpose of READC explain with example?

4 Answers   IBM,


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  


In how many ways a session/device error occurs,,, and what is the remedy for it?

3 Answers  


WHAT IS MEANT BY SIGNATURE VAILOTION ERROR

1 Answers   IBM,


how do I preserve and clean the array?

0 Answers   IBM,


Explain mdt?

0 Answers  


Categories