On Thu, 16 Apr 2020 11:24:43 -0500, Tim Hare <[email protected]>
wrote:
>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 ....
For anybody that might be interested, SYNCSORT can run SQL SELECT statements.
I'm not sure of the exact details on how to install/enable that feature, but
here is some sample SYNCSORT JCL to run a SELECT:
//SORTDB2 EXEC PGM=SORT,PARM='DB2=ssid'
//STEPLIB DD DISP=SHR,DSN=hlq.xxx.SDSNEXIT
// DD DISP=SHR,DSN=hlq.xxx.SDSNLOAD
//SYSOUT DD SYSOUT=*
//SORTOUT DD SYSOUT=*
//SORTDBIN DD *
SELECT * FROM Q.STAFF;
/*
//SYSIN DD *
SORT FIELDS=COPY
INREC FINDREP=(INOUT=(X'00',X'40'),STARTPOS=5,ENDPOS=13)
OUTFIL HEADER2=(1:' ID# Name Dept Title Years',
42:'Salary Commission'),
BUILD=(1:1,2,BI,ZDF,C' ',
5,9,C' ',
15,2,BI,ZDF,C' ',
18,5,C' ',
24,2,BI,EDIT=(IIIIT),C' ',
27,4,PD,EDIT=($I,III,IIT.TT),C' ',
32,4,PD,EDIT=($I,III,IIT.TT))
END
/*
//*
Q.STAFF is a sample table that ships with QMF. You have to tell SYNCSORT the
DB2 SubSystem ID (DB2=ssid) to use and you have to STEPLIB to the DB2 SDSNLOAD
Library, (if you use SDSNEXIT, then it should come before SDSNLOAD). You can
run much more complicated SELECTs then I have in this example! You can use
SYNCSORT control statements to reformat the output into a readable report.
--
Dale R. Smith
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
