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...

wht r different types of sort fields in jcl ?

Answer Posted / pullareddy

1. SORT FIELDS=COPY ===> To copy all the records from
SORTIN to SORTOUT.
2. SORT FIELDS=COPY,SKIPREC=100,STOPAFT=5 ===> TO copy the
records from 100 to 105.
3. SORT FIELDS=(STARTPOS,LENGTH,TYPE,ASC/DESC) ===> TYPE
can be: ZD(zoned decimal), CH(Charecter),BI(Binary),PD
(Packed decimal), and FS(Signed numbers).
4. INCLUDE COND=(STATPOS,LENGTH,TYPE,RO,VALUE) EX: INCLUDE
COND=(1,5,CH,EQ,C'PULLA) ===> To select the paticlular
record. same as above to omit the record replace INCLUDE
with OMIT.
5. INREC FIELDS=(15,5,6,6) ===> to restructure the input
file before feeding to sort.
6. OUTREC FIELDS=(1:1,20,21:C'PULLA',26:10Z,36:21,10) ===>
First 20 chars from input file followed by character PULLA
followed by 10 zeros followed by characters from 21 to 10
characters of input. the same can be codded as bellow.
OUTREC FIELDS=(1,20,C'PULLA',10Z,21,10).
7. SORT FIELDS=(1,5),EQUALS
SUM FIELDS=NONE ===> TO remove the duplicates in the key
field(1,5).

Is This Answer Correct ?    47 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to pass data to a program that is coded in an exec statement?

1271


how can you check if a file is empty using jcl?

1349


Must tape dataset definitions include vol=ser specifications?

1651


What statement marks the beginning of an in-stream or cataloged procedure in jcl and assigns default values to parameters defined in the procedure?

1250


what is the resolution for sb37 error

8953


Explain the job statement in jcl?

1112


1) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat

7715


What is the difference between run mode and addressing mode?

1161


List the different jcl statements that are not permitted in the procedures?

1027


What is the significance of addrspc parameter in exec statement?

1147


I have many files which i am receiving from client everyday. I have one step for every file to check for empty or not. Here client gives 30 files i need to check for every file for empty or not and i need to perform 30 steps. Can I do it in single step. Dynamically i need to change the File name in my step.

1172


How to find the UNIT and VOLUME of a (a) KEPT (b) UNCATALOGED and (c) CATALOGED dataset - using (i) JCL and using (ii) ISPF ?

2620


what sort card you will use to copy the data from one dataset to another dataset?

1141


Explain how can a stopped job be started again?

1083


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

1082