SYSTEMVAL query

Pickering, John (NORBORD) PICKERIJ@norbord.com
Wed, 4 Apr 2001 18:12:07 -0400


Probably the define for T_OKAY never gets referenced (except in your
debugging mode) so it never gets evaluated and therefore the system variable
never gets set.

You'll need to contrive somehow to reference T_OKAY. You can report it, in
which case I'd probably make it equal to blank in the event of success (with
a blank heading) or include it in your page heading or even include it in
your sort statement. But you have to get Quiz to evaluate it!

Regards,
JWP

> -----Original Message-----
> From:	Madeleine D. [SMTP:mmdrake@bctonline.com]
> Sent:	Wednesday, April 04, 2001 4:48 PM
> To:	powerh-l@lists.swau.edu
> Subject:	SYSTEMVAL query
> 
> 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
>