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 |
how can we find setll setgt chain read reade readp operations are successfull or not,give example.explain in detail.
What is the compilation option that has to he specified while compiling an RPC program which uses a file having date data type field?
suppose we have 10 members in physical file and i have to use 4 out of 10 so how can we read this in RPG
Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?
parameters cannot be passed in which one???
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
How can a screen field that has changed since the last output operation be detected?
how we create binder member for updating service program and where we type this code on command line or in program ? strpgmexp pgmlvl(*current) export symbol (xyz0 endpgmexp. plz explain me this step by step .
How to call one program from another program in RPG? please help me with the code
how to change the length of the field in a physicalfile?
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?
Can anybody tell me the setps to create .csv file in IFS folder on AS/400. I also need to know how I can send this .csv file to PC in xls sheet.....?