nesting_1.htm
| Navigation: SQL Driver Strings(General) >====== NESTING ====== |    |
DRIVER('SQLDriver', '/NESTING = TRUE | FALSE ' )
[ Nest“ = ] SEND(file, '/NESTING [ = TRUE | FALSE ]' )
(NOTE: Not valid for ORACLE Accelerator)
Some SQL drivers do not support parent→child→grandchild style views. The SQL driver attempts to determine if this is supported. If the driver does not get it right and the backend does not support these type of views, then you need to set NESTING=FALSE. This causes the join to be done on the client.
In the case where the DBMS does support parent→child→grandchild style views, yet the corresponding ODBC client reports that it does not, you can force the driver to issue the proper commands for Nested SQL Joins by setting NESTING=TRUE.
nesting_1.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1