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 ?

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


Please Help Members By Posting Answers For Below Questions

What are the difference between jcl and jes?

1554


what happens in conversion stage in job processing?

1181


Is it possible to define dd statements as you want?

1076


Define concatenating?

1058


List the various advantages of using jcl language?

1399


Can I send output of job to my remote device careerride123?

1089


what are JCLLIB and STEPLIB in JCL?

1120


What is the purpose of dd dummy statement?

1421


What is the use of disp parameter?

1089


Is their any set of rules for dd? Explain.

1119


What is the significance of addrspc parameter in exec statement?

1154


Is their any limit for data sets?

1138


Explain how can a stopped job be started again?

1095


How do you access an uncatalogued dataset in a jcl?

1173


What is the function of //jcllib statement?

1281