Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Oracle SQL Select Statement with "Hint"

If I code an Oracle SQL select statement in my loadscript and I include an Oracle "hint" - does anyone know if QlikView passes the hint along to the database as part of the sql query? The reason I'm asking is that when I view the code in the loadscript editor the hint part of the statement is colored like a comment and I'm concerned that comments in the loadscript code don't get passed to the database.

For example, the "hint" part of the syntax in the following statement is the /*+PARALLEL*/ text:

SELECT /*+PARALLEL*/ NAME, BALANCE FROM BIGTABLE;

Thanks

1 Solution

Accepted Solutions
Gysbert_Wassenaar

set StripComments=0;

SELECT /*+PARALLEL*/ NAME, BALANCE FROM BIGTABLE;

set StripComments=1;


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

set StripComments=0;

SELECT /*+PARALLEL*/ NAME, BALANCE FROM BIGTABLE;

set StripComments=1;


talk is cheap, supply exceeds demand

View solution in original post

fortuinw
Contributor
Contributor

Hi Tim

you could also change your hint to use the --+ instead of /*+ */. That should Also work.

Regards

Wayne