RE: [sqr-users] oracle hint in sqr

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

Are you sure about the comments on /*+ index_join(FA_STU_TERM_STI1)*/ ?
In Begin-Select statement, We generally comment the fields by placing --
before that field.

-----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 6:06 PM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] oracle hint in sqr


I delete the & A.STU_NSLDS_LOAN_YR    and it is still not working....
-----Original Message-----
From: sqr-users-bounces+zhpan=indiana.edu@sqrug.org
[mailto:sqr-users-bounces+zhpan=indiana.edu@sqrug.org] On Behalf Of
Krishna Chennamaneni
Sent: Friday, July 23, 2004 5:08 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] oracle hint in sqr

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

_______________________________________________
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