Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Removing hex values

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
sun_job

New User


Joined: 18 Sep 2007
Posts: 73
Location: Bangalore

PostPosted: Tue Sep 02, 2008 12:11 pm    Post subject: Removing hex values
Reply with quote

Hi

I would like to know how could we remove Hex values in my input dataset removed .
for eg
1---------------------19-------31
01100028705101GT XF B

there are some hex characters like 'XF' , i want to ahve spaces in the columns 19-31.

Please suggest what to do?
Back to top
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2180
Location: @my desk

PostPosted: Tue Sep 02, 2008 12:25 pm    Post subject:
Reply with quote

Quote:
there are some hex characters like 'XF'

Whatever you showed seem to be alphabets. Do you want to replace 19-31 with spaces whatever the data it has?

Thanks,
Arun
Back to top
View user's profile Send private message
sun_job

New User


Joined: 18 Sep 2007
Posts: 73
Location: Bangalore

PostPosted: Tue Sep 02, 2008 12:35 pm    Post subject: Hi
Reply with quote

yes i want to replace 19-31 with spaces whatever the data it has with spaces. can u provide me the snippet for the same.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2180
Location: @my desk

PostPosted: Tue Sep 02, 2008 12:39 pm    Post subject:
Reply with quote

Sun,

The below SORT job would do whatever you asked for .

Code:
//STEP1    EXEC PGM=SORT                         
//SYSOUT   DD SYSOUT=*                           
----+----1----+----2----+----3----+----4----+----5
//SORTIN   DD *                                   
01100028705101GT XF B   FFFFFFFAAAAAAAAAAAAAAAAAAA
//SORTOUT  DD SYSOUT=*                           
//SYSIN    DD *                                   
  SORT FIELDS=COPY                               
  INREC OVERLAY=(19:13X)         

SORTOUT
Code:
01100028705101GT X             AAAAAAAAAAAAAAAAAAA


Thanks,
Arun
Back to top
View user's profile Send private message
sun_job

New User


Joined: 18 Sep 2007
Posts: 73
Location: Bangalore

PostPosted: Tue Sep 02, 2008 1:17 pm    Post subject: HI
Reply with quote

Thanks arun for ur help
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Overlaying one set of charater values... Kevin Lindsley SYNCSORT 7 Sat Nov 05, 2016 3:21 am
No new posts Low values Results from VARCHAR FORMAT balaji81_k DB2 10 Thu Oct 20, 2016 1:18 am
No new posts How can we create a flat file in JAVA... rakesh.v18 Java & MQSeries 7 Fri Sep 23, 2016 10:46 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us