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 acbgen process?
What are the retrieval sequences in ims db?
Can we use procopt on pcb and segment field (senseg)?
What is the maximum number of segment types allowed for a single database?
What is ims (db/dc)?
Explain the disadvantage of dynamic generation of acb?
What information does a psb contain?
What are the processing modes available in ims db?
What is a segment in ims?
How many root segments do we have per database record?
Define psb?
What is the disadvantage of dynamic generation of acb?
What is acbgen process?
My IMS main progam is calling Db2 subroutine ...Its giving - 923 db2 sql code..so could any one tell how to solve this issue.
What is the need for a secondary index in ims?