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
 
sorting the data which are fetched

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
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    Post subject: sorting the data which are fetched
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    Post subject: Hi
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    Post subject: Re: sorting the data which are fetched
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    Post subject: Hi
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Question related to Data dictionary f... rexx77 SYNCSORT 3 Thu Aug 31, 2017 7:23 am

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