I have PCB with structure: PCB TYPE=DB, C DBDNAME=EMPCADBD, C KEYLEN=18, C PROCOPT=LS SENSEG NAME=EMPLOYEE, C PARENT=0 SENSEG NAME=COMPDTL, C PARENT=EMPLOYEE SENSEG NAME=BANKDTL, C PARENT=COMPDTL SENSEG NAME=SALDTLS, C PARENT=BANKDTL SENSEG NAME=EDUCDATA, C PARENT=EMPLOYEE SENSEG NAME=EMERDETL, C PARENT=EDUCDATA SENSEG NAME=ADDRESS, C PARENT=EMPLOYEE ************************************************************ *********** PSBGEN PSBNAME=PSBCALDP,LANG=COBOL END Requirement is to Create a report based on Salary brackets. ( Use SSA’s for logic) · It should have CTCGROSS brackets and No of employees o Employee names falling in each bracket Salary < 100,000 No of Employees Employee-Name Level 100,000 < Salary < 300,000 No of Employees Employee-Name Level 300,000 < Salary No of Employees Employee-Name Level

1 Answers   Accenture,

---

Static & Dynamic PSB

2 Answers   IBM,

---

What is the maximum number of fields allowed per segment and what is the maximum number of fields per database?

0 Answers  

---

Explain the disadvantage of dynamic generation of acb?

0 Answers  

---

What is mpp mode?

0 Answers  

---

What is batch dl/i mode?

0 Answers  

---

What are the main control blocks available in ims db?

0 Answers  

---

What are two reasons to run the DB Batch backout utility?

4 Answers  

---

What are the two types of fields available in ims db?

0 Answers  

---

What do you mean by hierarchical database?

0 Answers  

---

Which DB access method (OSAM or VSAM) is better and why?

4 Answers  

---

What is secondary indexing?

4 Answers  

---