Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 ?

Answers were Sorted based on User's Feedback



What is SORT ? How do we eliminate duplicate records ? How do I select some records using SORT ?..

Answer / anoopkumarg

SORT is a utility(The program name maybe SYNCSORT or DFSORT)
that IBM provides which can do so many useful operations on
a flat file..like sorting the file based on a particular
condition, eliminate duplicates, extract some selective
fields into another file in the required order and the list
goes on..
To eliminate duplicates, we can use as below..
.
.
//SYSIN DD *
SORT FIELDS=COPY
SUM FIELDS=NONE
END

You can use "include condition" along with "sort fields" to
select desired records..the code goes like this..
.
.
//SYSIN DD *
SORT FIELDS=(<give sort condition here>)
INCLUDE COND=(<give the required condition here>)
END

In these cases, the SORT utility accepts one or more input
files and produces an output file which will contain the
desired records..

The IBM standard syntax of the sort command is given below..

SORT FIELDS=({begcol},{length},{fieldtype},{D|A}[,{begcol},
{length},{fieldtype},{D|A}]...)

INCLUDE COND=({begcol1},{length1},{fldtype1},{comp.oper},
{begcol2},{length2},{fldtype2})

Hope you got something from this explanation..

Is This Answer Correct ?    13 Yes 2 No

What is SORT ? How do we eliminate duplicate records ? How do I select some records using SORT ?..

Answer / prashanth

---sort is a sorting of records either in asc/ des order,
---sort field(6,10,ch,ASC) or sort field(6,10,ch,ASC),equal
sum field none
---sort field(6,10,ch,Asc) 6 is the starting position
10 record length
ch for alpnum (X)
asc order of sorting

Is This Answer Correct ?    14 Yes 6 No

What is SORT ? How do we eliminate duplicate records ? How do I select some records using SORT ?..

Answer / 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

What is SORT ? How do we eliminate duplicate records ? How do I select some records using SORT ?..

Answer / dhan

DFSORT is one of the IBM product. It is a program you use to sort,
merge, and copy the data from one file to another file.

https://youtu.be/IPDyz2xl7Tk
https://youtu.be/9311_rE9LE8
https://youtu.be/HFT9wXtoo74

Is This Answer Correct ?    0 Yes 0 No

What is SORT ? How do we eliminate duplicate records ? How do I select some records using SORT ?..

Answer / chudir vai

yes I appreciate Banchod. I also want to add another
information. Sort is also a khanki. You should always
it

Is This Answer Correct ?    1 Yes 2 No

What is SORT ? How do we eliminate duplicate records ? How do I select some records using SORT ?..

Answer / guest

sort is used to sort the data in asending or diseding order.
by using sort we can copy data from one file to another
file. by using some fields=none

Is This Answer Correct ?    4 Yes 6 No

What is SORT ? How do we eliminate duplicate records ? How do I select some records using SORT ?..

Answer / banchod

sort is nothing bt a big bal. it is used to burn others
bara. it is also the substance to hide ones gud.

Is This Answer Correct ?    1 Yes 3 No

What is SORT ? How do we eliminate duplicate records ? How do I select some records using SORT ?..

Answer / amruta

we can select by using BY variables

Is This Answer Correct ?    0 Yes 4 No

What is SORT ? How do we eliminate duplicate records ? How do I select some records using SORT ?..

Answer / jagan

# 1 ---sort is a sorting of records either in asc/ des
order,
---sort field(6,10,A,CH) or sort field(6,10,A,CH),equal
sum field none
---sort field(6,10,A,CH) 6 is the starting position
10 record length
ch for alpnum (X)
A order of sorting

Is This Answer Correct ?    1 Yes 9 No

Post New Answer

More JCL Interview Questions

When The Define Jcl Is Not Available, How Can You Get Information About A Vsam File's Organisation ?

0 Answers   IBM,


i have step1,step2,step3 from where can i start coding cond parameter ?

2 Answers   Verizon,


What is the use of symbol // in jcl?

0 Answers  


is there any possibilities for sumbitting more than one job in single jcl? if yes...based on which thing they will execute..(priority,class,time,written order..?)

3 Answers   HSBC,


I have four steps in jcl they are STEP1,STEP2,STEP3 and STEP4. Can it possible to run the reverse order like step4 first then step3,step2,step1?

4 Answers   Broadridge, HCL,


I have 10 steps, I want to run STEP1 TO STEP4 then I should not run STEP5 and STEP6. Aganin I want to execute from STEP7 to STEP10. ONLY using CONDITION CODES how can we execute this process? 1. Where we can set cond codes for STEP5 and STEP6? 2. How can we execute remaining steps from STEP7 to STEP10?

2 Answers  


a jcl has 2 steps. How to code the jcl such that if step1 abends, then step2 runs. Else, job terminates with step1?

1 Answers   IBM,


I have a input file. Data like: ABCDEFGH.... i want out put file like AB BC CD DE....How can do this??

7 Answers   UST,


diff bw vsam and normal flat file?

2 Answers   CGI,


In job processing, what happens in conversion stage?

0 Answers  


When space is allocated for an output dataset, what units can be used?

0 Answers  


what's the significance of freespace(0 0) and freespace(100 100)

3 Answers  


Categories