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
Answer / srini
Give GU call first
Then GNP call in Salary segment..
Ohooo this is enough
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between SIBLINGS and TWINS in IMS-DB database
What is the maximum number of pcbs allowed in a psb?
Hi all..., Nowadays many of the companies asking for IMS/DB , actually i hav learned mainframes but i dont have any knowledge on IMS/DB. it will be a great help if any one suggest me whr i can learn it ( in any institute).
What is secondary indexing?
In the RECON, what always sets the IC NEEDED flag on for a registered DB?
Explain the maximum number of segment types allowed for a single database?
abt ssa.purpose of ssa
What is meant by mpp mode?
What is ims (db/dc)?
What are the parameters used in CBLTDLI call?
what is the maximumm length of account information in job card of a jcl?
What is Program Isolation?