Re: [sqr-users] SQR Unix env. variable setting

["Suman Buddharaju" <SBUDDHA@dot.state.tx.us>]

prcs_sqr is still available in PeopleSoft 8.   Although Process
scheduler works little bit different in PS 8 vs PS 7.5x.  In PeopleSoft
8 for sqrs on  UNIX the Process Scheduler calls a application called
pssqr.  pssqr calls prcs_sqr which is a shell script 
and which can be modified to set environment variables.  pssqr then
calls sqr.  

Alternatively....you can call a external program (like a shell script)
in sqr using 'call system' but i think any variable you set may noy be
available after the script is done executing.

HTH
Suman

>>> desello_nelson@jpmorgan.com 04/17/03 06:55AM >>>


We are using sqr 8.1.6 for PeopleSoft 8.
So I don't think there is a prcs_sqr that I'm aware of.

Thanks,
Nelson





SBUDDHA@dot.state.tx.us@sqrug.org on 04/16/2003 05:31:31 PM

Please respond to sqr-users@sqrug.org 

Sent by:    sqr-users-admin@sqrug.org 


To:    sqr-users@sqrug.org 
cc:
Subject:    Re: [sqr-users] SQR Unix env. variable setting


Well how about this way...

PeopleSoft Process Scheduler invokes a program called prcs_sqr which
in
turn calls sqr.  Process Scheduler does not call sqr directly on UNIX.
In PS 7.5 this script prcs_sqr ( typically this script is  in
$PS_HOME/bin)  is a shell script.  You can modify this shell script to
export the environment variable so that it will be available for the
current as well as child processes.




>>> desello_nelson@jpmorgan.com 04/16/03 04:00PM >>>


Thanks for the reply, however let me explain further why that is not
working for us:
The NLS_LANG is set correctly when run from the command line or
autosys,
BUT NOT from the process scheduler it always sets it to NLS_LANG=UTF8,
which we don't want.  So going back to my original question: how would
you
set a Unix env variable WITHIN an SQR script using the sqr syntax?
If that is possible at all.  I did a truss on the psadmin and surely
enough
it sets NLS_LANG=UTF8, now is there a way to pass NLS_LANG via
psadmin?

Any help is appreciated.

Thanks,
Nelson





SBUDDHA@dot.state.tx.us@sqrug.org on 04/16/2003 04:35:40 PM

Please respond to sqr-users@sqrug.org 

Sent by:    sqr-users-admin@sqrug.org 


To:    sqr-users@sqrug.org 
cc:
Subject:    Re: [sqr-users] SQR Unix env. variable setting


We set UNIX variables in the .profile of the user that is going to run
the SQR.

e.g in our case user  psoftut runs PeopleSoft SQR and we set all the
variables in the users .profile .

>>> desello_nelson@jpmorgan.com 04/16/03 02:58PM >>>

How do you set a Unix environment variable(say, NLS_LANG) within your
SQR
script?
I'm a sysadmin trying to help an SQR developer, so go figure<smile>.

Any assistance is highly appreciated.
Nelson
desello_nelson@jpmorgan.com 


This communication is for informational purposes only.  It is not
intended as
an offer or solicitation for the purchase or sale of any financial
instrument
or as an official confirmation of any transaction. All market prices,
data
and other information are not warranted as to completeness or accuracy
and
are subject to change without notice. Any comments or statements made
herein
do not necessarily reflect those of J.P. Morgan Chase & Co., its
subsidiaries and affiliates.

_______________________________________________
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 




This communication is for informational purposes only.  It is not
intended as
an offer or solicitation for the purchase or sale of any financial
instrument
or as an official confirmation of any transaction. All market prices,
data
and other information are not warranted as to completeness or accuracy
and
are subject to change without notice. Any comments or statements made
herein
do not necessarily reflect those of J.P. Morgan Chase & Co., its
subsidiaries and affiliates.

_______________________________________________
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 




This communication is for informational purposes only.  It is not
intended as
an offer or solicitation for the purchase or sale of any financial
instrument
or as an official confirmation of any transaction. All market prices,
data
and other information are not warranted as to completeness or accuracy
and
are subject to change without notice. Any comments or statements made
herein
do not necessarily reflect those of J.P. Morgan Chase & Co., its
subsidiaries and affiliates.

_______________________________________________
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