IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Sort Condion using IF


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
harinair_kn
Warnings : 2

New User


Joined: 27 Feb 2006
Posts: 16
Location: India

PostPosted: Wed Mar 13, 2013 8:08 pm
Reply with quote

I have a requiremnt to check for a specific character in position 40-42 and if its present, i need to replace the characters in position 1-3 with number 521.


Eg: Input File : 514 ...............................ADS12345678

If "ADS" is present in position 40-42, I need to replace "514" in position 1-3 with "521" and copy the entire string to the output file. Can somebody help me here?

Thanks,
hari
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed Mar 13, 2013 8:22 pm
Reply with quote

Have you tried INREC IFTHEN and OVERLAY? By the way, per your example the starting position is 36 and not 40-42:
Code:
----+----1----+----2----+----3----+----4----+-
514 ...............................ADS12345678
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania

PostPosted: Wed Mar 13, 2013 8:25 pm
Reply with quote

ibmmainframes.com/viewtopic.php?t=60582&highlight=overlay

This has what you need.

Loook at:
INREC
IFTHEN
OVERLAY

You should be able to take it from there.
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Wed Mar 13, 2013 10:44 pm
Reply with quote

Code:

//STEP0100 EXEC PGM=SORT                                       
//SYSOUT   DD SYSOUT=*                                         
//SORTIN   DD *                                               
----+----1----+----2----+----3----+----4----+----5----+----6---
514 ...................................ADS12345678             
514 ...................................BDS12345678             
//SORTOUT  DD SYSOUT=*                                         
//SYSIN    DD *                                               
  OPTION COPY                                                 
  INREC OVERLAY=(1:40,3,CHANGE=(3,C'ADS',C'521'),NOMATCH=(1,3))
//*
Back to top
View user's profile Send private message
harinair_kn
Warnings : 2

New User


Joined: 27 Feb 2006
Posts: 16
Location: India

PostPosted: Thu Mar 14, 2013 2:09 am
Reply with quote

Thnaks a lot for all your suggestions.Let me just test it out..
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Thu Mar 14, 2013 8:32 am
Reply with quote

Quote:
Have you tried INREC IFTHEN and OVERLAY?
Thank you for balling us out with CHANGE, SKolusu! icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
Search our Forums:

Back to Top