RE: [sqr-users] Challenging issue with Brio SQR in UNIX

["Bambach, Tom" <TBambach@genchemcorp.com>]

Maddy,

See if making the select statement dynamic helps - ie,

let $where = 'WHERE A.FIELD=' || chr(39) || $var || chr(39)

then in the select statement:

:
:
FROM table A
[$where]
:
:


I've had issues like you describe that were inexplicably
solved by putting the WHERE statement in a variable...

Tom

-----Original Message-----
From: maddy [mailto:madhudvm@gmail.com] 
Sent: Thursday, October 04, 2007 6:02 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: [sqr-users] Challenging issue with Brio SQR in UNIX

Hi,

We have a strange problem with all the Brio SQR Programs executing under
UNIX environment.All these programs are working fine and giving data
when executed in windows environment and giving no data in UNIX
enviroment.

We are creating a temp table and  inserting data in the SQR program but
unable to Select the data from the same table and print it on to the
report.However when the ORDER BY clause in the select statement is
commented out, data is pulled on to the report.

If I run the same program again without droping and creating the table
we get the data from the table even with ORDER BY clause which is
strange.
How can a ORDER BY clause in the SELECT statement cause this kind of
issue ? I can send the skeleton program if any of the experts can look
into this issue.

Environment: Hyperion 8.5 installed on UNIX (AIX)

Thanks,
Maddy



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