Re: How is this file populated?

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

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.