Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Oracle SQL Select Statement with "Hint"

set StripComments=0;

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

set StripComments=1;


talk is cheap, supply exceeds demand
2 Replies

Re: Oracle SQL Select Statement with "Hint"

set StripComments=0;

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

set StripComments=1;


talk is cheap, supply exceeds demand
fortuinw
New Contributor

Re: Oracle SQL Select Statement with "Hint"

Hi Tim

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

Regards

Wayne

Community Browser