Re: DSPFD *USRLIBL Broken?

"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