db2 queries using syncsort

pjnithin · Active User Joined: 22 Dec 2005 Posts: 108

is it helpful running db2 queries using syncsort utility

prabhu2006 · New User Joined: 09 Jan 2006 Posts: 5

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

pjnithin · Active User Joined: 22 Dec 2005 Posts: 108

There's something abt what I have said in this site:
http://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.