[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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

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