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.)
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.
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.
