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

["Peter Burton" <Peter_Burton@hyperion.com>]

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


_______________________________________________
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