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 |
An application programmer comes to you and says your DB is no good, they got an II status code on an insert call from IMS, is this a DB problem?
What is bmp mode?
Explain the maximum number of pcbs allowed in a psb?
What is a segment?
Is it necessary that all the segments in a Dl/i database have key fields ?
What information does a dbd contain?
What is mpp mode?
Explain the advantage of creating the acbs well ahead of time?
What is the maximum number of levels allowed in ims db?
Which is the DL/I function used in CICS-IMS program? IBM
What is dbms in ims?
What is meant by batch dl/i mode?