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

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

Sounds like the inserts are not being committed.  Running on Windows vs Unix 
implies a different driver, so it's possible one is
doing some sort of autocommit.
Try adding appropriate commit's to your code to see if that makes a difference.
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 maddy
Sent: Friday, 5 October 2007 8:02 AM
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



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