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

[the dragon <ceprn@hotmail.com>]

I guess my primary question is *why* would you ever be creating a temp table 
and putting crap into it to start with?  That is so inefficient and one of the 
primary reason that the abortion called App Engine sucks so badly.  Just select 
your data and process it.  If this is a program that gets run regularly, and 
you absolutely need a temp table, just build a real table in app designer/your 
database and truncate it before running the program.

OK, now on to your question...  Your program should be working OK,  If it works 
in Windoze, it will work on Unix.  There may be some system variable causing 
the issue, like a memory constraint, but I don't see that as an issue.  Run 
your program in debug mode and with the -s flag in Unix and see what you get.  
If the sqr creates the table, and populates it, then the data is there for 
selection and use.

Are you getting any errors?  Like snapshot too old, or unable to extend temp 
segment??? Also, what database are you using?  Informix?  Perhaps it's not 
committing the data to the table before the select and it uses a different 
thread to do the select than the one used for the insert (real databases don't 
have this problem). 

Sure send us the program, and give us information about the 
environment/platform.

peace,
clark 'the dragon' willis

PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the only 
real finite asset that you have, and once used it can never be recovered, so 
don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you can 
determine how it will be spent. Be careful lest you let other people spend it 
for you." -- Carl Sandburg (1878 - 1967)

It is impossible to defeat an ignorant man in argument. -- William G. McAdoo

Religion is regarded by the common people as true, by the wise as false, and by 
the rulers as useful. -- Seneca

"I distrust those people who know so well what God wants them to do because I 
notice it always coincides with their own desires." - Susan B. Anthony

> Date: Thu, 4 Oct 2007 18:01:47 -0400
> From: madhudvm@gmail.com
> To: sqr-users@sqrug.org
> 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
>

_________________________________________________________________
Climb to the top of the charts!  Play Star Shuffle:  the word scramble 
challenge with star power.
http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct

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