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
 

 

Prefix Zeros with DFSORT

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

Active User


Joined: 17 Mar 2006
Posts: 171
Location: Bangalore

PostPosted: Tue Mar 04, 2008 11:54 am    Post subject: Prefix Zeros with DFSORT
Reply with quote

Hi,

My input FB LRECL=350
PATRICIA ANN JONES SWB 12008-02-18 00.00AR AR
JUDY GRIMMETT SWB 12008-02-19 00.00AR AR
CHARLES EANES SWB 12008-02-18 41.25AU TX
ASHLEY CUNNIGHAM SWB 12008-02-18 38.75DA TX
SCHLAINE FISHER SWB 12008-02-18 38.75DA TX

My output Should be
PATRICIA ANN JONES SWB 12008-02-180000000.00AR AR
JUDY GRIMMETT SWB 12008-02-190000000.00AR AR
CHARLES EANES SWB 12008-02-180000041.25AU TX
ASHLEY CUNNIGHAM SWB 12008-02-180000038.75DA TX
SCHLAINE FISHER SWB 12008-02-180000038.75DA TX

Any help appriciated.

Thanks
Shrivatsa
Back to top
View user's profile Send private message

shrivatsa
Warnings : 1

Active User


Joined: 17 Mar 2006
Posts: 171
Location: Bangalore

PostPosted: Tue Mar 04, 2008 12:38 pm    Post subject: Reply to: Prefix Zeros with DFSORT
Reply with quote

Sorry i have just seen

There are some fields
PATRICIA ANN JONES SWB 12008-02-18 0 AR AR
CHARLES EANES SWB 12008-02-18 41AU TX

which should be converted as
PATRICIA ANN JONES SWB 12008-02-180000000.00AR AR
CHARLES EANES SWB 12008-02-180000041.00AU TX

Thanks
Shrivatsa
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Tue Mar 04, 2008 1:28 pm    Post subject:
Reply with quote

shrivatsa,

Could you post your file layout?

Also use 'code' tag.
Back to top
View user's profile Send private message
shrivatsa
Warnings : 1

Active User


Joined: 17 Mar 2006
Posts: 171
Location: Bangalore

PostPosted: Tue Mar 04, 2008 1:57 pm    Post subject: Reply to: Prefix Zeros with DFSORT
Reply with quote

----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
PATRICIA ANN JONES SWB 12008-02-18 00.00AR AR
JUDY GRIMMETT SWB 12008-02-19 00.00AR AR
CHARLES EANES SWB 12008-02-18 41 AU TX
ASHLEY CUNNIGHAM SWB 12008-02-18 38.75DA TX
SCHLAINE FISHER SWB 12008-02-18 38.75DA TX

1 to 25 - Name
3Char -SWB
3 - 1
10 - Date
10 -Amount
2 -AR
3 -AR

File of FB LRECL-350

Thanks
Shrivatsa
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Tue Mar 04, 2008 7:43 pm    Post subject: Re: Prefix Zeros with DFSORT
Reply with quote

Why are the fields past the name shifted?
Code:
PATRICIA ANN JONES       SWB  12008-02-18     00.00AR AR
JUDY GRIMMETT               SWB  12008-02-19     00.00AR AR
CHARLES EANES               SWB  12008-02-18     41.25AU TX
ASHLEY CUNNIGHAM         SWB  12008-02-18     38.75DA TX
SCHLAINE FISHER             SWB  12008-02-18     38.75DA TX

Code:
PATRICIA ANN JONES       SWB  12008-02-180000000.00AR AR
JUDY GRIMMETT               SWB  12008-02-190000000.00AR AR
CHARLES EANES               SWB  12008-02-180000041.25AU TX
ASHLEY CUNNIGHAM         SWB  12008-02-180000038.75DA TX
SCHLAINE FISHER             SWB  12008-02-180000038.75DA TX

Code:
----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
PATRICIA ANN JONES  SWB  12008-02-18     00.00AR AR               
JUDY GRIMMETT          SWB  12008-02-19     00.00AR AR               
CHARLES EANES          SWB  12008-02-18     41   AU TX               
ASHLEY CUNNIGHAM    SWB  12008-02-18     38.75DA TX               
SCHLAINE FISHER        SWB  12008-02-18     38.75DA TX               
Are you trying to line up the columns in the posting box?
Or do you mean this?
Code:

