Read Env Variables from an SQR

Get the O/S environment variables from within SQR programs
There is a function called GetEnv().

 

This gets the TEMP environment variable on the machine where SQR is run.

Returns the value of the specified environment variable. If the environment variable does not exist, an empty string is returned.

Syntax: dst_var = getenv(env_value)
env_value = text literal, column, variable, or expression.
dst_var = text variable.

Example: let $UserTempDirectory = GetEnv("TEMP")

Or you could get it with sql below:

SELECT
DBOWNER.DBNAME
FROM PS.PSDBOWNER DBOWNER