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
 
DFSORT convert Text field to signed Numeric format

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

New User


Joined: 07 May 2008
Posts: 36
Location: Chennai

PostPosted: Tue Aug 10, 2010 3:16 pm    Post subject: DFSORT convert Text field to signed Numeric format
Reply with quote

What's the SORT card to convert the Text field to SIGNED Numeric format?

Regards,
Saravana S
Back to top
View user's profile Send private message

smijoss

Active User


Joined: 30 Aug 2007
Posts: 114
Location: pune

PostPosted: Tue Aug 10, 2010 3:26 pm    Post subject:
Reply with quote

give some sample data.
Back to top
View user's profile Send private message
srvk_2k2

New User


Joined: 07 May 2008
Posts: 36
Location: Chennai

PostPosted: Tue Aug 10, 2010 3:35 pm    Post subject:
Reply with quote

My input file-

Field1: '-190000' X(7)

Outfile-

Field1: -190000 S9(07)
Back to top
View user's profile Send private message
smijoss

Active User


Joined: 30 Aug 2007
Posts: 114
Location: pune

PostPosted: Tue Aug 10, 2010 4:12 pm    Post subject:
Reply with quote

Code:
//JS001   EXEC PGM=SORT                                 
//*                                                     
//SYSOUT   DD SYSOUT=*                                 
//*                                                     
//SORTIN   DD *                                         
-190000                                                 
    200                                                 
   -200                                                 
/*                                                     
//SORTOUT   DD DSN=TEMP.TLM.FTBDATE.OUT,               
//             DISP=(NEW,CATLG),                       
//             SPACE=(CYL,(1,1),RLSE),UNIT=TSTDA       
//*                                                     
//SYSIN    DD *                                         
  OPTION COPY                                           
  OUTREC OVERLAY=(15:1,7,FS,EDIT=(STTTTTTT),SIGNS=(+,-))



output :
Code:
-190000       -0190000
    200       +0000200
   -200       -0000200
Back to top
View user's profile Send private message
srvk_2k2

New User


Joined: 07 May 2008
Posts: 36
Location: Chennai

PostPosted: Tue Aug 10, 2010 5:05 pm    Post subject:
Reply with quote

Thank you smijoss
Back to top
View user's profile Send private message
vinu78

Active User


Joined: 02 Oct 2008
Posts: 151
Location: India

PostPosted: Fri Apr 15, 2011 9:08 am    Post subject:
Reply with quote

Hi Smijoss,

If the input field contains decimal point, what will be change in SORT card?
Could you please let me know of that.

Thanks
Vinu
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Apr 15, 2011 12:53 pm    Post subject:
Reply with quote

Vniu - You already have a thread going on here and the above question seems related to that. If you have a new question, it's good to open up a new thread with a reference to previous thread. Also, you now know that you are using SyncSort not DFSort - so your thread should be in JCL part for the Forum if it's related to Sort-product you are using.
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 Apr 15, 2011 9:05 pm    Post subject:
Reply with quote

Quote:
If the input field contains decimal point, what will be change in SORT card?


The SFF (signed free form) or UFF (unsigned free form) format can be used for values with a decimal point.
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 File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Fetch Previous month & year in MM... girishb2 DFSORT/ICETOOL 3 Thu Sep 21, 2017 9:54 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