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

["George Jansen" <GJANSEN@aflcio.org>]

It strikes me that an ORDER BY clause means sorting, sorting means the use of 
temporary space, and this could be limited.

As for the location, are you using Oracle? With Oracle you could under some 
circumstances be connecting through a shared server (sorting in the shared 
pool) and in others connecting through a dedicated server.

>>> maddy <madhudvm@gmail.com> 10/4/2007 6:01 PM >>>
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