Re: Regarding source physical file

Hi,

Thanks for all these inputs here.

So
1) How to create a UDTF that combines
all of the members for a single query (possibly using RPG native I/O
with MBR(*ALL)) instead of copying all of the data to another file and
having to keep that file up to date. the UDTF could also add a new
"virtual" field for the member name.
?
or

create

a) a table function (UDTF)
or
b) a view

which consolidates all members in one “query" ?

2) Could the use of MQT(Materialized Query Table) help this query (shared
here 'SysPartitionStat cross join QSYS2.IFS_READ' (is it a built-in table
function provided by the IBM i ?)to run faster ?

If yes, then how to modify this query to utilize it here?

3)

call qgpl.export_source_to_git' -- Ok even though once it sends all the
source to IFS path but using this can we browse the source members the same
way we browse it using WRKMBRPDM? if yes , then how?


4) Will any RPGLE program( including CL as suggested here) generate this
ideal file faster than running above SQL query (using SysParttionStat) , I
mean performance wise?

If Yes, do we have that program here to compare both here?




Thank much...



On Thu, 6 Jul 2023 at 03:05, Stephen Landess <steve_landess@xxxxxxxxxxx>
wrote:

Guys -

Jerry Ven was here too!

On 10-Dec-2022 I wrote (about him):

Time spent responding to jerry ven is waste of effort.
He's a sinkhole. ;-(

Vern wrote:

I'm sure it is. Another contributor here told me he's seen a Seth Richi

or Richi Seth some time ago,

pulling this same stunt then. And that name came up sending the exact

same request as Tim Ken.

And now we have Joe and Jerry - what an abuse of these lists!
I do believe some of the replies will be helpful to everyone -
but the constant demanding without apparent effort on the OP's part,
that has to stop or be stopped, IMHO.

Jon wrote:

The same guy (?) under the name jerry ven is asking the same questions

in the IBM Community forums.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.