IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Prefix Zeros with DFSORT


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
shrivatsa
Warnings : 1

Active User


Joined: 17 Mar 2006
Posts: 174
Location: Bangalore

PostPosted: Tue Mar 04, 2008 11:54 am
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: 174
Location: Bangalore

PostPosted: Tue Mar 04, 2008 12:38 pm
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: 1436
Location: Bangalore,India

PostPosted: Tue Mar 04, 2008 1:28 pm
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: 174
Location: Bangalore

PostPosted: Tue Mar 04, 2008 1:57 pm
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: 2146
Location: At my coffee table

PostPosted: Tue Mar 04, 2008 7:43 pm
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 Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue Mar 04, 2008 10:13 pm
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

Global Moderator


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

PostPosted: Tue Mar 04, 2008 10:20 pm
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

Moderator Emeritus


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

PostPosted: Tue Mar 04, 2008 10:47 pm
Reply with quote

Frank doesn't do Syncsort icon_wink.gif
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue Mar 04, 2008 11:33 pm
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: 174
Location: Bangalore

PostPosted: Tue Mar 18, 2008 7:42 pm
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: 199
Location: india

PostPosted: Tue Mar 18, 2008 8:22 pm
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

Moderator Emeritus


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

PostPosted: Tue Mar 18, 2008 11:27 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Substring number between 2 characters... DFSORT/ICETOOL 2
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts DFsort help with SUM() DFSORT/ICETOOL 12
Search our Forums:

Back to Top