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

db2 queries using syncsort


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
pjnithin

Active User


Joined: 22 Dec 2005
Posts: 116

PostPosted: Mon Jan 09, 2006 5:59 am
Reply with quote

is it helpful running db2 queries using syncsort utility
Back to top
View user's profile Send private message
prabhu2006

New User


Joined: 09 Jan 2006
Posts: 5

PostPosted: Mon Jan 09, 2006 5:41 pm
Reply with quote

Hi Pjnithin,

I dont think you can run DB2 queries using Syncsort. There are Cobol DB2 utilities whicha re configuration specific I believe by which we can do the same. Please let us know, if by any other means this is achieved.

Thanks & Regards
Prabhu
Back to top
View user's profile Send private message
pjnithin

Active User


Joined: 22 Dec 2005
Posts: 116

PostPosted: Mon Jan 09, 2006 8:45 pm
Reply with quote

There's something abt what I have said in this site:
switchcentral.tolly.com/detail/PROD/1025230007_343.html

Bascially they are using some features of syncsort to get the output of a query to sort in a particular order rather than having the DB2 do that which usually takes more time.


prabhu2006 wrote:
Hi Pjnithin,

I dont think you can run DB2 queries using Syncsort. There are Cobol DB2 utilities whicha re configuration specific I believe by which we can do the same. Please let us know, if by any other means this is achieved.

Thanks & Regards
Prabhu
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Count Records with a crietaria in a f... DFSORT/ICETOOL 5
No new posts DFSORT/SYNCSORT/ICETOOL JCL & VSAM 8
No new posts Syncsort "Y2C" Function SYNCSORT 1
No new posts Arithmetic division using Syncsort SYNCSORT 6
Search our Forums:

Back to Top