If a field is declared as a comp-3 field and if we want to sort a dataset based on this field, then how will the sort card be??? e.g- if we want to sort by a field which is defined as a PIC X(5) then we will mention - sort fields=(1,5,ch,a). Likewise if a field is defined as PIC S9(10)COMP-3 then in this case how will the sort field be defined (because in this case a sign is also involved)???
8 41756In a single table,How to retrieve a employee-id of an employee who works in more than one department?
15 240581.How to check for the errors using TYPRUN=SCAN?What will be the output if we give TYPRUN=SCAN?
11 48826how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
8 16185I want to increse the size of one existing dataset, can anyone tell me the TSO command throgh that I can edit it.
4 11006I 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
1 5954
what is an mdt (modified data tag)? Its menaing and use?
can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there
A table has two indexes defined. Which one will be used by the SEARCH?
What is use of IBM framework?
what would I use uni-rexx for?
What is adabas and why it is used?
Explain the significance of rdo?
What is an OOK-Rec?
What are the steps involved in access method services?
How ENQ and DEQ used in CICS?
What does db2 plan contain?
What are some uses of the evaluate statement?
Differentiate between PCT and FCT.
Explain the difference between pseudo-conversational and conversational?
What is the difference between hidam and hdam databases?