kuronen Super Contributor.
Super Contributor.
210 views

FYI: Hyphen in MS SQL view name

As a NetIQ JDBC driver developer if you happen to use hyphen "-" character in your view name and you are using Microsoft SQL Server you may have gotten across a very informative JDBC error message telling you that the storage does not support rollback.

This is it's very special way of telling you that you cannot use "-" in view name without "{}" characters in your SQL SELECT statement. This is easily remedied by removing the hyphens (just did that) or using syntax {view-name} (did not try that).

edit: May apply to other SQL brands as well. Did not try.
Labels (1)
0 Likes
1 Reply
Highlighted
Knowledge Partner
Knowledge Partner

Re: FYI: Hyphen in MS SQL view name

Thanks for sharing that information.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.