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

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

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