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 use of self join and which cases you will use this join

1 Answers   TCS,

---

How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?

3 Answers  

---

how can we write LF using flatfile.

9 Answers  

---

one physical file can have how many max of logical files? what is the primary file?

3 Answers   Four soft,

---

Why we create the Physical File Member?

5 Answers  

---

---

How many maximum record format a logical file have?

0 Answers  

---

1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?

2 Answers   IBM,

---

i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF

3 Answers  

---

How can i retrieve city while my i have one field address length 60 but i don't know what where is city in this field ?

4 Answers  

---

I want to change the attribute of field or want to add new field in existing PF but condition is format level identifier should not change, is it possible?

9 Answers   Mind Tree, TCS,

---

what is the purpus of the chain and setll and setgt ?

2 Answers   Four soft,

---

how to see number of logical files depending on a pf?...can we declare more than 20 logical files from a single pf? is it possible

4 Answers   ocbc,

---