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

[the dragon <ceprn@hotmail.com>]

The sqr failed to make it through, but the -s looks to me like it is working 
correctly - 354 rows are inserted, and 354 are selected afterwards.  I guess my 
question is what makes you think it isn't working?
 
peace,
clark 'the dragon' willisPSA: 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> > Hi,> > I have tried all the various things mentioned in the 
chain of emails> but still have the same issue. The issue is with commit 
statement but> not sure why it is not working with ORDER BY clause in the 
SELECT> statement.> > Please take a look at the attached SQR program and the 
cursor> information when compiled with -S flag.> > > Thanks!!> Maddy> > > 
Environment : Hyperion 8.5.0.0.0.566/IBM RS6000/AIX 5.2/ODBC DataDirect 5.1> 
Database : Sybase 12.5> > On 10/9/07, George Jansen <GJANSEN@aflcio.org> 
wrote:> > 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> >
_________________________________________________________________
Help yourself to FREE treats served up daily at the Messenger Café. Stop by 
today.
http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctWLtagline

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