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
 
help,how to control sequence number after sort?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
lee_issc

New User


Joined: 11 Dec 2008
Posts: 33
Location: China

PostPosted: Mon Feb 13, 2012 3:09 pm    Post subject: help,how to control sequence number after sort?
Reply with quote

Code:

SEQ-NO  ID          CCY       AMT
1       A123456XXX  USD$    10.00
2       B123456XXX  USD$    15.00
3       C123456XXX  USD$    25.00
                    USD$    50.00
1       A123456XXX  GBP$     5.00
2       B123456XXX  GBP$     5.00
3       C123456XXX  GBP$   102.00
                    GBP$   112.00
1       A123456XXX  xxx     10.00
2       B123456XXX  xxx     15.00
3       C123456XXX  xxx     25.00
                    xxx     50.00
1       A123456XXX  aaa      5.00
2       B123456XXX  aaa      5.00
3       C123456XXX  aaa    102.00
                    aaa    112.00
1       A123456XXX  sss     10.00
2       B123456XXX  sss     15.00
3       C123456XXX  sss     25.00
                    sss     50.00
1       A123456XXX  ccc      5.00
2       B123456XXX  ccc      5.00
3       C123456XXX  ccc    102.00
                    ccc    112.00




Dear guys,

I wanna have a report like above, anybody let me know how to control the sequence? I tried before line and report-in to add 1 to seq-no but didn't effective. I sorted the input records by CCY in report SEQUENCE control.
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Mon Feb 13, 2012 3:20 pm    Post subject: Re: help,how to control sequence number after sort?
Reply with quote

Please use the Code tags to preserve spacing for data requiring that.

In a general forum area like this one, it would be good to indicate you are talking about Easytrieve Plus.

What order do you want these in within currency?
Back to top
View user's profile Send private message
lee_issc

New User


Joined: 11 Dec 2008
Posts: 33
Location: China

PostPosted: Mon Feb 13, 2012 5:00 pm    Post subject:
Reply with quote

thanks Bill Woodger.

Actually I cannot get the right sequence number like in the code. The sequence no is 1,2,3,4....and after the CCY break, it restart begin with 1,2,3,4...like that. now I don't how to control that sequence number.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Mon Feb 13, 2012 5:11 pm    Post subject: Reply to: help,how to control sequence number after sort?
Reply with quote

Still not sure I'm following.

Code:
SEQUENCE +
         CCY +
         SEQ-NO


Will cause the report to be sequence on currency followed by sequence number. You can SEQUENCE on as many fiedls as necessary.

Or are you asking something else?
Back to top
View user's profile Send private message
lee_issc

New User


Joined: 11 Dec 2008
Posts: 33
Location: China

PostPosted: Mon Feb 13, 2012 5:43 pm    Post subject:
Reply with quote

Code:

                                   
SEQ NO   CUST NO   BR NO           
------  ---------  -----  ---------
000008  000116930  00061  HAHA     
000078  000116930  00061  HAHA     
000050  000116930  00061  HAHA     
000036  000116930  00061  HAHA     
000064  000116930  00061  HAHA     
                                   
REPORT ID:   MDRLCB01             
REPORT DATE:  2/13/2012           
                                   
                                   
                                   
SEQ NO   CUST NO   BR NO           
------  ---------  -----  ---------
000000  000114630  08001  JIANG YI
000082  000114630  08001  JIANG YI
000054  000114630  08001  JIANG YI
000040  000114630  08001  JIANG YI
000068  000114630  08001  JIANG YI


I wanna to:

Code:

                                   
SEQ NO   CUST NO   BR NO           
------  ---------  -----  ---------
000001  000116930  00061  HAHA     
000002  000116930  00061  HAHA     
000003  000116930  00061  HAHA     
000004  000116930  00061  HAHA     
000005  000116930  00061  HAHA     
                                   
REPORT ID:   MDRLCB01             
REPORT DATE:  2/13/2012           
                                   
                                   
                                   
SEQ NO   CUST NO   BR NO           
------  ---------  -----  ---------
000001  000114630  08001  JIANG YI
000002  000114630  08001  JIANG YI
000003  000114630  08001  JIANG YI
000004  000114630  08001  JIANG YI
000005  000114630  08001  JIANG YI


Which means I wanna the SEQ-NO can re-calculate from 1 and add 1 by 1 after each break.thanks!
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Mon Feb 13, 2012 5:53 pm    Post subject: Reply to: help,how to control sequence number after sort?
Reply with quote

You need to define your sequence field as type S not W. Then you can amend it in report procedures to receive your expected results.

See this for fuller explanation.
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 -> CA Products 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 JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts OC4 in SORT Mohan Kothakota DFSORT/ICETOOL 2 Tue Sep 12, 2017 6:30 pm
No new posts SORT Trailer Count - LRECL Output co... amorante DFSORT/ICETOOL 5 Tue Aug 29, 2017 8:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us