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 type of pointers should you specify on the root segment of a HIDAM DB to improve sequential processing?
What is the maximum number of levels allowed in ims db?
Define pcb?
What is a Segment type?
Is it necessary that the key field in a Dl/I database be unique?
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 are the command codes and their purposes?
Can we use procopt on pcb and segment field (senseg)?
What is the disadvantage of dynamic generation of acb?
What is hierarchical database?
What are the valid recovery points?
What is dl/i?