Nandhakumar

• Nov 19th, 2018

Start is used to read a file dynamically (Some where in between the file), so its not needed for sequential read from end of the file. Moving High-values to Key field would absolutely work.

Premasai

 Profile Answers by Premasai Questions by Premasai

• Jun 12th, 2010

I dont think moving HIGH-VALUES will take you to the last record , as you need to access the record for which the key value is <= HIGH VALUES. And START KEY syntax does not allow you to search a ke...

Answer Question  Select Best Answer

Hi,I have a file which contains 3 types of transactions with account number,transaction type and transaction creation date.The transaction types are 35,39 and 41.The file has duplicate records for all transactions(ie 2 records for each account number for each transaction).Now I need to remove the duplicate for the 39 type transaction alone and keep the remaining.That is only for the transaction type...

manikanta

• Feb 15th, 2019

We can do it by ICETOOL by selecting the firs duplicate row only and rest of the rows based on the transtion type it will not copy.
SELECT FROM(IN) TO(OUT) ON(starting post,length,CH) USING(CTL1) FIRST - it will copy the first records only.

Rishu

• Jul 31st, 2014

It is not possible to do it in single SORT step. 2 steps are required. First, extract all 39 type transaction record using EXCLUDE statement. Second, remove duplicate from step 1 file with SUM FIELDS=NONE. Third, merge output from step1 and 2.

Answer Question  Select Best Answer

how do you create a new VSAM file with null record as header with JCL please provide me with coding

sai

• May 31st, 2019

USE PGM=IEBDG in JCL. Copy the Dummy file to VSAM using Repro

Answer Question  Select Best Answer

Explain with example?

Read Best Answer

Editorial / Best Answer

jjtharappel  

 Profile Answers by jjtharappel Questions by jjtharappel

• Member Since Nov-2011 | Nov 24th, 2011

---

Run a JCL with the below sort step

Code
//STEP1    EXEC PGM=SORT                             
//SORTIN   DD DSN=input-file-name,DISP=SHR          
//SORTOF01 DD DSN=output-file-name-1,          
//            DISP=(NEW,CATLG,DELETE),               
//            SPACE=... 
//            LRECL=...,RECFM=FB     
//SORTOF02 DD DSN=output-file-name-2,          
//            DISP=(NEW,CATLG,DELETE),               
//            SPACE=... 
//            LRECL=...,RECFM=FB                     
//SORTOF03 DD DSN=output-file-name-3,          
//            DISP=(NEW,CATLG,DELETE),               
//            SPACE=... 
//            LRECL=...,RECFM=FB                        
//SYSOUT   DD SYSOUT=*                               
//SYSIN    DD *                                      
  SORT FIELDS=COPY                                        
  OUTFIL FNAMES=SORTOF01,                                 
   INCLUDE=(cond for file 1)  
  OUTFIL FNAMES=SORTOF02,                                 
   INCLUDE=(cond for file 2)  
  OUTFIL FNAMES=SORTOF03,                                 
   INCLUDE=(cond for file 3)
/*
//*
 

Haribabu

• Oct 15th, 2019

SORT FIELDS=COPY
OUTFIL FILES=OUT1,ENDREC=10000
OUTFIL FILES=02,STARTREC=10001,ENDREC=20000 OUTFIL FILES=03,STARTREC=20001,ENDREC=30000

also possible for OUTFIL FNAMES=(OUT1,OUT2,OUT3),SPLIT=10000

Rishu

• Jul 31st, 2014

In addition to the above solution, we can use SPLIT BY in SORT. But it will depend on condition of split.

Improve Answer