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
 

 

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 to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm
No new posts Reduce CPU Times for Join Sort santoshn SYNCSORT 12 Sat Jun 10, 2017 1:40 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm


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