Page 1 of 1

DB2 inline comments

PostPosted: Mon Aug 29, 2011 3:13 pm
by marty
It's not possible to use inline comments with DB2, a limitation I myself find quite strange. Queries with additional information like
SELECT Names --Usernames
FROM Users

are not possible because of the comment after the select.
Can the parser be configured to ignore '--'-style comments as well as /* ...*/?

Re: DB2 inline comments

PostPosted: Mon Aug 29, 2011 5:31 pm
by Support
That's pretty strange.
Inline (or multiline) comments are completely acceptable inside of SQL queries in any SQL dialect. It was tested for different databases (at least Oracle, DB2 and MS SQL).
So it looks like a bug. Probably it is related to the difference of EOL character in UNIX/Windows systems.

Could you say what OS version do you use? And what DBeaver version.
Thanks!

Re: DB2 inline comments

PostPosted: Tue Aug 30, 2011 8:17 am
by marty