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 41821In a single table,How to retrieve a employee-id of an employee who works in more than one department?
15 241861.How to check for the errors using TYPRUN=SCAN?What will be the output if we give TYPRUN=SCAN?
11 48924how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
8 16245I want to increse the size of one existing dataset, can anyone tell me the TSO command throgh that I can edit it.
4 11050I 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 5970
Explain difference between escape(top or bottom) and escape immediate(top or bottom?
What are the different versions of gdg named?
What is the use of reorg in db2?
what is the difference between a package and a plan. How does one bind 2 versions of a cics transaction with the same module name in two different cics regions that share the same db2 subsystem?
Explain the job statement in jcl?
What is buffer pool?
What is a bind card?
what are transient data sets defined to cics?
What is db2 stogroup?
what is the size of the address space in kbs for 16 bit address space?
What are the contents of dclgen?
What is dpf in db2?
is it required that primary key values have to be unique? Do alternate key values have to be unique?
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?
Mention the types of job control statements?