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

[Arun Kumar <arunkumar13@yahoo.com>]

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