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 )

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.

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

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

Please go thru the below points and let me know how to code this. 1. Sort the input dataset for the condition : Starting position is 37,length of the field is 13 based on character and in the ascending order , starting from position 25 length of 12 ,character and in the ascending order. Use a temporary dataset to hold the sorted file. 2. Use the temporary file created in the above step as the input for the next step. The next step is to execute a program and produce an output file. Use the temporary file created in the above as work file 1 and the output of the file to be created in this step work file 2.Also, pass a parameter to the program that is to be executed in this step. The parameter should have the current date in YYYYMMDD format. For the sake of convenience, you can use the below Job Name : Sample1 Input DSN : PCABDT11.CABD.TEST.INPUT Temporary DSN : Sort1 Output DSN : PCABDT11.CABD.TEST.OUTPUT Program Name : SAMPLE Thanks in Advance for your response.

2 Answers  

---

wt will happen to the step of a job if u code COND=ONLY

5 Answers   ADP,

---

what EXEC statement is and what is the syntax of EXEC statement used in JCL?

0 Answers  

---

In one of intervie, my interviwer asked, I have a file which contains 4 records I would like to split the 4 different outputs for each record how to do?

14 Answers   Cap Gemini, Cognizant, JPMorgan Chase, TCS, Xansa,

---

restart logic ?

2 Answers   TCS,

---

What is the meaning of keyword in JCL? What is its opposite?

1 Answers  

---

. What is the difference between the following statements : I) step#1 exec PGM=accpay ii) step#1 exec tbalance

1 Answers  

---

GDG Create syntax ?

4 Answers   Xansa,

---

Can you execute a PROC from another PROC?

8 Answers   Keane India Ltd,

---

A file has dta in S9(09) COMP format. How do I move the data into a character field X(10)?

2 Answers  

---

what is A-MODE and R-MODE?

2 Answers  

---

i have 1000 records in input file and i want to sort it and the first 200 records to be placed in output file. how to do that??

14 Answers   L&T,

---