1.

Define Pass-through Sql?

Answer»

Pass-Through SQL lets you use native SQL without any of the restrictions the data SOURCE imposes on sub queries.

ADVANTAGES:

You can ENTER any SQL SUPPORTED by the DATABASE.

Disadvantages:

There is no opportunity for Frame work manager to automatically optimize performance. The SQL may not work on a different data source.

Pass-Through SQL lets you use native SQL without any of the restrictions the data source imposes on sub queries.

Advantages:

You can enter any SQL supported by the database.

Disadvantages:

There is no opportunity for Frame work manager to automatically optimize performance. The SQL may not work on a different data source.



Discussion

No Comment Found