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
 
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 Extend the decimal values in DIVISION Balaryan DFSORT/ICETOOL 3 Thu Oct 05, 2017 4:05 pm
No new posts Working with hex values in Filemanage... Emile Straker IBM Tools 0 Tue Sep 12, 2017 1:42 am
No new posts DB2 NULL Values display V S Amarendra Reddy DB2 3 Thu Sep 07, 2017 6:59 pm
No new posts Moving values to a variable of copybo... Vignesh Sid COBOL Programming 6 Wed Sep 06, 2017 1:04 pm
No new posts Remove leading spaces from numeric field rexx77 SYNCSORT 6 Wed Sep 06, 2017 2:15 am

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