Interested to Buy Any Domain ? << Click Here >> for more details...
What is SORT ? How do we eliminate duplicate records ? How
do I select some records using SORT ?
- 9 Answers
- 37209 Views
- GE, Xansa, I also Faced
- E-Mail Answers
Answer Posted / sanjeeva reddy
Sort: Sort utility is used to sort the data in particular order(Ascending or Descending order).
Eliminate Duplicate Records:
----------------------------
//SYSIN DD *
SORT FIELDS=COPY
SUM FIELDS=NONE
/*
Select Some Records:
--------------------
You can use "INCLUDE CODITION" along with "SORT FIELDS" to
select desired records.The code goes like this......
//SYSIN DD *
SORT FIELDS=(<Give The Sort Condition Here>)
INCLUDE COND=(<Give The Required Condition Here>)
/*
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How can a stopped job be started again?
which utility is used a dummy utility?
I have a cobol db2 program(PGM A) where other program (PGM B) will call this program and passes some 50 fields data to PGM A. PGM A has some layout in which it receives the data from PGM B. And this layout has been copied in the linkage section pf PGM A. After getting the data, PGM A writes the data in a flat file in the same layout which it receives from PGM B. PGM B is a simple COBOL pgm. Please provide a JCL to run these programs.
What do you understand by the term notcat 2 – gs?
Explain how can the submitting users racf authority be overridden in a job stream?
Suppose I have five jobs to do. But I want to hold one?
Give the syntax of job specifying jcl statement.
I had Records in file Like this Company Code IBM 2 IBM 1 IBM 4 WIPRO 3 WIPRO 2 WIPRO 9 TCS 4 TCS 6 TCS 3 i want the record of every company with highest code How can i do that?
Explain the hierarchy levels in jcl?
What are the parameter we cannot use in procedure?
How jcl work to handle various input output file operations?
Suppose I have a program in cobol name ”careerride” and want to execute the program by jcl. Specify the process?
Why block size is multiple of lrecl in jcl?
We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?
What do we mean by 'Virtual storage' for a dataset and for a JOBSTEP ? What is the significance of the following statement for a programmer 'Virtual storage results in program addresses being independent of the addresses that actually exist in a computer' ?
