Re: Pass thru queries WAS: Maximum OBDC Query Size

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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