Re: DSPFD *USRLIBL Broken?

[dlclark@xxxxxxxxxxxxxxxx]

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 01/03/2019 
03:55:22 PM:
> Technically one could do a RUNSQL to wrap my SQL statement with
> CREATE TABLE QTEMP.TEMPTABLE AS(
> ...
> ) WITH DATA
>
> and then do a RCVF on that.
>
> Personally I tend to avoid CL because, as you've just pointed out, it 
> limits what tools you're willing to use.


        I don't think having to run such an SQL statement and then do a 
RCVF would perform much better than just using the DSPFD command to create 
the output file for RCVF.  I'm sure IBM is being very efficient under the 
DSPFD command covers.  I just wish the DSPFD command had an option to 
return even fewer data columns of information to make it more efficient 
(using *BASATR now).  Without it, that might justify the RUNSQLSTM method.

        However, I did write my own tool for being able to build and use 
an SQL statement in CL (i.e., it returns the data in a CL variable) but 
this CL is for a stand-alone sample UIM application to put in the wiki.  I 
didn't want to increase the complexity of the sample application.


Sincerely,

Dave Clark