PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

SQR - How can I create an environment variable that will contain the name of DB? Or does one already

edited Jul 7, 2015 4:34PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered ✓

SQR - How can I create an environment variable that will contain the name of Database? Or, does a variable already exist that can return the name of the DB?

DETAILS: Variable I'm trying to create should be PSDBENV = "PSHRDEV1". I want to create it the same way PS_HOME is created. I have SQR that is run only in NT and I need to pass it the name of the database ( SQR : Let $Env = getenv('PSDBENV') ). I know that when i do this with PS_HOME ( SQR : Let $Home = getenv('PS_HOME') ) it returns the right value for environment im in.   When the SQR is running I need to know which environment it's in, because depending on the environment there is conditions that I need

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center