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

That is my understanding...

Haven't actually played with them.

Charles

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

The temporal table would be outside of the application and definitely
have timestamps, but the file the temporal table is based on, does it need
the timestamp?
--
Jim Oberholtzer
Agile Technology Architects

On Sep 23, 2025, at 5:10 PM, Charles Wilt <charles.wilt@xxxxxxxxx>

wrote:

If you can't add a timestamp, how would you be able to make it a temporal
table?

Seems like a better solution would be to journal the table and process

the

journal entries.

Possibly making use of the (new'ish) QSYS2.DISPLAY_JOURNAL() table

function.

https://www.ibm.com/support/pages/node/1136710

HTH,
Charles

On Tue, Sep 23, 2025 at 3: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.

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