Native SQL

Tony Coffman -

 

VDM features a Native SQL option that was developed specifically for use with Universe databases.  When enabled VDM will wrap the SQL statement with the {NATIVE} command, extending SQL syntax to include Left, Right and Inner Joins. 

When the Native SQL option is enabled on a Universe database, the Use Table Alias feature should be disabled.  Universe databases do not accept table aliases when using Native SQL.

To enable Native SQL, click on the "View Options" ribbon menu, click "Database Functions" and check "Native SQL".  Next, disable "Use Table Alias".

 

After enabling "Native SQL" and disabling "Use Table Alias", click "View SQL Query" to verify Native SQL command is wrapped around the SQL Query.

 

Note: The Native SQL option is only available when building a query using the Standard Query Builder Interface.  If you are using an Advanced Query and need access to Left, Right and Inner Join statements, wrap your query with the {NATIVE "Select Statement"} command.

Have more questions? Submit a request

Comments