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 Posted / srini
Give GU call first
Then GNP call in Salary segment..
Ohooo this is enough
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the disadvantage of dynamic generation of acb?
What is psb?
What is the maximum number of segment types allowed for a single database?
Explain the maximum number of fields allowed per segment and what is the maximum number of fields per database?
What is a segment in ims?
What are the retrieval sequences in ims db?
Explain dbdgen process?
What do you mean by hierarchical database?
What are the objectives of dbms in ims?
What is meant by bmp mode?
What is the disadvantage of dynamic generation of acb?
Define psb?
Explain the processing modes available in ims db?
My IMS main progam is calling Db2 subroutine ...Its giving - 923 db2 sql code..so could any one tell how to solve this issue.
Explain the two ways in which dl/i interface can be invoked?