Answer / venkat

1. File exception
e.g. Undefined record type or a device error, Record lock, Update operation attempted without a prior read
2. Program exception
e.g. Divide by zero, array index out-of-bound, Invalid Date, Time or Timestamp value.


We can see all the program/file related system messages using the command below:
DSPMSGD RANGE(*FIRST *LAST) MSGF(QRNXMSG) DETAIL(*BASIC)

what is the difference between adding keys & constraints into a phisical file

4 Answers   HSBC,

---

what is general and type of general

1 Answers   Active Brains,

---

I have a PF with out any data but the dependent LF is having data?

1 Answers   HCL,

---

What is the interactive job? What is the batch job? How to change the batch job to interactive job?

1 Answers  

---

Why journalling is compulsory before commitment control?

1 Answers  

---

what is multiple member pf

1 Answers   Active Brains,

---

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...

6 Answers   ABC, TCS,

---

how to restrict upon adding the data for field reference file in DB400

1 Answers  

---

If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.

2 Answers  

---

How to know the particular record in pf with out reading?

1 Answers  

---

what is the difference between adding keys & constraints into a phisical file

6 Answers   HSBC,

---

How to retrieve a physical file after deleting that?

1 Answers  

---