Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How can I Change Quote to Hyphen using SORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
NARAYANAM
Warnings : 1

New User


Joined: 22 Sep 2006
Posts: 5

PostPosted: Fri Jan 19, 2007 12:02 pm    Post subject: How can I Change Quote to Hyphen using SORT
Reply with quote

How can i CHANGE QUOTE TO HYPHEN using SORT. Please explain.


Thanking you,





Regards,
Narayanam Rama Rao.
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Fri Jan 19, 2007 2:48 pm    Post subject:
Reply with quote

Is the quote you want to change in fixed locations or just anywhere in the record?
Back to top
View user's profile Send private message
NARAYANAM
Warnings : 1

New User


Joined: 22 Sep 2006
Posts: 5

PostPosted: Fri Jan 19, 2007 2:53 pm    Post subject: How can I Change Quote to Hyphen using SORT
Reply with quote

i want to change Quote to Hyphen using SORT in entire Sequencial file i.e., where ever QUOTE is present.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Fri Jan 19, 2007 3:15 pm    Post subject:
Reply with quote

I don't think you will have any luck with any sort, maybe another utility will be more suitable.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Fri Jan 19, 2007 10:13 pm    Post subject:
Reply with quote

Narayanam,

You can use DFSORT's TRAN=ALTSEQ function to do what you want. I assumed you mean double quote " (X'7F') and hyphen (X'60') but you can use the hex values for any characters you need. I assumed your input file has RECFM=FB and LRECL=80, but the job can be changed for other attributes.

Code:

//S1    EXEC  PGM=ICEMAN
//SYSOUT    DD  SYSOUT=*
//SORTIN DD DSN=...  input file (FB/80)
//SORTOUT DD DSN=...  output file (FB/80)
//SYSIN    DD    *
  OPTION COPY
  ALTSEQ CODE=(7F60)
  INREC FIELDS=(1,80,TRAN=ALTSEQ)
/*
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts Partial color change of a field in CI... waseem0424 CICS 5 Fri Sep 29, 2017 7:56 pm
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts OC4 in SORT Mohan Kothakota DFSORT/ICETOOL 2 Tue Sep 12, 2017 6:30 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us