topic Re: Comment sign in external sql file in QlikView

Comment sign in external sql file

Thu, 24 Apr 2014 10:41:59 GMT

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?

Re: Comment sign in external sql file

jonathandienst — Thu, 24 Apr 2014 11:00:55 GMT

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

Re: Comment sign in external sql file

bbi_mba_76 — Thu, 24 Apr 2014 11:01:44 GMT

Hi,

maybe you could use the /* */ notations.

Re: Comment sign in external sql file

Thu, 24 Apr 2014 11:08:55 GMT

Hi Pavel,

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

Thanks & Regards

Suhas Gupta

Re: Comment sign in external sql file

Thu, 24 Apr 2014 11:17:41 GMT

Thank you very much Jonathan!

It realy works!

Re: Comment sign in external sql file

jonathandienst — Thu, 24 Apr 2014 12:04:31 GMT

Michele Barini wrote:

Hi,

maybe you could use the /* */ notations.

Good suggestion - that would also work.