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 39165In a single table,How to retrieve a employee-id of an employee who works in more than one department?
15 187381.How to check for the errors using TYPRUN=SCAN?What will be the output if we give TYPRUN=SCAN?
11 44465how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
8 13673I want to increse the size of one existing dataset, can anyone tell me the TSO command throgh that I can edit it.
4 9528I 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 5175
How can you count the number of rows from a table tab?
SET is the ANSI standard for variable assignment, SELECT is not. SET can only assign one variable at a time, SELECT can make multiple assignments at once. If assigning from a query, SET can only assign a scalar value. If the query returns multiple values/rows then SET will raise an error. SELECT will assign one of the values to the variable and hide the fact that multiple values were returned (so you'd likely never know why something was going wrong elsewhere - have fun troubleshooting that one) When assigning from a query if there is no value returned then SET will assign NULL, where SELECT will not make the assignment at all (so the variable will not be changed from it's previous value) As far as speed differences - there are no direct differences between SET and SELECT. However SELECT's ability to make multiple assignments in one shot does give it a slight speed advantage over SET.
Define the term mro (multi region operation)?
How is a type of file defined in the jcl that executes the cobol program?
What is house keeping in assembler?
What is the output of the following command given in tso/ispf terminal?
can any one exaplin about Decision Tables in test region with good example
Comment whether the cursor is closed during commit or not.
Suppose I want to code a rexx program in order to get the inputfile and output files of jcl. I want code snippet or the coding for this?
which utility is used to sort a file in jcl?
Explain how do you terminate an already issued delay command?
What is the maximum length of sqlca?
What is the difference between ooRexx and IBM's Object REXX for Windows?
What is meant by bmp mode?
For protecting a transaction using the transaction security function, the two things that must be done are?