You can translate the question and the replies:

Workaround for double quotes around database name in queries

I'm trying to see how I can configure my database to not need the double quotes around the database name when using queries in the VQL Shell. I realize there is a Restricted vs Unicode configuration that I think I've turned on, but I'm still having to put double quotes around the database name. For example, we have 2 databases, DB1 and DB2. **From DB2**, I use the following query and it doesn't work stating that the "view cars1 not found" even though there is a base view called cars1 in DB1. ``` select count(0) from DB1.cars1 where col1 like 'A%'; ``` In order for this to work, I have to put the double quotes around the "DB1" part, and the query returns a result. How do I change this configuration so I don't have to put the double quotes around the database name each time when using VQL Shell.
double quote unicode Database Denodo 8.0 Vql shell
user
16-02-2021 10:20:52 -0500
code

1 Answer

Looks like I found my own answer - when I created the database, it was created with Unicode configurations, but later edited to Restricted. Looks like you need to CREATE the database with the Restricted configuration and queries will work like I need them to.
user
16-02-2021 11:48:05 -0500
You must sign in to add an answer. If you do not have an account, you can register here