View previous topic :: View next topic
|
Author |
Message |
shrivatsa Warnings : 1 Active User
Joined: 17 Mar 2006 Posts: 174 Location: Bangalore
|
|
|
|
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 |
|
|
shrivatsa Warnings : 1 Active User
Joined: 17 Mar 2006 Posts: 174 Location: Bangalore
|
|
|
|
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 |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
shrivatsa,
Could you post your file layout?
Also use 'code' tag. |
|
Back to top |
|
|
shrivatsa Warnings : 1 Active User
Joined: 17 Mar 2006 Posts: 174 Location: Bangalore
|
|
|
|
----+----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 |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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 |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
Shrivatsa, have you recently switched from SYNCSORT to DFSORT? All of your previous posts were SYNCSORT related. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Frank doesn't do Syncsort |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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 |
|
|
shrivatsa Warnings : 1 Active User
Joined: 17 Mar 2006 Posts: 174 Location: Bangalore
|
|
|
|
superk wrote: |
Shrivatsa, have you recently switched from SYNCSORT to DFSORT? All of your previous posts were SYNCSORT related. |
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 |
|
|
rajatbagga
Active User
Joined: 11 Mar 2007 Posts: 199 Location: india
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
Back to top |
|
|
|