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

Re: [sqr-users] Call System & using existing DB connection

Subject: Re: [sqr-users] Call System & using existing DB connection
From: "Everett Carr" <ECARR@holycross.edu>
Date: Tue, 23 Jan 2007 17:25:54 -0500
Delivery-date: Tue, 23 Jan 2007 17:28:54 -0500
In-reply-to: <BAY106-F1728479A34CDAF4C3940188EAD0@phx.gbl>
List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
References: <890679.7303.qm@web34604.mail.mud.yahoo.com><BAY106-F1728479A34CDAF4C3940188EAD0@phx.gbl>

hmmmm..
watched this thread off-n-on. through the day..
 
 
how about trying a different tack than using the call system command?
 
If I'm assuming and remembering this thread........ and your going to run on 
the same environment....
then simply have change the calling SQR/sqr to submit a job to process 
scheduler instead of making 
a system call. 
 
Then your problem is solved since proc scheduler will run it for you. If you 
need the first sqr to WAIT until the other sqr finishes, then simply have it go 
into a loop checking the run status of the 2'nd sqr that the "caller"-if you 
will, submitted

>>> "Dwight Schrute" <schrute.dwight@hotmail.com> 1/23/2007 5:18 PM >>>
DUH!!  There is no way around that.  It is one of the faulty requirements of 
SQR.

The only other suggestion is to encrypt the password when passing it to the 
report and decrypt it WITHIN the report.

