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

[franck.masson2002@laposte.net]

what happen if you add a commit statement after the Insert and before the 
select statement ?





> Message du 10/10/07 20:47
> De : "maddy" 
> A : "the dragon" 
> Copie à : "This list is for discussion about the SQR database reporting 
>language  from Hyperion Solutions." 
> Objet : Re: [sqr-users] Challenging issue with Brio SQR in UNIX
>
> Hi dragon,
> 
> Thanks for your quick response.By mistake I had sent you the wrong
> file with Cursor information. Please take a look at the new file
> attached.
> 
> 
> Thanks,
> Maddy
> 
> 
> 
> On 10/10/07, the dragon wrote:
> > 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' 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
> >
> > >
> > > 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 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 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!
> >
> [ CID30_Cursor_Info.txt (4.3 Ko) ]
> [ (pas de nom de fichier) (0.1 Ko) ]

Créez votre adresse électronique prénom.nom@laposte.net
1 Go d'espace de stockage, anti-spam et anti-virus intégrés.

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