DB2 SQL Query support with DFSORT?

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
User avatar
rangab
Active Member
Posts: 56
Joined: Fri Mar 17, 2006 3:21 pm

DB2 SQL Query support with DFSORT?

Post by rangab » Thu Feb 05, 2009 9:45 pm

Hi,

Does DFSORT support execution of SELECT SQL query? What is the procedure?

Thanks.
========
Ranga...:-0)
========
Learn Which You Don't Know - Teach Others Which They Don't Know.

skolusu
Member
Posts: 43
Joined: Sat Jul 26, 2008 12:38 am

Post by skolusu » Fri Feb 06, 2009 12:38 am

rangab,

DFSORT does NOT support running DB2 SQL queries directly. However if you are using DB2 version 8 and higher and if you are using DB2 utilities, DFSORT is invoked depending on if a SORT is necessary even if your shop does not have a license for DFSORT.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

User avatar
rangab
Active Member
Posts: 56
Joined: Fri Mar 17, 2006 3:21 pm

Post by rangab » Fri Feb 06, 2009 5:16 pm

skolusu, we are recently upgraded to DB2 v8.0. Would you please explain in details how exactly we make use of DFSORT with application programming !?

Thanks.
========
Ranga...:-0)
========
Learn Which You Don't Know - Teach Others Which They Don't Know.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others