You can translate the question and the replies:

Delegate SQL Sentence as Sub Query Option

I'm creating a base view from query that contains a CTE and getting 'Incorrect syntax near the keyword 'WITH'.' The statement runs fine in SQL, so I know it's valid. I believe I found the fix (steps below) in this Q&A https://community.denodo.com/answers/question/details?questionId=9060g00000009gxAAA&title=Using+CTE+WITH+clause+for+creating+base+view+from+query but under the Search Method tab under Options, I do not have wrapper source configuration options. The only configurable option in that tab is to create an alternative wrapper. I'm on version 8.0 and searched everywhere and can't find that Delegate option. My data source is JDBC and from what I read, should have this option. • Open the base view you created using the "Create from query option" • Goto Options >Search Methods > wrapper source configuration options. • Now change the "Delegate SQL Sentence as Sub Query to "No" and save the view Where is this "Delegate SQL Sentence as Sub Query" option??
user
16-02-2024 00:32:45 -0500
code

4 Answers

Hi, I understand that you were not able to find the **Delegate SQL Sentence as subquery** option. However, I tried to create a view using the “Create base view from query� option in the Virtual DataPort Administration Tool and I was able to find this option by navigating to the `Options > Search Methods > Wrapper source configuration` options. Please refer to this [document](https://community.denodo.com/kb/en/view/document/using%20the%20create%20base%20view%20from%20query%20option#:~:text=the%20option%20%E2%80%98-,Delegate%20SQL%20sentence%20as%20subquery,-%E2%80%99.%20This%20option), for more information related to Creating base view from Query option. Hope this helps!
Denodo Team
16-02-2024 07:48:00 -0500
code
The option does not exist on the view. I would post a screenshot, but it won't let me. Under the Search methods tab, these are the following options I have: **I18n options** Default i18n - configurable and set to us_est **Search methods** Method name - testcte Main wrapper - testcte Alternative wrappers - Option to Add alternative wrapper Mandatory fields - none
user
20-02-2024 10:54:59 -0500
Hi, I understand that you are not able to view the wrapper source configuration option as it is not available in the Web Design Studio, however the wrapper source configuration option can be seen in the Virtual DataPort Administration Tool. If you have a client tool, you could try setting the **Delegate SQL Sentence as a subquery** to `No` and execute the view by following the steps mentioned in the previous comments. In case, if you do not have a client tool to modify this view, then please add the below query to the **VQL** of the desired view, under the <source configuration property> section of the CREATE [OR REPLACE] WRAPPER JDBC statement. ``` SOURCECONFIGURATION ( delegatesqlsentenceassubquery = false, ) ``` For more information, please refer to the [JDBC WRAPPERS](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/generating_wrappers_and_data_sources/creating_wrappers/jdbc_wrappers#:~:text=DELEGATESQLSENTENCEASSUBQUERY) section under the Virtual DataPort VQL Guide document. If you are a valid support user, you can raise a [Support Case](https://support.denodo.com/cases/add), for further assistance from the Support Team. Hope this helps!
Denodo Team
21-02-2024 06:15:17 -0500
code
I see the error of my ways now. I did not pick up on the fact that you had to use a completely different tool. Thank you!
user
21-02-2024 08:44:57 -0500
You must sign in to add an answer. If you do not have an account, you can register here