Re: Extract new rows only from a table with SQL to SQL server

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

Not familiar with JDE.  In BPCS (aka InforLX) all RPG access is via their
logical files.  All their logical files name the individual fields.  Just
on a whim I made their RCO table a temporal table and added several columns
necessary for that.  I did not disrupt a single program of theirs.  No
recompiling.  No recreating of logical files.
Keep in mind that much of this code might have originated on S36 or S38 and
got lightly upgraded over the years.

The RCO table has one row for each company you are.  If you only have been
one company for several years then it might have one row.  We've been
through a few mergers and acquisitions so have a few more but fingers might
count them all.

On Tue, Sep 23, 2025 at 5:54 PM Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
wrote:

> The current process running has an SQL server using ODBC running a query
> against a IBM i table with 6 million rows (table scan, no selection
> criteria) and updating a SQL server table every night.
>
> Right now, the process is a refresh of the 6 million rows on SQL server.
> In reality we only need the newest rows since the last run.  Ordinarily I
> would just use a timestamp  on the table to pull rows since a specific
> time, but this table does not have a timestamp on it (JDE supplied table so
> I cannot modify it)
>
> Is there a way we can use SQL to get only the newest rows on the table?
> (Triggers are not available for the same reason I can’t modify the table)
>
> My guess is no, without a timestamp we cannot, but hopefully someone will
> have an enlightened answer.
>
> Might temporal tables play in this scenario?
>
>
> --
> Jim Oberholtzer
> Agile Technology Architects
>
>
>
>
> --
> 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.