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.
- 4 Answers
- 40252 Views
- CTS, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
what is instream data
Is Default for MSGCLASS = (1,1) ?
How to exclude the duplicate records from two concateded flat files (records from both files must be removed)?
How do you handle empty files in a JCL ?
What is the purpose of include statement in a JCL?
What is a GDG? How is it referenced? How is it defined? What is a MODELDSCB?
what sort card you will use to copy the data from one dataset to another dataset?
We have 100 steps in a procedure and we need to run the jcl and execute only 25th step in the proc and not the remaining steps. How can we do it?
5 Answers IBM, JPMorgan Chase,
How dummy is used in jcl?
In My job I have 15 procs.and in each proc i have 3 steps. i want to execute 3 step in proc 10.is it possible? if possible how?
How I sort the records in a file and copy the first 10 records to another file
Is there a way to check for an empty file in JCL other than using IEBCOMPR and the command PRINT COUNT(1)?
COBOL 
