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.

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

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.

1.Are there any errors in the following statement?If so then list them.DTAARA is a data area having a field EMP # and EMPNO is a field in the file EMPPF.Which has one record. READ EMPPF IF %FOUND(EMPPF) IN DTAARA EVAL EMP#=EMPNO OUT DTAARA ENDIF

5 Answers  

---

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

6 Answers   CTS,

---

What is file identifier where we can use?

0 Answers  

---

1.The questions have given an array declaration and move operation then this statement is correct or not?

3 Answers   TCS,

---

IN RLU what are the record level keyword is used?

5 Answers   iGate, TCS,

---

how to find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.

1 Answers  

---

1.I have a Physical file with 100 records, No duplicates exists, all are Unique,But while i am running Runqry utility i am getting only 80 records..What could be the reason?

3 Answers   Cap Gemini,

---

what built in function can be used with SETLL.If you want to check whether the search argument is successful or not? Please give me answer with example?

3 Answers  

---

Can you copy the records created by the OPNQRYF to other files and how?

2 Answers  

---

Hi guys, anybody know How RPG/400 code can be converted to RPG IV code with a single command?

1 Answers  

---

Hi guys. Im in AS/400(RPGLE,CLP) from last 1 year.Now i wan to upgrade my Knowledge in AS/400. Suggest me some new fields & courses which falls under AS/400. Waiting for your quick Response.

1 Answers   Voltech,

---

program to find the number of objects used in a given program through a display.

2 Answers   IBM,

---