Suppose I'm creating an SQL view, FOO, joining PFs BAR and BAZ, and
applying UDFs to some of the fields, and putting it in the same library
as the PFs. And suppose we have a whole bunch of libraries, each of
which contains a BAR and a BAZ, with all BAR PFs sharing the same
format, all BAZ PFs sharing the same format, and all FOO views to share
the same format.
And suppose I'm creating FOO using a RUNSQLSTM on a source member.
If I were creating FOO as a native join-logical, from DDS, using CRTLF,
it would be easy enough to either use the same source member for all
instances of FOO, or to just CRTLF one instance, and then copy it into
the other libraries that need it, just by leaving the based-on PFs
unqualified in the source.
But is there a way to do the same with RUNSQLSTM, either creating a view
that will always be based on the PFs in the same library, or failing
that, at least use the same source member for all libraries?
--
JHHL
