How man key fields and search fields can a segment have?
Answers were Sorted based on User's Feedback
Answer / karan
A segment have only one key field and as many as search
fields can be written.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / s
Each segment can have only one Key field or sequence field.
Upto 5 fields can be put as search fields.
Key field can be a search field.
| Is This Answer Correct ? | 0 Yes | 2 No |
What are qualified and unqualified SSA's.
What is a Root?
How many PCB?s can be coded within a PSB?
What is the need for a secondary index in ims?
What is the difference between HDAM & HIDAM DB types and when would you use each?
What is mpp mode?
What information does a dbd contain?
What type of pointers should you specify on the root segment of a HIDAM DB to improve sequential processing?
How to write the PCB code ? if in thic PCB i have 3 PSB ?
What is dbd?
how do you bind the cobol with db2
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