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

[maddy <madhudvm@gmail.com>]

I have tried adding commit statements before and after each query and
still see the same issue.

On 10/10/07, franck.masson2002@laposte.net
<franck.masson2002@laposte.net> wrote:
> 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
>

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