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
 

 

Converting LOW VALUES to SPACES

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

New User


Joined: 25 Apr 2007
Posts: 44
Location: chennai, India

PostPosted: Wed May 09, 2007 6:10 pm    Post subject: Converting LOW VALUES to SPACES
Reply with quote

Hi
recently i have got a requirement. There are many report files which contain low-values in it. now I have to convert these low values to spaces. currently the process followed is as follows

1) open the file in edit mode
2) execute the command c all p'.' ' '
3) save the file

can this be implemented using sort. i.e. the sort card should be in such a way that without specifying the positions this has to convert all the low-values into spaces.

can any one help me?
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: Wed May 09, 2007 9:03 pm    Post subject:
Reply with quote

You can use the technique discussed in the "Change all zeros in your records to spaces" Smart DFSORT Trick at:

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
Back to top
View user's profile Send private message
raam_kumar

New User


Joined: 25 Apr 2007
Posts: 44
Location: chennai, India

PostPosted: Thu May 10, 2007 9:54 am    Post subject:
Reply with quote

thank you frank it is working fine

But how do you remember all these things. it is really amazing
Back to top
View user's profile Send private message
raam_kumar

New User


Joined: 25 Apr 2007
Posts: 44
Location: chennai, India

PostPosted: Thu May 10, 2007 9:55 am    Post subject:
Reply with quote

friends

i just wanted to put the code so that it might be helpful for others who may need it

Code:

   SORT FIELDS=COPY               
   ALTSEQ CODE=(0040)             
   OUTREC FIELDS=(1,80,TRAN=ALTSEQ)
Back to top
View user's profile Send private message
GlobalGyan

New User


Joined: 31 Jan 2006
Posts: 28

PostPosted: Thu May 10, 2007 10:25 am    Post subject:
Reply with quote

Frank is the creator of ICETOOL :=)

Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: PARSE, JFY, SQZ, ICETOOL, IFTHEN, OVERLAY, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort/


I wish I was one something like that :=)

GG
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: Thu May 10, 2007 8:12 pm    Post subject:
Reply with quote

Quote:
But how do you remember all these things


Thanks for the kind words.

I developed many of the functions in DFSORT and all of the functions in ICETOOL which means I spent a lot of time designing, coding, testing and documenting them. And I show DFSORT customers how to use these functions to solve problems every day which keeps them fresh in my mind.
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 Check Binary Values for symbols gandikk CA Products 3 Tue Mar 21, 2017 5:11 am
No new posts To display values of multiple rows in... vinu78 DB2 2 Thu Mar 09, 2017 1:20 pm
No new posts Replacing same string with different ... vickey_dw DFSORT/ICETOOL 6 Wed Feb 22, 2017 10:44 pm
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Converting decimal to numeric using I... Balaryan DFSORT/ICETOOL 4 Thu Feb 02, 2017 11:27 pm


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