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
>