Tuesday, June 6, 2017
Tip of the Day: Enhanced Server Table PASSTHROUGH Functionality
Product.......: R:BASE X and R:BASE X Enterprise (Version 10)
Build.........: 10.0.2.20530 or higher
Section.......: Commands
Keywords......: ODBC, PASSTHROUGH, Server Table, Foreign Data Source, SQL
Did you know the PASSTHROUGH operating condition allows R:BASE to send commands
directly to a foreign data source, have the queries processed by the server
system, and actually use functions that are only defined on the
external source?
Recent R:BASE enhancements also include an enhanced process with the
PASSTHROUGH
setting, where structured query language can be used upon server
tables, without
attaching the external tables to R:BASE.
If PASSTHROUGH is set to ON and a foreign database is connected with SCONNECT,
the following will happen with a SELECT command:
01.
If the table is a regular R:BASE table, the command works normally.
02.
If the table is a foreign data source table already attached with SATTACH, the
query is sent directly to the ODBC server and the returned values are shown.
03.
If the table is not known to R:BASE at all, as either an R:BASE table
or a foreign
data source table, the query is sent directly to the ODBC server. If the server
cannot process the query, an error is returned. If the server can process the
query, the SELECT will work.
The "SELECT...INTO" command syntax can also be used to place values
into variables.
SELECT CustomerID,EmployeeID INTO vCustID INDI iv1, vEmpID INDI iv2 +
FROM dbo.Orders WHERE OrderID = 10263
With PASSTHROUGH set to ON, you can actually use functions that are
only defined
on the server system in a SELECT command, because those functions get "passed
through" to the server for processing.
When PASSTHROUGH is ON, only the SELECT command will work with a
server table that
is not SATTACHed. If you want to INSERT, UPDATE, or DELETE data to a
server table
that is not SATTACHed, then you must use the SSQL command.
Covering all aspects of ODBC use with foreign SQL data sources is available
within the "Using SQL Data Sources in R:BASE" technical document:
From The Edge: http://www.razzak.com/fte/
Article Title: Using SQL Data Sources in R:BASE X and R:BASE X
Enterprise (Version 10)
One of the most important aspects in business growth is your company
data, and no
one else has more invested in your success than R:BASE Technologies.
Invest forward
with R:BASE!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
34 years of continuous innovation!
19 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
