RE: How is this file populated?

Cute, Rob.

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

I agree that journaling is the best option.
If you're at war with journaling I hear there's this company called Unbeaten Path which has a product to log changes.
Or you could slap a trigger on the file to log updates.

On Tue, May 23, 2023 at 6:04 PM <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.

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