RE: [sqr-users] $sqr-program

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

Kevin found that $sqr-program has the right value, but the show command
doesn't display it correctly.  The XCB option replaces the communication box
with Windows dialog boxes.  The XMB option disables error message display.
If we don't have displays, we won't see the screen output of the show
command, and the bug "disappears."

-----Original Message-----
From: Prasanth Pennepalli [mailto:pprasanth@yahoo.com] 
Sent: Friday, May 19, 2006 3:09 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] $sqr-program

I don't think there is any relation between Hyperion
versions of SQR and Peoplesoft SQR.

For the SQR env variable $sqr-program, use one of the 
-xcb or -xmb flags on the sqr command line.  That
should work.

--- kevin.reschenberg@sparkpath.com wrote:

> Steven, I'm seeing the same weird behavior (using
> PeopleSoft version 8.47 for Oracle, which I think is
> similar to Hyperion version 6.something).
>  
> show $sqr-program       ! nothing shows 
> let $x = $sqr-program || ' '
> show $x                 ! shows the correct value
> print $sqr-program ()   ! displays the correct value
> (in the .LIS file)  
>  
> So if you concatenate a non-empty string with
> $sqr-program and then show the result, that works. 
> If you concatenate an empty string it still doesn't
> work.
>  
> All of this might be version-dependent.
>  
>  
> Kevin Reschenberg
> SparkPath Technologies, Inc.
>  
> sparkpath.com | sqr-info.com
> 
> 
> > -------- Original Message --------
> > Subject: RE: [sqr-users] $sqr-program
> > From: "Alexander, Steven"
> <Steven.Alexander@sanjoseca.gov>
> > Date: Fri, May 19, 2006 9:54 am
> > To: "'This list is for discussion about the SQR
> database
> > reportinglanguage from Hyperion Solutions.'"
> <sqr-users@sqrug.org>
> > 
> > It doesn't work for me.  Is there something in the
> SQR command line that I'm
> > including or omitting that affects this variable? 
> Or is there an include
> > file I need?
> > 
> >
>
\\Hera\Psoft8\Psoft815\PROD\bin\sqrps\sqr\ora\BINW\sqrw.exe
> > "c:\sqr\abs003.sqr" PROD/********@**** -B1000 -C
> -D -Fc:\sqr\ 
> >
> -I:\psoft815\prod\sqr\csj_sqr\;h:\psoft815\prod\sqr\
> -Oc:\sqr\abs003.log -S
> > -ZIFc:\sqr\pssqr.ini -debugt PROD
> > 
> > -----Original Message-----
> > From: Paul Hoyte
> [mailto:pi_hoyte@si-proservices.com] 
> > Sent: Thursday, May 18, 2006 6:34 PM
> > To: 'This list is for discussion about the SQR
> database
> > reportinglanguagefrom Hyperion Solutions.'
> > Subject: RE: [sqr-users] $sqr-program
> > 
> > Steve:
> > 
> > begin-program
> > 
> > 
> >     show 'SQR-PROGRAM.......'  $sqr-program
> > 
> > 
> > end-program 
> > 
> > This works.........
> > 
> > 
> > 
> > Paul Hoyte
> > (248) 752-6970
> > pa_hoyte@si-proservices.com
> > 
> > -----Original Message-----
> > From:
>
sqr-users-bounces+pi_hoyte=si-proservices.com@sqrug.org
> >
>
[mailto:sqr-users-bounces+pi_hoyte=si-proservices.com@sqrug.org]
> On Behalf
> > Of Alexander, Steven
> > Sent: Thursday, May 18, 2006 4:07 PM
> > To: 'This list is for discussion about the SQR
> database
> > reportinglanguagefrom Hyperion Solutions.'
> > Subject: RE: [sqr-users] $sqr-program
> > 
> > Thanks for the suggestions, Roger and Peter, but I
> had this problem in the
> > following code:
> > 
> > Begin-program
> >   Show 'SQR-PROGRAM = "' $sqr-program '"'
> > End-program
> > 
> > 
> > 
> > 
> > -----Original Message-----
> > From: Roger.Harris@certegy.com
> [mailto:Roger.Harris@certegy.com]
> > Sent: Thursday, May 18, 2006 11:02 AM
> > To: This list is for discussion about the SQR
> database reporting
> > languagefrom Hyperion Solutions.
> > Subject: Re: [sqr-users] $sqr-program
> > 
> > My first thought is that you are trying to
> reference $sqr-program in a local
> > procedure. If that is the case you will need to
> use $_sqr-program as with
> > all global variables in a local procedure,
> > 
> > 
> > 
> > 
> > 
> >
>
|---------+---------------------------------------------------->
> > |         |           "Alexander, Steven"         
>             |
> > |         |          
> <Steven.Alexander@sanjoseca.gov>         |
> > |         |           Sent by:                    
>             |
> > |         |          
> sqr-users-bounces+roger.harris=certegy.co|
> > |         |           m@sqrug.org                 
>             |
> > |         |                                       
>             |
> > |         |                                       
>             |
> > |         |           05/18/2006 01:55 PM         
>             |
> > |         |           Please respond to "This list
> is for      |
> > |         |           discussion about the SQR
> database        |
> > |         |           reporting  language from
> Hyperion        |
> > |         |           Solutions."                 
>             |
> > |         |                                       
>             |
> >
>
|---------+---------------------------------------------------->
> >  
> >
>
>-----------------------------------------------------------------------
> > >----
> > ------------------|
> >   |
> > |
> >   |       To:       "'This list is for discussion
> about the SQR database
> > reportinglanguage  from|
> >   |        Hyperion Solutions.'"
> <sqr-users@sqrug.org>
> > |
> >   |       cc:
> > |
> >   |       Subject:  [sqr-users] $sqr-program
> > |
> >  
> >
>
>-----------------------------------------------------------------------
> > >----
> > ------------------|
> > 
> > 
> > 
> > 
> > The SQR manual says that $sqr-program is supposed
> to contain the name of the
> > source file being executed.  I'm getting the null
> string.  Any ideas why?
> > 
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> > 
> > 
> > 
> > 
> > 
> > 
> >
>
----------------------------------------------------------------------------
> > --
> > This message contains information from Certegy,
> Inc which may be
> > confidential and privileged.  If you are not an
> intended recipient, please
> > refrain from any disclosure, copying, distribution
> or use of this
> > information and note that such actions are
> prohibited.  If you have received
> 
=== message truncated ===


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

_______________________________________________
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