Re: [sqr-users] RE: sqr-users Digest, Vol 44, Issue 5

[maddy <madhudvm@gmail.com>]

Thanks Rebecca, there is nothing wrong in the program and we have
tried everything. Actually 4 senior developers are working on this
issue and also opened a ticket with Hyperion on this issue.

Thanks,
Maddy


On 10/11/07, Barilleaux, Rebecca <Rebecca.Barilleaux@anthem.com> wrote:
> This is just a shot in the dark, but I noticed that you are creating & 
>inserting into CID30_JP and selecting from RPT..CID30_JP.  Is it possible the 
>table is being created in some other database besides RPT?  Like maybe tempdb? 
> What happens if you leave off the RPT.. From the select statement, or add it 
>to your create table & insert statements?
>
> Thanks,
> Rebecca
>
> -----Original Message-----
> Date: Wed, 10 Oct 2007 14:44:20 -0400
> From: maddy <madhudvm@gmail.com>
> Subject: Re: [sqr-users] Challenging issue with Brio SQR in UNIX
> To: "the dragon" <ceprn@hotmail.com>
> Cc: "This list is for discussion about the SQR database reporting
>        language        from Hyperion Solutions." <sqr-users@sqrug.org>
> Message-ID:
>        <f09cef0f0710101144x3c61c7ceh11ca35577cb87af0@mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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 <ceprn@hotmail.com> 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 <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!
> -------------- next part --------------
> Cursor Status:
>
>  Cursor #1:
>   SQL = commit transaction
>  Compiles = 1
>  Executes = 1
>  Rows     = 0
>
>  Cursor #2:
>   SQL = if exists(select 1 from sysobjects where name ='CID30_JP'and
>         type='U') begin drop table CID30_JP end
>  Compiles = 1
>  Executes = 1
>  Rows     = 0
>
>  Cursor #3:
>   SQL = create table CID30_JP ( BLEI_BILL_LEVEL     char(1)  null,
>         BLEI_LST_TL_DUE_DT  datetime null, BLEI_LAST_BILL_DTM  datetime
>         null, BLEI_LST_BL_END_DT  datetime null, BLEI_SUSPND_BL_IND
>         char(1)  null, GRGR_ID             char(8)  null, SGSG_ID
>           char(4)  null, SBSB_ID             char(9)  null )
>  Compiles = 1
>  Executes = 1
>  Rows     = 0
>
>  Cursor #4:
>   SQL = commit transaction
>  Compiles = 1
>  Executes = 1
>  Rows     = 0
>
>  Cursor #5:
>   SQL = {call RPT..BERSP_EVENT_STEP_INSERT(?,?,?,?)}
>  Compiles = 0
>  Executes = 4
>  Rows     = 0
>
>
>  Cursor #6:
>   SQL = insert into CID30_JP ( BLEI_BILL_LEVEL, BLEI_LST_TL_DUE_DT,
>         BLEI_LAST_BILL_DTM, BLEI_LST_BL_END_DT, BLEI_SUSPND_BL_IND,
>         GRGR_ID, SGSG_ID, SBSB_ID ) select 'I', BLEI.BLEI_LST_TL_DUE_DT,
>         BLEI.BLEI_LAST_BILL_DTM, BLEI.BLEI_LST_BL_END_DT,
>         BLEI.BLEI_SUSPND_BL_IND, GRGR.GRGR_ID, null , SBSB.SBSB_ID from
>         fadfyin1..CMC_BLEI_ENTY_INFO      BLEI, fadfyin1..CMC_GRGR_GROUP
>               GRGR, fadfyin1..CMC_SBSB_SUBSC          SBSB where
>         BLEI.BLEI_BILL_LEVEL_CK  =   SBSB.SBSB_CK and SBSB.GRGR_CK
>            =   GRGR.GRGR_CK and BLEI.BLEI_BILL_LEVEL     =   'I' and
>         BLEI.BLEI_SUSPND_BL_IND in ('B','D','S') union select 'G',
>         BLEI.BLEI_LST_TL_DUE_DT, BLEI.BLEI_LAST_BILL_DTM,
>         BLEI.BLEI_LST_BL_END_DT, BLEI.BLEI_SUSPND_BL_IND, GRGR.GRGR_ID,
>         SGSG.SGSG_ID, null from fadfyin1..CMC_BLEI_ENTY_INFO      BLEI,
>         fadfyin1..CMC_GRGR_GROUP      GRGR, fadfyin1..CMC_SGSG_SUB_GROUP
>         SGSG where BLEI.BLEI_BILL_LEVEL_CK =   SGSG.SGSG_CK and
>         SGSG.GRGR_CK            =   GRGR.GRGR_CK and BLEI.BLEI_BILL_LEVEL
>          =   'S' and BLEI.BLEI_SUSPND_BL_IND in ('B','D','S') union select
>         'G', BLEI.BLEI_LST_TL_DUE_DT, BLEI.BLEI_LAST_BILL_DTM,
>         BLEI.BLEI_LST_BL_END_DT, BLEI.BLEI_SUSPND_BL_IND, GRGR.GRGR_ID,
>         null, null from fadfyin1..CMC_BLEI_ENTY_INFO      BLEI,
>         fadfyin1..CMC_GRGR_GROUP          GRGR where
>         BLEI.BLEI_BILL_LEVEL_CK =   GRGR.GRGR_CK and BLEI.BLEI_BILL_LEVEL
>          =   'G' and BLEI.BLEI_SUSPND_BL_IND in ('B','D','S')
>  Compiles = 1
>  Executes = 1
>  Rows     = 354
>
>  Cursor #7:
>   SQL = SELECT BLSU.BLEI_BILL_LEVEL, BLSU.BLEI_SUSPND_BL_IND, BLSU.GRGR_ID,
>         BLSU.SGSG_ID, BLSU.SBSB_ID,
>         convert(char(10),BLSU.BLEI_LST_TL_DUE_DT,101),
>         convert(char(10),BLSU.BLEI_LAST_BILL_DTM,101),
>         convert(char(10),BLSU.BLEI_LST_BL_END_DT,101)  from RPT..CID30_JP
>           BLSU order by BLSU.BLEI_BILL_LEVEL, BLSU.BLEI_SUSPND_BL_IND,
>         BLSU.GRGR_ID, BLSU.SGSG_ID, BLSU.SBSB_ID
>  Compiles = 1
>  Executes = 1
>  Rows     = 0
>
>  Cursor #8:
>   SQL = drop table RPT..CID30_JP
>  Compiles = 1
>  Executes = 1
>  Rows     = 0
>
>
> SQR: End of Run.
>
> ------------------------------
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>
>
>
> CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
> is for the sole use of the intended recipient(s) and may contain confidential
> and privileged information or otherwise protected by law.  Any unauthorized
> review, use, disclosure or distribution is prohibited.  If you are not the
> intended recipient, please contact the sender by reply e-mail and destroy
> all copies of the original message.
>
> _______________________________________________
> 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