Comment sign in external sql file

[#1]

Hello!

For loading data from databse tables I use exteranal sql-script files attaching it like this:

$(Include=rows.sql);

Before start loading I debug query in Database Query Analyser.

The problem is in comments. SQL comment style looks like:

-- My Comment

But signs "--" cause error in QlikView.

QlikView comment style "//" causes error in SQL Query Analyser.

How can I write comments in external sql-script so that still work in Query Analyser?

[jonathandienst · Accepted solution]

Hi

I am not sure how you are using this particular include file, but it is no different than anywhere else in the script. Statements executed by SQL server (ie after a SQL statement up to the closing ; sign) need -- SQL comments, and all other statements need // QV comments.

HTH

Jonathan

[bbi_mba_76]

Hi,

maybe you could use the /* */ notations.

[#4]

Hi Pavel,

You can use find and replace functionality and replace all -- with // in your external script.

Thanks & Regards

Suhas Gupta

[#5]

Thank you very much Jonathan!

It realy works!

[jonathandienst]

Michele Barini wrote:

Hi,

maybe you could use the /* */ notations.

Good suggestion - that would also work.