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

sorting the data which are fetched


IBM Mainframe Forums -> CICS
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
joshua1983

New User


Joined: 25 May 2006
Posts: 7
Location: Mumbai, India

PostPosted: Wed Jul 19, 2006 11:35 am
Reply with quote

Hi all icon_smile.gif

In a program there are many fields to be displayed like

Name Date Occupation
- - -
- - -
- - -

Now the date column which is to be displayed is manipulated in the program itself....

now my question is

How to sort the records for column "Date"....???
How is it possible to sort the records after writing it to the queue...???

Thanks in advance....
Back to top
View user's profile Send private message
Hanfur

Active User


Joined: 21 Jun 2006
Posts: 104

PostPosted: Wed Jul 19, 2006 4:58 pm
Reply with quote

You can do this sorting by ORDERBY clause if this column are originating from DB2 tables.

If its coming thru prog then you can go with an Internal sort.But its better to create your extract file using your prog first then doing an externel JCL sort .


-Han.
Back to top
View user's profile Send private message
joshua1983

New User


Joined: 25 May 2006
Posts: 7
Location: Mumbai, India

PostPosted: Thu Jul 20, 2006 6:23 pm
Reply with quote

thanks hanfur for ur reply

but in the program i've mentioned sorting is to be done only by programmic logic

is there any way ...???
Back to top
View user's profile Send private message
Tricker

New User


Joined: 12 Jul 2006
Posts: 3

PostPosted: Wed Jul 26, 2006 5:27 pm
Reply with quote

Then go for internal sort ..for this

1.you could create an array and could sort the elements in array using any of sorting algorithm.

2.Go for SORT command of Cobol.You need to have an SD section for it instead of FD section.

Just google it to find the syantax and usage..

-Han.
Back to top
View user's profile Send private message
mallikiran

New User


Joined: 07 Sep 2005
Posts: 49

PostPosted: Tue Aug 01, 2006 7:16 pm
Reply with quote

Are we talking about CICS programs over here?
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 -> CICS

 


Similar Topics
Topic Forum Replies
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
No new posts Check data with Exception Table DB2 0
No new posts JCL EXEC PARM data in C Java & MQSeries 2
This topic is locked: you cannot edit posts or make replies. Automation need help in sorting the data DFSORT/ICETOOL 38
Search our Forums:

Back to Top