Re: Sever pulling a bazillion rows from IBMi via JDBC (I think)

replied on the Java list
https://archive.midrange.com/java400-l/202509/msg00000.html

Charles

On Tue, Sep 2, 2025 at 9:21 AM Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

JDBC has zero relation to Linked Servers...

Charles

On Tue, Sep 2, 2025 at 9:12 AM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

Does JDBC do it's sorting and selecting on the server, or the client?
Something about "linked server"

I have some old notes from this list.

*openquery is just MS SQL Server’s technique for a “linked server”. Some
sql engines always do it. Some do it within setup or connection
configuration.*



*openquery:*

*I assume you're trying to set up a linked server?*

*https://www-01.ibm.com/support/docview.wss?uid=nas8N1014514*
<https://www-01.ibm.com/support/docview.wss?uid=nas8N1014514>













* Once you get connected, note the following: -- Pull all rows from the
table(s) back to MS SQL server and do the where locally select * from
LINKEDSVR.MYIBMI.MYLIB.MYTBL where locnbr = '00335'; -- Sends the
statement
to linked server for processing select * from openquery(LINKEDSVR, 'select
* from MYTBL where locnbr = ''00335'''); --OPENQUERY() isn't just for
SELECTS delete from openquery(LINKEDSVR, 'select * from MYTBL where locnbr
= ''00335''');*

On Tue, Sep 2, 2025 at 9:52 AM <smith5646midrange@xxxxxxxxx> wrote:

We have a server that is pulling a bazillion rows via JDBC (I think)

daily.

Unfortunately, we are stuck with this process as is for a while until we
can
get a project on the plan to pull only net changes. It currently runs

for

2-3 hours each day.



What is the fastest way to pull this data? Will it be faster to omit

the

order by clause and just let SQL hand back data in whatever order that

it

wants or would it be quicker to add an order by clause. It seems like
having an order by clause would slow it down because the file is not in

any

particular sequence but I also didn't know if an order by RRN would

help.

Any thoughts (other than rewriting the process which is in the plans but
probably not for this year)?

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