Re: Pass thru queries WAS: Maximum OBDC Query Size

Not quite...

I think most RDBMS type applications offer the option for a "pass through
query" when connecting to an RDBMS of a different vendor.

Oracle for instance...
https://docs.oracle.com/en/database/oracle/oracle-database/18/heter/passthrough-sql.html#GUID-C03895FB-EE60-4F71-8943-994C185C2EB2
"The passthrough SQL feature enables you to send a statement directly to a
non-Oracle system without first being interpreted by Oracle Database."

Db2
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0002176.html
"The SET PASSTHRU statement opens and closes a session for submitting a
data source's native SQL directly to that data source."

I think most RDBMS's aren't as dumb as MS products about trying to pull
back the entire table, so the requirement for a pass through query isn't
quite as in your face.

Charles


On Tue, Apr 9, 2019 at 8:31 AM John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

There is a more fundamental point to be made: The whole concept of a
"pass through query" is, as far as I'm aware, strictly a Microsoft
database thing. The term doesn't even exist when we're talking about
any other database.

If neither the client nor the server is a Microsoft product, then you
can be extremely confident that the ONLY kind of query is what
Microsoft would call a "pass through query". The rest of us just call
it a "query".

John Y.
--
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@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com