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 |
Looking for mainframes IMS DB training @ 9912598882
What are the advantages and disadvantages of a hierarchical database?
Define dl/i?
What is meant by mpp mode?
how do you invoke an IMS screen (coded in COOOLGEN) from a MQ transaction..... help plz?????
What is a key field in an IMS database?
What are the parameters used in CBLTDLI call?
Define pcb?
Explain the advantage of creating the acbs well ahead of time?
What is the need for a secondary index in ims?
can u tell me and give me an example : how to code a program checkpoint , restart, and tell me when and where i have to run 2 programs...Thanks
Can we use procopt on pcb and segment field (senseg)?