System variables from within QUIZ
fernando.olmos at hpa.com.au
fernando.olmos at hpa.com.au
Thu Nov 30 16:41:45 CST 2006
No... you don't understand...
Ok.. let me explain ...
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.
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.
Got it? hehehe
-----Original Message-----
From: mcl_systems at telus.net [mailto:mcl_systems at telus.net]
Sent: Friday, 1 December 2006 9:33 AM
To: Fernando Olmos
Subject: Re: System variables from within QUIZ
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.
fernando.olmos at hpa.com.au <mailto:fernando.olmos at hpa.com.au> wrote:
Ahhh ok..
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
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.
Thanks anyway
-----Original Message-----
From: mcl_systems at telus.net <mailto:mcl_systems at telus.net> [
mailto:mcl_systems at telus.net <mailto:mcl_systems at telus.net> ]
Sent: Friday, 1 December 2006 9:20 AM
To: Fernando Olmos
Subject: Re: System variables from within QUIZ
Well here's an example using Unix type commands:
echo blahblahblah > flatfile
quiz auto=myprog < flatfile
The Quiz program would simply have something like the following:
access ....
define myheader char*60 = parm
page heading tab 20 myheader skip 2 keep column headings
build myprog
I don't see any reason why you couldn't use the same logic.
Regards,
Michael Lee
MCL Systems Inc.
fernando.olmos at hpa.com.au <mailto:fernando.olmos at hpa.com.au> wrote:
How do you mean? You mean define parm prompt? But how to automatically
feed it in
-----Original Message-----
From: mcl_systems at telus.net <mailto:mcl_systems at telus.net> [
mailto:mcl_systems at telus.net <mailto:mcl_systems at telus.net> ]
Sent: Friday, 1 December 2006 2:24 AM
To: Fernando Olmos
Subject: Re: System variables from within QUIZ
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.
fernando.olmos at hpa.com.au <mailto:fernando.olmos at hpa.com.au> wrote:
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.
Thanks
-----Original Message-----
From: mcl_systems at telus.net <mailto:mcl_systems at telus.net> [
mailto:mcl_systems at telus.net <mailto:mcl_systems at telus.net> ]
Sent: Thursday, 30 November 2006 5:21 PM
To: Fernando Olmos
Subject: Re: System variables from within QUIZ
Hey Fernando,
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).
Perhaps this would work for you instead.
Regards,
Michael Lee
MCL Systems Inc.
fernando.olmos at hpa.com.au <mailto:fernando.olmos at hpa.com.au> wrote:
Hi again guys...
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?
i.e. QUIZ
>
>!setenv VAR1 "test"
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.
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...
i.e. "123456, 344545, 456566, 465344," <--- this is the single
line text file
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"?
Thanks
Fernando Olmos
MIS
Senior Analyst Programmer
HPA
Direct: 03 9217 5411
Mobile: 0410 382 857
Fax: 03 9217 5716
<file:///H:/Appdata/Microsoft/Signatures/www.hpa.com.au> www.hpa.com.au
**********************************************************************
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 at hpa.com.au <mailto:postmaster at 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 <http://www.hpa.com.au>
**********************************************************************
**********************************************************************
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 at hpa.com.au <mailto:postmaster at 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 <http://www.hpa.com.au>
**********************************************************************
**********************************************************************
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 at hpa.com.au <mailto:postmaster at 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 <http://www.hpa.com.au>
**********************************************************************
**********************************************************************
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 at hpa.com.au <mailto:postmaster at 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 <http://www.hpa.com.au>
**********************************************************************
**********************************************************************
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 at 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
**********************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20061201/2eddc6fc/attachment-0001.html
More information about the powerh-l
mailing list