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 41475In a single table,How to retrieve a employee-id of an employee who works in more than one department?
15 235231.How to check for the errors using TYPRUN=SCAN?What will be the output if we give TYPRUN=SCAN?
11 48390how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
8 15895I want to increse the size of one existing dataset, can anyone tell me the TSO command throgh that I can edit it.
4 10858I 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 5879
List out the three types of page locks that can be held.
What is the use of trt instruction?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
what is utility for parm lib
Explain how do you set the mdt option to on status, even if data is not entered?
How is next sentence and continue different?
How joinkeys helps in sort?
Immediate Job opening for mainframe professionals in Keane Bangalore. Please find the below details: Organization: Keane India Location: Bangalore Skill: COBOL, JCL,VSAM,DB2,CICS,IMS,REXX,CLIST Exp: 1 to 4 years only Employment Type: Permenant Employee Note: If you have attended keane interview in past 6 months please ignore this job opening. Please respond to email id keanemfjob@gmail.com OR keanemfjob@yahoo.in with your latest resume and following details, We will contact you within 24 hours: Total IT Exp: Exp in Mainframe: Current CTC: Expected CTC: Notice Period:
Explain how do you control cursor positioning?
Can you tell me how can you find out the # of rows updated after an update statement?
What is declare cursor?
Explain the mdt in cics?
How can values be passed from the job stream to an executable program?
Explain cemt transaction commands?
What is Pic 9v99 Indicates in COBOL?