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 space using dfsort

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
mailsaurabh.tripathi

New User


Joined: 22 May 2008
Posts: 56
Location: hyderabad

PostPosted: Mon Jun 01, 2009 1:45 pm    Post subject: removing space using dfsort
Reply with quote

Hi
I need to remove space from 'CDB001 .CDB004D' to get a output 'CDB001.CDB004D'. Can anyone provide the sysin for sort.
thank you
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Mon Jun 01, 2009 1:59 pm    Post subject:
Reply with quote

you have already removed the space.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Mon Jun 01, 2009 2:16 pm    Post subject:
Reply with quote

Hi Dick,

actually when you cut and paste, there is a space after CDB001

Code:
'CDB001 .CDB004D' to get a output 'CDB001.CDB004D'


Gerry
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Mon Jun 01, 2009 3:13 pm    Post subject: Reply to: removing space using dfsort
Reply with quote

Gerry,

you are correct. Even without the cut&paste it is obvious.
Only excuse I can give is that I was to quick to criticize.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Mon Jun 01, 2009 3:14 pm    Post subject:
Reply with quote

Hi,

you should be able to use this
Code:
   OPTION COPY                                   
   INREC BUILD=(1,17,SQZ=(SHIFT=LEFT))
but I'm unable to test it due to the level of DFSORT installed.

or you could use
Code:
//STEP0001 EXEC PGM=ICEMAN               
//SYSOUT   DD SYSOUT=*                   
//SORTIN   DD *                         
'CDB001 .CDB004D'                       
//SORTOUT  DD SYSOUT=*                   
//SYSIN    DD *                         
  OPTION COPY                           
 OUTREC BUILD=(1,7,9,9,80:X)             
/*                                       



Gerry
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Mon Jun 01, 2009 3:16 pm    Post subject:
Reply with quote

Hi Dick,

I only noticed it after the cut and paste, I was about to make the same comment as you icon_lol.gif


Gerry
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am
This topic is locked: you cannot edit posts or make replies. Need help in estimating space of unlo... ashek15 IMS DB/DC 12 Fri Apr 07, 2017 5:11 am
No new posts DFSORT - Overriding default option TU... Steve Ironmonger DFSORT/ICETOOL 3 Tue Apr 04, 2017 3:54 pm
No new posts Need inputs on Space requirement and... ashek15 IMS DB/DC 0 Sat Apr 01, 2017 8:26 am
No new posts DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm


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