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

["Sumana.Akella" <Sumana.Akella@kiewit.com>]

Thanks 

-----Original Message-----
From: sqr-users-bounces+sumana.akella=kiewit.com@sqrug.org
[mailto:sqr-users-bounces+sumana.akella=kiewit.com@sqrug.org] On Behalf
Of Prasanth Pennepalli
Sent: Monday, October 30, 2006 11:07 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] (SQR 3716) Error in SQL statement.Error in
includefile

Sumana,

I had a similar problem with Peoplesoft SQR when running on MSSQL.  It
didn't allow complex FROM clauses (esp. SELECT statements in FROM
clause).   The work around was to prepare the SQL in a string and
execute.

Prasanth.

----- Original Message ----
From: Sumana.Akella <Sumana.Akella@kiewit.com>
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions. <sqr-users@sqrug.org>
Sent: Monday, October 30, 2006 12:06:23 PM
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