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

["Franck Masson" <franck.masson2002@laposte.net>]

Hi,
are  you working on unix ?
can you explain us how you are launching SQR ?
are you using a shell script ?
one possible solution will be to store (temporary,during the execution) the
connection in a file /mysqr/file_connection or in a variable.
myconnection=user/password@database; export myconnection
sqr mysqr.sqr $myconnection [flags] [args]
with a file
sqr mysqr.sqr @myconnection_file [flags] [args]

and in your sqr you can reuse this variable or this file

Franck


-----Original Message-----
From: sqr-users-bounces+franck.masson2002=laposte.net@sqrug.org
[mailto:sqr-users-bounces+franck.masson2002=laposte.net@sqrug.org]On
Behalf Of Kim Meyrowitz
Sent: mercredi 24 janvier 2007 16:03
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Call System & using existing DB connection


Unfortunately, can't put into one report because these sqts that I am
calling can also be run as standalone reports as well.

Process scheduler, I am not familiar with that... is that used with
Peoplesoft?  If so, we are not using that.

I think I'll need to go the encrypt/decrypt route.

Thanks everyone for you input!!!

>From: "Kim Meyrowitz" <kmeyrowitz@hotmail.com>
>Reply-To: "This list is for discussion about the SQR database
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: sqr-users@sqrug.org
>Subject: RE: [sqr-users] Call System & using existing DB connection
>Date: Tue, 23 Jan 2007 16:06:35 -0500
>
>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

_________________________________________________________________
Check out all that glitters with the MSN Entertainment Guide to the Academy
Awards®   http://movies.msn.com/movies/oscars2007/?icid=ncoscartagline2


_______________________________________________
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