<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.2995" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV><SPAN class=762103622-30112006><FONT face=Arial color=#0000ff size=2>No...
you don't understand...</FONT></SPAN></DIV>
<DIV><SPAN class=762103622-30112006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=762103622-30112006><FONT face=Arial color=#0000ff size=2>Ok..
let me explain ...</FONT></SPAN></DIV>
<DIV><SPAN class=762103622-30112006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=762103622-30112006><FONT face=Arial color=#0000ff size=2>The
program asks the user to enter in account numbers via a CHOOSE. It sorts them
and removes any duplicate entries and stores the unique account numbers in a
PORTABLE subfile with commas separating each one. If you !cat the portable
subfile (i.e. !cat subfile.ps), you get a single line showing all the
account numbers separated by a comma - (i.e. "123456, 178172,
348393, 348393,"). There will unfortunately always be a comma at the end of the
line due to the nature of writing out ACCOUNT_NUMBER,
D_COMMA.</FONT></SPAN></DIV>
<DIV><SPAN class=762103622-30112006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=762103622-30112006><FONT face=Arial color=#0000ff size=2>Now
what I want is to be able to report that line at the heading of the report. In
other words, how can I create a subfile with a single line record containing
what is effectively columns of data (account numbers) separated by a comma? OR
put it another way... how is it possible to write a subfile HORIZONTALLY (one
row for all records) and not VERTICALLY (one row per record)? I need this as a
subfile, so I can link to it as a single record (LINK RECORD 0) and hence report
that line as part of my PAGE HEADING statements.</FONT></SPAN></DIV>
<DIV><SPAN class=762103622-30112006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=762103622-30112006><FONT face=Arial color=#0000ff size=2>Got
it? hehehe</FONT></SPAN></DIV>
<DIV><SPAN class=762103622-30112006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> mcl_systems@telus.net
[mailto:mcl_systems@telus.net] <BR><B>Sent:</B> Friday, 1 December 2006 9:33
AM<BR><B>To:</B> Fernando Olmos<BR><B>Subject:</B> Re: System variables from
within QUIZ<BR><BR></FONT></DIV>No comprende. If your QUIZ report creates the
text file... why can't it use what it creates in it's own PAGE HEADING? You got
some strange stuff going on there my friend.<BR><BR><BR><A
class=moz-txt-link-abbreviated
href="mailto:fernando.olmos@hpa.com.au">fernando.olmos@hpa.com.au</A> wrote:<BR>
<BLOCKQUOTE cite=midC5B2133CD2641C4EA593D2143A5FA0A85141F3@exchange2k
type="cite">
<META content="MSHTML 6.00.2900.2995" name=GENERATOR>
<DIV><SPAN class=542452622-30112006><FONT face=Arial color=#0000ff size=2>Ahhh
ok..</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=542452622-30112006><FONT face=Arial color=#0000ff
size=2>No... it won't work because the same QUIZ program I need to get this
work, is the one that creates the TXT file! hehehe</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=542452622-30112006><FONT face=Arial color=#0000ff size=2>So
... it looks like I have only two choices - [1] use a flat file dictionary
definition or [2] create two QUIZ programs: one to create the text file and
the other to pipe the file into it to generate the report.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=542452622-30112006><FONT face=Arial color=#0000ff
size=2>Thanks anyway</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> <A
class=moz-txt-link-abbreviated
href="mailto:mcl_systems@telus.net">mcl_systems@telus.net</A> [<A
class=moz-txt-link-freetext
href="mailto:mcl_systems@telus.net">mailto:mcl_systems@telus.net</A>]
<BR><B>Sent:</B> Friday, 1 December 2006 9:20 AM<BR><B>To:</B> Fernando
Olmos<BR><B>Subject:</B> Re: System variables from within
QUIZ<BR><BR></FONT></DIV>Well here's an example using Unix type
commands:<BR><BR>echo blahblahblah > flatfile<BR>quiz auto=myprog <
flatfile<BR><BR><BR>The Quiz program would simply have something like the
following:<BR>access ....<BR><BR>define myheader char*60 = parm <BR><BR>page
heading tab 20 myheader skip 2 keep column headings<BR><BR>build
myprog<BR><BR><BR>I don't see any reason why you couldn't use the same
logic.<BR><BR><BR>Regards,<BR><BR><BR>Michael Lee<BR>MCL Systems
Inc.<BR><BR><BR><BR><A class=moz-txt-link-abbreviated
href="mailto:fernando.olmos@hpa.com.au">fernando.olmos@hpa.com.au</A>
wrote:<BR>
<BLOCKQUOTE cite=midC5B2133CD2641C4EA593D2143A5FA0A85141EF@exchange2k
type="cite">
<META content="MSHTML 6.00.2900.2995" name=GENERATOR>
<DIV><SPAN class=343500622-30112006><FONT face=Arial color=#0000ff
size=2>How do you mean? You mean define parm prompt? But how to
automatically feed it in</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> <A
class=moz-txt-link-abbreviated
href="mailto:mcl_systems@telus.net">mcl_systems@telus.net</A> [<A
class=moz-txt-link-freetext
href="mailto:mcl_systems@telus.net">mailto:mcl_systems@telus.net</A>]
<BR><B>Sent:</B> Friday, 1 December 2006 2:24 AM<BR><B>To:</B> Fernando
Olmos<BR><B>Subject:</B> Re: System variables from within
QUIZ<BR><BR></FONT></DIV>Ahh, well then. Have you tried passing it to a PARM
value? You could create a flatfile with the line in it and then redirect
that PARM input to that flatfile with the "<" command. That should
work.<BR><BR><A class=moz-txt-link-abbreviated
href="mailto:fernando.olmos@hpa.com.au">fernando.olmos@hpa.com.au</A>
wrote:<BR>
<BLOCKQUOTE cite=midC5B2133CD2641C4EA593D2143A5FA0A85141EE@exchange2k
type="cite">
<META content="MSHTML 6.00.2900.2995" name=GENERATOR>
<DIV><SPAN class=156303306-30112006><FONT face=Arial color=#0000ff
size=2>Yes. Unfortunately the original designers of the system didn't
"think" like you and I, and so there is no flat file dictionary reference
I could use. I know what you mean.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=156303306-30112006><FONT face=Arial color=#0000ff
size=2>Thanks</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> <A
class=moz-txt-link-abbreviated
href="mailto:mcl_systems@telus.net">mcl_systems@telus.net</A> [<A
class=moz-txt-link-freetext
href="mailto:mcl_systems@telus.net">mailto:mcl_systems@telus.net</A>]
<BR><B>Sent:</B> Thursday, 30 November 2006 5:21 PM<BR><B>To:</B> Fernando
Olmos<BR><B>Subject:</B> Re: System variables from within
QUIZ<BR><BR></FONT></DIV>Hey Fernando,<BR><BR>Well if you can have that
file declared as a direct file you can link to it in QUIZ instead. Most
systems I've worked on have some default flat files declared in the
dictionary of the standard 80 byte, 132 byte and 256 byte lengths. As long
as any files one of those lengths we can then file equate to them (I
forget the Unix equivelant) and access them as regular files (LINK TO
RECORD 1 OF flatfile). <BR><BR>Perhaps this would work for you
instead.<BR><BR><BR>Regards,<BR><BR><BR>Michael Lee<BR>MCL Systems
Inc.<BR><BR><BR><A class=moz-txt-link-abbreviated
href="mailto:fernando.olmos@hpa.com.au">fernando.olmos@hpa.com.au</A>
wrote:<BR>
<BLOCKQUOTE cite=midC5B2133CD2641C4EA593D2143A5FA0A85141EC@exchange2k
type="cite">
<META content="MS Exchange Server version 6.0.6618.4" name=Generator><!-- 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><SPAN lang=en-us><FONT
face=Arial><BR></FONT></SPAN><SPAN lang=en-au><FONT face=Arial
color=#000000 size=2>Direct: 03 9217 5411</FONT></SPAN><SPAN
lang=en-us><BR></SPAN><SPAN lang=en-au><FONT face=Arial color=#000000
size=2>Mobile: 0410 382 857</FONT></SPAN><SPAN
lang=en-us><FONT face=Arial><BR></FONT></SPAN><SPAN lang=en-au><FONT
face=Arial color=#000000 size=2>Fax: 03 9217
5716</FONT></SPAN><SPAN lang=en-us> </SPAN></P>
<P><A href="file:///H:/Appdata/Microsoft/Signatures/www.hpa.com.au"
moz-do-not-send="true"><SPAN lang=en-au><U><B><FONT face=Arial
color=#0000ff size=2>www.hpa.com.au</FONT></B></U></SPAN></A> </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, <A class=moz-txt-link-abbreviated href="mailto:postmaster@hpa.com.au">postmaster@hpa.com.au</A>,
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
<A class=moz-txt-link-abbreviated href="http://www.hpa.com.au">www.hpa.com.au</A>
**********************************************************************
</PRE></BLOCKQUOTE><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, <A class=moz-txt-link-abbreviated href="mailto:postmaster@hpa.com.au">postmaster@hpa.com.au</A>,
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
<A class=moz-txt-link-abbreviated href="http://www.hpa.com.au">www.hpa.com.au</A>
**********************************************************************
</PRE></BLOCKQUOTE><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, <A class=moz-txt-link-abbreviated href="mailto:postmaster@hpa.com.au">postmaster@hpa.com.au</A>,
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
<A class=moz-txt-link-abbreviated href="http://www.hpa.com.au">www.hpa.com.au</A>
**********************************************************************
</PRE></BLOCKQUOTE><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, <A class=moz-txt-link-abbreviated href="mailto:postmaster@hpa.com.au">postmaster@hpa.com.au</A>,
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
<A class=moz-txt-link-abbreviated href="http://www.hpa.com.au">www.hpa.com.au</A>
**********************************************************************
</PRE></BLOCKQUOTE><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>