>From: Arun Kumar <arunkumar13@yahoo.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reporting 
>languagefrom Hyperion Solutions." <sqr-users@sqrug.org>
>Subject: Re: [sqr-users] Call System & using existing DB connection
>Date: Tue, 23 Jan 2007 14:00:07 -0800 (PST)
>
>Again security concern:
>Input command is not encrypted.
>It will display the password when user types it.
>The sqr can be used (accused) to collect user's passwords.
>
>HTH
>
>----- Original Message ----
>From: Dwight Schrute <schrute.dwight@hotmail.com>
>To: sqr-users@sqrug.org 
>Sent: Tuesday, January 23, 2007 4:40:15 PM
>Subject: RE: [sqr-users] Call System & using existing DB connection
>
>Suggestion:  Create a input variable called $password and populate it when
>you call your first report.  Then use that in the creation of the 
>connection
>string for the second report.
>
>
> >From: "Peter Burton" <Peter_Burton@hyperion.com>
> >Reply-To: "This list is for discussion about the SQR database
> >reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
> >To: "This list is for discussion about the SQR database reportinglanguage
> >fromHyperion Solutions." <sqr-users@sqrug.org>
> >Subject: RE: [sqr-users] Call System & using existing DB connection
> >Date: Tue, 23 Jan 2007 16:34:47 -0500
> >
> >Kim,
> >
> >Nope ... At least not from Hyperion SQR.
> >
> >Peter
> >
> >-----Original Message-----
> >From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org 
> >[mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org] On Behalf
> >Of Kim Meyrowitz
> >Sent: Tuesday, January 23, 2007 4:07 PM
> >To: sqr-users@sqrug.org 
> >Subject: RE: [sqr-users] Call System & using existing DB connection
> >
> >Understand that, but since I am already connected in my calling sqt
> >...anyway to pass that same connection info on to the sqt I need to call
> >via
> >the call system command?
> >
> >
> > >From: "Peter Burton" <Peter_Burton@hyperion.com>
> > >Reply-To: "This list is for discussion about the SQR database
> > >reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
> > >To: "This list is for discussion about the SQR database
> >reportinglanguage
> > >fromHyperion Solutions." <sqr-users@sqrug.org>
> > >Subject: RE: [sqr-users] Call System & using existing DB connection
> > >Date: Tue, 23 Jan 2007 15:55:52 -0500
> > >
> > >
> > >The only reason why the password is not made available inside of the
> > >program is because of SECURITY concerns.
> > >
> > >Peter
> > >
> > >-----Original Message-----
> > >From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org 
> > >[mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org] On
> >Behalf
> > >Of Arun Kumar
> > >Sent: Tuesday, January 23, 2007 3:48 PM
> > >To: This list is for discussion about the SQR database reporting
> > >languagefrom Hyperion Solutions.
> > >Subject: Re: [sqr-users] Call System & using existing DB connection
> > >
> > >Hi,
> > >There must be compelling reasons why sqr doesnt make password available
> > >within the program.
> > >They do hae many reserved variable like
> > >$username,$sqr-platform,$sqr-connected-db but not the password.
> > >
> > >Anyway,
> > >
> > >If you are running in Peoplesoft environment you might be able to pass
> > >the password (%ACCESSPSWD%)  as one of the command line parameters and
> > >use it to call the SQT.
> > >
> > >If you do figure out please share it...
> > >
> > >
> > >HTH...
> > >
> > >
> > >----- Original Message ----
> > >From: Kim Meyrowitz <kmeyrowitz@hotmail.com>
> > >To: sqr-users@sqrug.org 
> > >Sent: Tuesday, January 23, 2007 1:42:54 PM
> > >Subject: [sqr-users] Call System & using existing DB connection
> > >
> > >I currently have 1 sqt that calls another sqt using the Call System
> > >command.
> > >
> > >Problem is I need to pass the username,password and database info
> >(using
> > >
> > >Oracle). I can get the username from the $username variable & the
> > >database
> > >by querying to see which db I am currently attached to, but how do I
> >get
> > >the
> > >password?
> > >
> > >I can not hardcode this info because we run this file on different
> > >instances
> > >so everything does not stay the same.
> > >
> > >Thanks in advance!
> > >
> > >_________________________________________________________________
> > >Turn searches into helpful donations. Make your search count.
> > >http://click4thecause.live.com/search/charity/default.aspx?source=hmemt 
> >a
> > >gline_donation&FORM=WLMTAG
> > >
> > >
> > >_______________________________________________
> > >sqr-users mailing list
> > >sqr-users@sqrug.org 
> > >http://www.sqrug.org/mailman/listinfo/sqr-users 
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >_______________________________________________________________________
> >_
> > >____________
> > >Sucker-punch spam with award-winning protection.
> > >Try the free Yahoo! Mail Beta.
> > >http://advision.webevents.yahoo.com/mailbeta/features_spam.html 
> > >
> > >_______________________________________________
> > >sqr-users mailing list
> > >sqr-users@sqrug.org 
> > >http://www.sqrug.org/mailman/listinfo/sqr-users 
> > >
> > >
> > >If you have received this e-mail in error, please delete it and notify
> >the
> > >sender as soon as possible. The contents of this e-mail may be
> >confidential
> > >and the unauthorized use, copying, or dissemination of it and any
> > >attachments to it, is prohibited. Internet communications are not
> >secure
> > >and Hyperion does not, therefore, accept legal responsibility for the
> > >contents of this message nor for any damage caused by viruses. The
> >views
> > >expressed here do not necessarily represent those of Hyperion. For more
> >
> > >information about Hyperion, please visit our Web site at:
> >www.hyperion.com 
> > >
> > >
> > >
> > >_______________________________________________
> > >sqr-users mailing list
> > >sqr-users@sqrug.org 
> > >http://www.sqrug.org/mailman/listinfo/sqr-users 
> >
> >_________________________________________________________________
> >Get Hilary Duff's homepage with her photos, music, and more.
> >http://celebrities.live.com ( http://celebrities.live.com/ )
> >
> >
> >_______________________________________________
> >sqr-users mailing list
> >sqr-users@sqrug.org 
> >http://www.sqrug.org/mailman/listinfo/sqr-users 
> >
> >
> >If you have received this e-mail in error, please delete it and notify 
>the
> >sender as soon as possible. The contents of this e-mail may be 
>confidential
> >and the unauthorized use, copying, or dissemination of it and any
> >attachments to it, is prohibited. Internet communications are not secure
> >and Hyperion does not, therefore, accept legal responsibility for the
> >contents of this message nor for any damage caused by viruses. The views
> >expressed here do not necessarily represent those of Hyperion. For more
> >information about Hyperion, please visit our Web site at: 
>www.hyperion.com 
> >
> >
> >
> >_______________________________________________
> >sqr-users mailing list
> >sqr-users@sqrug.org 
> >http://www.sqrug.org/mailman/listinfo/sqr-users 
>
>_________________________________________________________________
>Search for grocery stores. Find gratitude. Turn a simple search into
>something more.
>http://click4thecause.live.com/search/charity/default.aspx?source=hmemtagline_gratitude&FORM=WLMTAG
> 
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org 
>http://www.sqrug.org/mailman/listinfo/sqr-users 
>
>
>
>
>
>
>
>
>____________________________________________________________________________________
>Yahoo! Music Unlimited
>Access over 1 million songs.
>http://music.yahoo.com/unlimited 
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org 
>http://www.sqrug.org/mailman/listinfo/sqr-users 

_________________________________________________________________
Search for grocery stores. Find gratitude. Turn a simple search into 
something more. 
http://click4thecause.live.com/search/charity/default.aspx?source=hmemtagline_gratitude&FORM=WLMTAG
 


_______________________________________________
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

References:
- Re: [sqr-users] Call System & using existing DB connection
  - From: Arun Kumar <arunkumar13@yahoo.com>
- Re: [sqr-users] Call System & using existing DB connection
  - From: "Dwight Schrute" <schrute.dwight@hotmail.com>

Prev by Date: Re: [sqr-users] Call System & using existing DB connection
Next by Date: Re: [sqr-users] Call System & using existing DB connection
Previous by thread: Re: [sqr-users] Call System & using existing DB connection
Next by thread: Re: [sqr-users] Call System & using existing DB connection
Indexes: [ Thread] [ Author] [ Date]
SQR-USERS List and Archive Info
SQRUG Home Page