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

[desello_nelson@jpmorgan.com]

I already did that pssqr.unx on the Unix side its called.
But no luck.  Since the developer only run this particular sqr once a
month, I figured let's put in that sqr, but how?

Thanks,
Nelson





KnappR@umsystem.edu@sqrug.org on 04/16/2003 05:13:03 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



Modify pssqr.ini?

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: desello_nelson@jpmorgan.com [mailto:desello_nelson@jpmorgan.com]
Sent: Wednesday, April 16, 2003 4:00 PM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] SQR Unix env. variable setting




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