----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
PATRICIA ANN JONES       SWB12008-02-18     00.00AR AR               
JUDY GRIMMETT            SWB12008-02-19     00.00AR AR               
CHARLES EANES            SWB12008-02-18     41   AU TX               
ASHLEY CUNNIGHAM         SWB12008-02-18     38.75DA TX               
SCHLAINE FISHER          SWB12008-02-18     38.75DA TX               
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: Tue Mar 04, 2008 10:13 pm    Post subject:
Reply with quote

Shrivatsa,

If I understand correctly what you want to do, you can use a DFSORT job like this:

Code:

//S1    EXEC  PGM=ICEMAN                           
//SYSOUT    DD  SYSOUT=*                           
//SORTIN DD DSN=...  input file (FB/350)               
//SORTOUT DD DSN=... output file (FB/350)         
//SYSIN    DD    *                                 
  OPTION COPY                                       
  INREC OVERLAY=(40:40,10,UFF,EDIT=(TTTTTTT.TT))   
/*


If that doesn't do what you want, then you need to do a better job of describing your input records.
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Tue Mar 04, 2008 10:20 pm    Post subject: Reply to: Prefix Zeros with DFSORT
Reply with quote

Shrivatsa, have you recently switched from SYNCSORT to DFSORT? All of your previous posts were SYNCSORT related. icon_confused.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Mar 04, 2008 10:47 pm    Post subject: Reply to: Prefix Zeros with DFSORT
Reply with quote

Frank doesn't do Syncsort icon_wink.gif
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: Tue Mar 04, 2008 11:33 pm    Post subject:
Reply with quote

It's in the DFSORT Forum, so I assume it's DFSORT. Unless somebody specifically says it's Syncsort or shows Syncsort messages, I will answer.
Back to top
View user's profile Send private message
shrivatsa
Warnings : 1

Active User


Joined: 17 Mar 2006
Posts: 171
Location: Bangalore

PostPosted: Tue Mar 18, 2008 7:42 pm    Post subject: Re: Reply to: Prefix Zeros with DFSORT
Reply with quote

superk wrote:
Shrivatsa, have you recently switched from SYNCSORT to DFSORT? All of your previous posts were SYNCSORT related. icon_confused.gif


SuperK,

As you recognised I was working with IBM so I used DFSORT, From last 2 yrs I am using SYNCSORT as I moved to another company.. :-)

One thing I didn't understand in the forum is how people are posting their CODE or FILE layout in mainframe format. If I paste my code its pasting as normal text. Is there any special thing I need to do?

Frank,

As always you are very quick resolver of SORT Queries. Thanks.
Back to top
View user's profile Send private message
rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 188
Location: india

PostPosted: Tue Mar 18, 2008 8:22 pm    Post subject:
Reply with quote

hello,

Just paste your code and then select your code after that press CODE tab present in Message body just below Subject after selecting your mainframe code.

I think that is what you wanted to know...
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Mar 18, 2008 11:27 pm    Post subject:
Reply with quote

Hello,

Quote:
One thing I didn't understand in the forum is how people are posting their CODE or FILE layout in mainframe format. If I paste my code its pasting as normal text. Is there any special thing I need to do?
As rajatbagga mentioned, you can do this using the "bbCode tags" available beneath the Subject.

To know if your post will appear the way you want, click "Preview" and you will see what the forum will see. Once you are satisfied with the appearance of your post, click "Submit". You can make changes and preview multiple times before submitting your reply.

Remember to Submit before leaving the topic or your editing will be lost icon_wink.gif
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 DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm
No new posts How to get the remainder and quotient... vnktrrd DFSORT/ICETOOL 2 Mon Oct 31, 2016 10:59 am
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm
No new posts DFSORT sorting only specific records akodakka DFSORT/ICETOOL 4 Thu Aug 04, 2016 11:24 am
No new posts Symbolic Parameters in SYSIN DD state... madishpa DFSORT/ICETOOL 3 Mon Jun 27, 2016 6:23 pm


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