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

["the dragon" <ceprn@hotmail.com>]

Actually, you *can* put them into another, new program, without them 
affecting the original programs, provided you have the source code.

Process Scheduler is a PeopleSoft tool for executing reporting andf 
processing applications.

If you need this performed, I can do it in 40 - 60 billable hours at 
$50.00/hr.

[sorry about the shill Mr Onko 8-P]

peace,
clark


PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you." -- Carl Sandburg (1878 - 1967)

It is impossible to defeat an ignorant man in argument. -- William G. McAdoo

Religion is regarded by the common people as true, by the wise as false, and 
by the rulers as useful. -- Seneca

"I distrust those people who know so well what God wants them to do because 
I notice it always coincides with their own desires." - Susan B. Anthony




----Original Message Follows----

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
>
>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
>>
>>
>>The only reason why the password is not made available inside of the
>>program is because of SECURITY concerns.
>>
>>Peter
>>
>>-----Original Message-----
>>
>>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>
>>
>>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!
>>

_________________________________________________________________
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