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

["Kim Meyrowitz" <kmeyrowitz@hotmail.com>]

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=hmemta
>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