topic Re: Creating a Hint in the script editor agains SAP in QlikView

Creating a Hint in the script editor agains SAP

Tue, 08 Apr 2014 16:32:04 GMT

I am attempting to optimize the QVD I am building against SAP & would like to apply this hint:

SET StripComment=0;

SQL SELECT /*+ FIRST_ROWS(30) */ Column1 Column2 .... FROM Table WHERE x = y;

SET StripComment=1;

The error is :

/QTQVC/OPEN_STREAM failed after 00:00:00 Key=SQL_ERROR (ID:00 Type:E Number:001 Uknown column name "/*+" until runtime, you cannot specify a field list.)

SQL

Any thoughts or suggestions?

Thanks!

Re: Creating a Hint in the script editor agains SAP

ToniKautto — Tue, 08 Apr 2014 17:22:49 GMT

My interpretation is that you want /*+ FIRST_ROWS(30) */ to act as a script comment. From the script error the syntax is not recognized as valid by the connector or data source.

My suggestion is taht you add your comment before or after the SQL SELECT to make the syntax valid.

Re: Creating a Hint in the script editor agains SAP

Wed, 09 Apr 2014 12:02:46 GMT

No I am wanting to apply the hint to the SQL. I am setting the code to not recognize the /* */ as a comment then resetting it after the select statement. I am attempting to pull roughly 200 mil records from SAP but not sure the QVD generator is the way to go.