SYSTEMVAL query

Madeleine D. mmdrake@bctonline.com
Wed, 04 Apr 2001 13:48:00 -0700


Has anyone experience with using SETSYSTEMVAL to setup an environment
variable in HP-UX/Oracle/PH8?  We need to read some tables in Quiz, set the
variables and then return to a script to retrieve the settings.

This is what we have tried in various forms:

DEF T_HOME CHAR*20 = BRIDGE_VALUE OF PARAMS
DEF T_OKAY CHAR*1 = "Y" IF SETSYSTEMVAL("SALHOME", T_HOME) ELSE "N"

No matter what, when we come out of Quiz, the var is blank, even though
T_OKAY ends up with a 'Y'.  If we try to read the variable in Quiz with a
GETSYSTEMVAL, we get '50236020', which is definitely not the value
retrieved (CHAR data in table).

We've reviewed the PH manuals in depth, and the OSAccess parameters are not
an issue.  We've also tried reading directly from the field in the table.
Same results.

Any help is much appreciated.

thanks
mmd