<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>System variables from within QUIZ</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=771470609-30112006><FONT
face="Comic Sans MS" color=#0000ff size=2>Fernando,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=771470609-30112006><FONT
face="Comic Sans MS" color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=771470609-30112006><FONT
face="Comic Sans MS" color=#0000ff size=2>If this extra data you require is in a
file then why not add a 'LINK TO RECORD 0 OF <record name>' to
your ACCESS statement?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=771470609-30112006><FONT
face="Comic Sans MS" color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=771470609-30112006><FONT
face="Comic Sans MS" color=#0000ff size=2>For this to work you would need to
have a direct file declared in your dictionary with a single item of suitable
length.</FONT></SPAN></DIV>
<DIV> </DIV>
<P align=left><FONT face="Comic Sans MS" size=2>regards,</FONT> <BR><FONT
face=Arial> </FONT> <BR><FONT face="Comic Sans MS" size=2>Robert
W.Mills</FONT> <BR><FONT face="Comic Sans MS" size=2>Systems Development
Manager</FONT> <BR><FONT face="Comic Sans MS" size=2>Pinnacle
Arvato</FONT> <BR><FONT face="Comic Sans MS" size=2>(0</FONT><FONT
face="Comic Sans MS" size=2>20</FONT><FONT face="Comic Sans MS" size=2>)</FONT>
<FONT face="Comic Sans MS" size=2>8309 3604</FONT> </P>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+robert.mills=pinnaclearvato.co.uk@lists.sowder.com
[mailto:powerh-l-bounces+robert.mills=pinnaclearvato.co.uk@lists.sowder.com]
<B>On Behalf Of </B>fernando.olmos@hpa.com.au<BR><B>Sent:</B> 30 November 2006
05:35<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> System
variables from within QUIZ<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>Hi again guys...</FONT> </P>
<P><FONT face=Arial size=2>Is there a way to set a system variable from within
UNIX, but not using setsystemval(), but by actually calling Unix commands
directly from QUIZ?</FONT></P>
<P><FONT face=Arial size=2>i.e. QUIZ</FONT>
<BR> <FONT face=Arial
size=2>></FONT> <BR> <FONT
face=Arial size=2>>!setenv VAR1 "test"</FONT> </P>
<P><FONT face=Arial size=2>Yes I know this can be done and it works, but the
variable is not kept once QUIZ returns back from the shell. So when I use
getsystemval(), it cannot find it.</FONT></P>
<P><FONT face=Arial size=2>The reason I need to do this outside of setsystemval,
is that I have created a txt file that has dynamic data in a single
line...</FONT></P>
<P><FONT face=Arial size=2>i.e. "123456, 344545, 456566,
465344," <--- this is the single line
text file</FONT> </P>
<P><FONT face=Arial size=2>What I want is to be able to use this text file as
part of a heading into my QUIZ report in another pass. How is it possible to
DEFINE a variable in QUIZ to say "... give me the contents of a text
file"?</FONT></P>
<P><FONT face=Arial size=2>Thanks</FONT> </P>
<P><I><FONT face=Arial color=#0000ff size=4>Fernando Olmos</FONT></I>
<BR><B><FONT face=Arial size=2>MIS</FONT></B> <BR><B><FONT face=Arial
size=2>Senior Analyst Programmer</FONT></B> </P>
<P><SPAN lang=en-au><B><FONT face=Arial color=#0000ff
size=2>HPA</FONT></B></SPAN><B><SPAN lang=en-us></SPAN></B><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT
face=Arial><BR></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial color=#000000 size=2>Direct: 03 9217 5411</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><BR></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial color=#000000 size=2>Mobile:
0410 382 857</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial><BR></FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial color=#000000
size=2>Fax: 03 9217 5716</FONT><FONT
face=Arial></FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us> </SPAN></P>
<P><SPAN lang=en-au></SPAN><A
href="file:///H:/Appdata/Microsoft/Signatures/www.hpa.com.au"><SPAN
lang=en-au></SPAN><SPAN lang=en-au><U></U></SPAN><SPAN lang=en-au><U><B><FONT
face=Arial color=#0000ff size=2>www.hpa.com.au</FONT></B></U></SPAN><SPAN
lang=en-au></SPAN></A><SPAN lang=en-au></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN> </P><BR><PRE>**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you received this e-mail in error, please notify the HPA Postmaster, postmaster@hpa.com.au,
then delete the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************
</PRE></BODY></HTML>