RE: [sqr-users] oracle hint in sqr

[Krishna Chennamaneni <krishna.chennamaneni@jhuapl.edu>]

Try this

                 BEGIN-SELECT distinct  

            /*+ index_join(FA_STU_TERM_STI1)*/

            A.PRSN_UNIV_ID               

            a.prsn_prm_full_nm

            A.ACAD_TERM_CD

            A.STU_NSLDS_LOAN_YR         &StuLoan

It should work fine.

Krishna




-----Original Message-----
From: sqr-users-bounces+krishna.chennamaneni=jhuapl.edu@sqrug.org
[mailto:sqr-users-bounces+krishna.chennamaneni=jhuapl.edu@sqrug.org]On
Behalf Of Pan, Zhen
Sent: Friday, July 23, 2004 5:52 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] oracle hint in sqr


Hi,

            I am using SQR Developer 8.1. I wanted to use hint in my sqr

 

            BEGIN-SELECT distinct  

            /*+ index_join(FA_STU_TERM_STI1)*/

            A.PRSN_UNIV_ID               

            a.prsn_prm_full_nm

            A.ACAD_TERM_CD

            A.STU_NSLDS_LOAN_YR         &A.STU_NSLDS_LOAN_YR1  

            ...........

 

            when I compile it, it says

Error on line 284:

   (SQR 7740) Invalid &pseudonym or 'TYPE=' data-type specified

for a begin-select column-variable.  Valid types are:

CHAR, TEXT, DATE, NUMBER

 

      if &A.ACAD_LOAD_IND='F'

(SQR 4407) Referenced variables not defined:

 

  &a.acad_load_ind

 

            This query runs fine in Toad. I inititally thought it was
because the spaces in front of the hint, but it gave me errors too. If I
run it under Unix box it won't complain but it will run forever. (I
suspect it is not taking the hint)

            Any idea? Thanks a bunch!

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

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