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


Please explain with syntax and an example, the Inrec fields
and Outrec build in sort.

Answers were Sorted based on User's Feedback



Please explain with syntax and an example, the Inrec fields and Outrec build in sort...

Answer / sviakumar

Inrec is one type of sorting which selects first and then
sorting.but in case of OUtrec is entirly reverse of Inrec
(i.e., first sorting and then select )

Is This Answer Correct ?    23 Yes 3 No

Please explain with syntax and an example, the Inrec fields and Outrec build in sort...

Answer / sharath

INREC
-----
A typical use of INREC is listed below with example,
//STEPXXX EXEC SORTD
//SYSPRINT DD SYSOUT=*
//SORTIN DD DSN=XXXXXXX.NAME.FILE,
// DISP=SHR
//SORTOUT DD DSN=XXXXXXX.NAME.COUNT,
// DISP=(NEW,CATLG,DELETE),
// SPACE=(CYL,(400,200),RLSE),
// UNIT=SYSDA,
// DCB=(RECFM=FB,LRECL=14,BLKSIZE=0)
//SYSIN DD *
INREC FIELDS=(1:1,10,11:C'0001')
SORT FIELDS=(1,10,CH,A)
SUM FIELDS=(11,4,ZD)
/*

Here suppose 1 to 10 is NAME field then you insert a number
from 11 to 14 for every name field. Finally your aim is to
count the number of records having same NAME.

OUTREC
------
Reverse basically. Syntax below
//STEPXX EXEC SORTD5
//SORTIN DD DSN=XXXXXXX.FILE1,
// DISP=SHR
//SORTOUT DD DSN=XXXXXXX.FILE2,
// (NEW,CATLG,DELETE),
// UNIT=SYSDA,SPACE=(CYL,(800,200),RLSE),
// DCB=(LRECL=31,BLKSIZE=0,RECFM=FB)
//SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,10,11:C'0001')

Here you insert 0001 for all values of output file at 11th
place.

Is This Answer Correct ?    13 Yes 5 No

Please explain with syntax and an example, the Inrec fields and Outrec build in sort...

Answer / cd

In most cases INREC and OUTREC statements can be used
interchangeably..

The difference between them is more of a performance issue
than anything else.

For Example:

INPUT
------

Name Regn. No. School ADDRESS
____ _________ _______ __________________________

DINA 1657565511 SSV sadadadadadadadadadadadada
EALA 1264546461 SADADADA ddwaedsagfdsdsadadagfdsdsw
ARUN 1214231211 DADARDCA kjhdsakjhgkjdagtsagdsakjhd
SUDA 1212121211 DRADS kiyeakjhsdakjgdajgshaskgsa
RINI 1275655345 AFAASFAF kadhlkjdabgsagkjashksaoksa


Assume, you want to have the sorted names of the people from
this file in the output.

What Inrec would do:

//SYSIN DD *
SORT FIELDS=(1,4,CH,A)
INREC FIELDS=(1,4)
/*


Step 1.

Name
____
DINA
EALA
ARUN
SUDA
RINI

Step 2.

Name
____
ARUN
DINA
EALA
RINI
SUDA


If outrec was used, the steps 1 and 2 would be reversed.


thanks

Is This Answer Correct ?    4 Yes 2 No

Please explain with syntax and an example, the Inrec fields and Outrec build in sort...

Answer / cd

step 1:

Name Regn. No. School ADDRESS
____ _________ _______ __________________________

ARUN 1214231211 DADARDCA kjhdsakjhgkjdagtsagdsakjhd
DINA 1657565511 SSV sadadadadadadadadadadadada
EALA 1264546461 SADADADA ddwaedsagfdsdsadadagfdsdsw
RINI 1275655345 AFAASFAF kadhlkjdabgsagkjashksaoksa
SUDA 1212121211 DRADS kiyeakjhsdakjgdajgshaskgsa

Step 2.

Name
____
ARUN
DINA
EALA
RINI
SUDA


hth

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More JCL Interview Questions

Can we use COND=EVEN on a job card, when jobs are scheduled through scheduler?

1 Answers   L&T,


in a jcl, a large volume dataset is loaded to a table using bmcload in step1 and an image copy of the loaded table is taken using bmccopy in step2. Step2 abends because the image copy dataset cannot hold the volume of the table. How can this be rectified?

0 Answers   IBM,


why jobstep can't be more than 255 and for GDG has max limit 255 . Is there any relation between the two

1 Answers   IBM, Perot Systems,


When concatenating two PDS can any one PDS can have empty dataset i.e without any value(Dummy).

2 Answers  


What are three parameters you can specify on Job statement as well as on exec stmt ?

1 Answers  


I have GDG defined e.g. GDG.smaplegdg.base, after processing the GDG. it contains some records and which is input to the second step2. How can I use GDG to use it as input file at step2.

3 Answers   Wipro,


Is automatic restart possible in jcl? If yes, how?

0 Answers  


If the COND parameter is specified in both the JOB and EXEC statements, which one will take precedence? If JOB takes priority and if all the conditions evaluate to false, then will the conditions on the EXEC step be evaluated next?

4 Answers   Wipro,


what is the function of spool command?

4 Answers  


What does S0C4 error mean?

8 Answers  


How many JOB statements a JCL can have ? If there are more than one JOB statements in a JCL, are they submitted in succession or in parallel ?

4 Answers   IBM, Tech Mahindra,


how to compare two datasets without using superce because output is limited to 133 bytes

0 Answers  


Categories