Re: When ctl-opt main() is missing

[Gad Miron <gadmiron@xxxxxxxxx>]

Daniel
IIRC, I constructed the SQL statement (with insert into) and then used
RUNSQL

Vern,
Thanks for the link and the expectation


Gad



> from: Daniel Gross <daniel@xxxxxxxx>
> subject: Re: When ctl-opt main() is missing
>
> A little OT - but the performance of SQL recursion depends a lot on join
> and index strategy.
>
> In general, performance is quite good, if matching indexes are there. In
> any case, build the query in iACS and definitely use Run and Explain - to
> look for any performance bottlenecks.
>
> And how did you run SQL in CL? Using RUNSQLSTM? And the result?
>
> HTH and kind regards,
> Daniel
>
>
> > Am 04.11.2024 um 18:44 schrieb Gad Miron <gadmiron@xxxxxxxxx>:
> >
> > ?as SQL recursion was mentioned here:
> > I have lately written one such recursive SQL, (only one and in CL)
> > Performance is not great...
> >
> > Gad
> > --