RE: How is this file populated?

... OR CPYF or SQL (ACS/STRSQL Script, ODBC, JDBC...)?

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization ? Education ? Consulting on IBM i

IBM Champion since 2020

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
"Train people well enough so they can leave, treat them well enough so they
don't want to. " (Richard Branson)
"Learning is experience ? everything else is only information!" (Albert
Einstein)

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
dr2@xxxxxxxx
Sent: Wednesday, 24 May 2023 00:13
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: How is this file populated?

FTP?

On 2023-05-23 18:04, tgarvey@xxxxxxxxxx wrote:

Hi,

Looking at a table that has data that is somehow being populated. It
is being used, not updated, by a PC application (Alteryx) which
accesses the file via an ODBC connection.
I can't find how or where the file is being populated.

The file is a local file

I did a DSPPGMREF of every program on the system and the object is not
referenced in any program.
Using Navigator I looked at every procedure in the library where the
file is stored I scanned every piece of source code on the system to
find a reference to the file There are only four SQLPKG objects in the
library and none of them reference the file

How do I find out how this file is being populated? What am I missing?

Kind Regards,

Thomas Garvey

--
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.