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 3270 Data stream error Benchwarmer CICS 4 Tue Apr 17, 2018 12:06 am
No new posts How to list data set names with diffe... murali.andaluri CLIST & REXX 8 Thu Apr 12, 2018 11:33 pm
No new posts Invalid XML character while producing... nikhil.bhole IBM Tools 4 Tue Mar 20, 2018 1:24 am
No new posts Get the list of data sets on DASD and... rakaitn JCL & VSAM 3 Thu Mar 08, 2018 12:38 pm
No new posts Data security erase on RAID device steve-myers All Other Mainframe Topics 0 Sat Jan 13, 2018 6:41 am

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