Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts Overriding PS data in rexx Shaheen Shaik CLIST & REXX 8 Fri Mar 03, 2017 5:08 pm
No new posts JCL to get submitted once dataset has... vinu78 JCL & VSAM 17 Thu Feb 16, 2017 7:32 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us