Using SETSYSTEMVAL in Quiz
Whittall, Conrad
Conrad.Whittall@Cognos.COM
Thu, 26 Sep 2002 15:44:17 -0400
Blue is spot on. The SETSYSTEMVAL function returns a boolean TRUE/FALSE
result, depending on whether the operation succeeds or fails, and so you
need to evaluate it in a conditional statement and assign a value to your
variable accordingly.
Best regards,
Conrad
Conrad Whittall
e-Learning Architect, Global Education Services
Cognos Incorporated, 3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada
-----Original Message-----
From: Edis, Bob [mailto:BEdis@usbnc.org]
Sent: Thursday 26 September 2002 15:37
To: 'powerh-l@lists.swau.edu'
Subject: RE: Using SETSYSTEMVAL in Quiz
G'day Guy
Try using
DEFINE d_a INT SIZE 1 = 1 IF (SETSYSTEMVAL('STDATE',ASCII(st-date,8))) ELSE
0
I haven't got PH around (haven't had for over a year) to test it but I
believe the SETSYSTEMVAL() has to be part of a condition not the value
assignment.
Regards,
Blue
-----Original Message-----
From: Guy Werry
To: PH Mailing List (E-mail)
Sent: 9/26/2002 2:11 PM
Subject: Using SETSYSTEMVAL in Quiz
Hey there all. Quiz 7.33.D3 on HP-Ux 10.20.
I'd really like to be able to use Quiz to do a SETSYSTEMVAL, but it
keeps
gagging on me, even though the manual seems to indicate that Quiz knows
how
to use SETSYSTEMVAL.
Below is an example of the sort of error that I get:
> def a integer signed size 1 =
(setsystemval('STDATE',ascii(st-date,8)))
^^^^^^^^^^^^
*E* Expected: - ( ABSOLUTE CEILING CHECKSUM DATE DATEEXTRACT
DAYS
ROUND LINKVALUE FLOOR LASTDAY ADDCENTURY REMOVECENTURY
NCONVERT
SIZE INDEX MOD SUM <number> MISSING NULL SYSDATE SYSTIME
<qualifier> <item>
Anyone got any bright ideas?
G.L. (Guy) Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting
Ph: 204-687-2374
Fax: 204-687-2771
guy.werry@hbms.ca
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.