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 are the disadvantages of a hierarchical database?
Which languages does ims support / application program languages?
How many sgment types can u have in a DL/I database?
Can we give the GSAM-PCB in between the DB-PCB'S like below? I/O-PCB DB-PCB1 GSAM-PCB1 GSAM-PCB2 DB-PCB2
Define DBD?
Define ims (db/dc)?
Explain ims software environment?
What are Twins?
Can a variable length segment be declared in IMS? If yes, what is the structure; If no, why?
I am totally confused on IMS message segments. When I create a message and it contains 5 segments does the entire message have a 32k limit or does each segment have a 32k limit? Is there a setting in the stage1 sys gen that defines if a transaction can receive/send multi-segmented messages?
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 meant by batch dl/i mode?