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 41801In a single table,How to retrieve a employee-id of an employee who works in more than one department?
15 241281.How to check for the errors using TYPRUN=SCAN?What will be the output if we give TYPRUN=SCAN?
11 48877how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
8 16220I want to increse the size of one existing dataset, can anyone tell me the TSO command throgh that I can edit it.
4 11031I 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 5967
How many databases are there?
Explain the difference between start and xctl?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What does EIB mean in CICS?
What is an ook-rec in idms?
Whats the difference between search & search ALL?
Why select is not preferred in embedded sql programs?
How many module come in Ibm framework?
What is access path in db2?
Mention the definition of cobol in varchar field.
Define db2.
What is a db2 cursor?
I have to write to a outfile where the number of records in that file should be the header of that file using IMS.. can anyone help me in this issue
Can you explain multitasking and multithreading?
What is alias in db2?