Re: Regarding source physical file

Hi ,

For my 3rd query in previous email , please ignore it as can find the same
using WRKLNK command then option 5-to display it but my main question was
can we download all these IFS members all together like we can download all
these source members using SQL query shared here ('SysPartitionStat cross
join QSYS2.IFS_READ') if yes, can we have that modified SQL query here
please? or would it be like this (SELECT System_Table_Schema,
System_Table_Name, System_Table_Member
FROM SysPartitionStat
WHERE System_Table_Schema = 'YourSchema' -- Replace with the desired schema
AND System_Table_Name LIKE '%.SOURCE' -- Adjust the file name pattern if
needed
AND System_Table_Member <> '*DIR'

)

If it's wrong can we please have a corrected version of that SQL query here
please?


Thanks a lot..

On Sat, 8 Jul 2023 at 13:46, joe <joe.planet21@xxxxxxxxx> wrote:

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.