[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] Dynamic Hints ?


Is it possible to have dynamic HINT statements in an SQR?
Here is a sample of my code... that does NOT work.
Any suggestions would be greatly appreciated!
=======================================
begin-program
   let $sw = '1'
   if $sw = '1'
      let $hint = '/*+ INDEX(HDR PS1BI_HDR) */'
   ELSE
      let $hint = '/*+ INDEX(HDR PSEBI_HDR) */'
   end-if
begin-select
[$hint]
count(*) &count
      SHOW 'COUNT = ' &COUNT
from PS_BI_HDR HDR
end-select
end-program
=======================================
This is the error message I get:


Error on line 17:
   (SQR 3743) Dynamic columns must have a &pseudonym.
[$hint]


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users