RE: [sqr-users] (SQR 3716) Error in SQL statement.Error in includefile

["Knapp, Richard" <KnappR@umsystem.edu>]

The code after the union (or any set operator) has to be straight SQL
(no SQR).  So your SQR concatenate thingys (||) throw the parser into a
tailspin.

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Steve Cavill
Sent: Sunday, November 05, 2006 8:47 PM
To: 'This list is for discussion about the SQR database
reportinglanguagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] (SQR 3716) Error in SQL statement.Error in
includefile

This line doesn't look right:
where calendar_year = 2004)) || '    '

Run the code with the -s option to see the actual sql sent to the
database.
Steve. 

-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On
Behalf Of Sumana.Akella
Sent: Tuesday, 31 October 2006 7:06 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: [sqr-users] (SQR 3716) Error in SQL statement.Error in include
file

When I run the below code ....
I get these 2 errors 
   Error in include file sqr\curdttim.sqc
  (SQR 3716) Error in SQL statement.
 

Begin-select
distinct export
from(
select
          '11100' || d.SSN || substr(d.SSN, 6, 4) ||
to_char(p.birthdate, 'YYYY') || substr(d.ye_lname, 1, 20) 
          || substr('                    ', 1, 20-length(d.ye_lname)) ||

           substr(d.ye_fname, 1, 15) || substr('               ', 1,
15-length(d.ye_fname)) ||  
           substr(d.ye_middle_name, 1, 1) || substr(' ', 1,
1-length(d.ye_middle_name)) export   
from 
     ps_ye_data d inner join ps_person p on d.emplid = p.emplid 
         and calendar_year = 2005
        and     d.emplid = '008522'
 ) a
 
UNION ALL

select '********' || to_char((select count(distinct ssn) from ps_ye_data
where calendar_year = 2004)) || '    '
from 
    dual

end-select

Thanks
Sumana

_______________________________________________
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