Tim, DFSORT or ICETOOL does NOT have the capability of running DB2 queries. However DB2 utilities(LOAD, REORG, UNLOAD..) invoke DFSORT in the background. IBM already have 2 free unload utilities that does the job for you. DSNTIAUL and DSNTEP2 are free unload utilities. DSNTIAUL unload utility invokes DFSORT in the background if there is a SORT involved(Order By).
Also there is a DB2 High Performance Unload (INZUTILB) which is an add-on product which gives you much more flexibility when you are unloading. >>> It would be nice if this could execute before SYMNAMES is read, so > the SELECT handler could create symbols for all of the columns in > the result set. If your intention is to create DFSORT symbols from DB2 table definition then there are a couple of ways to get it done. Let me know if you are interested in that and we can discuss that offline. Thanks, Sri Hari Kolusu DFSORT Development IBM Corporation IBM Mainframe Discussion List <[email protected]> wrote on 04/16/2020 09:24:43 AM: > From: Tim Hare <[email protected]> > To: [email protected] > Date: 04/16/2020 09:25 AM > Subject: [EXTERNAL] DB2 / DFSort question > Sent by: IBM Mainframe Discussion List <[email protected]> > > Before I start chiseling a piece of stone into a wheel :-) - I've > been thinking about ICETOOL and DB2. Is there already in existence > something that would provide a SELECT (similar to what is used in > DSNTIAUL or DSNTIAD) to select DB2 data as an E15 exit for DFSORT? > > My ideal would be (Maybe I should write an RFE) > ------ > In ICETOOL the ability to code SQLSEL FROM(SQL) USING(xxxx) > > xxxxCNTL DD * > > SELECT .... > > ------ > > It would be nice if this could execute before SYMNAMES is read, so > the SELECT handler could create symbols for all of the columns in > the result set. > > Maybe it is just as efficient to use DSNTIAUL with ORDER BY ? > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
