powerh-l Digest, Vol 16, Issue 7
Moffatt, Doug
Doug.Moffatt at cognos.com
Wed Sep 20 11:09:09 CDT 2006
A simple way to create a csv report, using a single report field is
described below:
> set report name csv.txt
> set nohead
> set nowait
> set nostat
> set page length 1
> set page width 100
> acc countries in example_4gl
> define comma char size 1 = ","
> define csvline char size 80 = pack ( country_code + comma + country )
> rep tab 1 csvline go
This is the a dump of the CSV.TXT file created by the above Quiz report.
E:\samples>type csv.txt
AUS,Australia
BEL,Belgium
BRA,Brazil
CAN,Canada
CHI,Chile
CHN,China
DEN,Denmark
FRA,France
GER,Germany
HKG,Hong Kong
ITA,Italy
JAP,Japan
KOR,Korea
MEX,Mexico
NED,Netherlands
NOR,Norway
POL,Poland
POR,Portugal
RUS,Russia
SING,Singapore
SPA,Spain
SWE,Sweden
SWI,Switzerland
UK,United Kingdom
USA,United States
VIE,Vietnam
Hope this helps.
Doug Moffatt,
Manager, Application Development Tools, Cognos Inc.
-----Original Message-----
From: powerh-l-bounces+doug.moffatt=cognos.com at lists.sowder.com
[mailto:powerh-l-bounces+doug.moffatt=cognos.com at lists.sowder.com] On
Behalf Of powerh-l-request at lists.sowder.com
Sent: Wednesday, September 20, 2006 9:24 AM
To: powerh-l at lists.sowder.com
Subject: powerh-l Digest, Vol 16, Issue 7
Send powerh-l mailing list submissions to
powerh-l at lists.sowder.com
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
powerh-l-request at lists.sowder.com
You can reach the person managing the list at
powerh-l-owner at lists.sowder.com
When replying, please edit your Subject line so it is more specific than
"Re: Contents of powerh-l digest..."
Today's Topics:
1. Using arrays in QUIZ for dynamic columns (CSV reports)
(fernando.olmos at hpa.com.au)
2. Validating QUIZ source that has mulitple passes (Brett Greiner)
3. RE:Validating QUIZ source that has mulitple passes
(Ken Langendock)
4. RE:Validating QUIZ source that has mulitple passes (Robert Mills)
5. RE:Validating QUIZ source that has mulitple passes
(Ken Langendock)
6. RE:Using arrays in QUIZ for dynamic columns (CSV reports)
(Guy Werry)
----------------------------------------------------------------------
Message: 1
Date: Wed, 20 Sep 2006 11:00:37 +1000
From: fernando.olmos at hpa.com.au
Subject: Using arrays in QUIZ for dynamic columns (CSV reports)
To: powerh-l at lists.sowder.com
Message-ID: <C5B2133CD2641C4EA593D2143A5FA0A8513F40 at exchange2k>
Content-Type: text/plain; charset="iso-8859-1"
Hi
I am reading up on QUIZ's manual on arrays (very little info actually)
and I need some help.
I am trying to create a CSV QUIZ report, where the number of columns in
the report is dynamic (from 1 to 'n').
Anyone have any examples of QUIZ reports where such a possibility was
achieved using arrays? Otherwise I may have to bite the bullet and say
to the client, look you have up to 30 columns available and if you want
more, then we'll have to change the report. If you take away columns in
the database, then we'll also have to change the report. In fact if they
do anything to the table that will be used to load the array, we'll have
to change the report because each column is hard coded, whether you use
it or not. I am trying to avoid these limitations on my client.
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, 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/20060920/acaf8d8c
/attachment-0001.html
------------------------------
Message: 2
Date: Wed, 20 Sep 2006 15:38:17 +1200
From: "Brett Greiner" <Brett.Greiner at synoptix.co.nz>
Subject: Validating QUIZ source that has mulitple passes
To: <powerh-l at lists.sowder.com>
Message-ID:
<9D966695054CFA4A8FD712F96673CCFB2E76C2 at www.alliedfarmers.co.nz>
Content-Type: text/plain; charset="US-ASCII"
Hi
I am not familiar with compiled QUIZ source programs. All QUIZ reports
used on our clients site are executed as uncompiled quiz source (ie. As
a .qzs). 90% of them are made up of many passes to produce a report,
each pass has a 'go' to run that pass. For example, pass 1 creates a
subfile, pass 2 prints the report.
Example mock of the clients report.
access AP_OPEN_ITEM &
link to VENDOR
report summary &
VOUCHER_NUMBER &
VENDOR_NUMBER
set subfile name APDUEDATES01
set report nolimit
go
;--------------------------
access *APDUEDATES01
sort on VENDOR_NUMBER &
on VOUCHER_NUMBER
@IF DETAIL
report &
VENDOR_NUMBER heading "" &
VOUCHER_NUMBER heading ""
@ENDIF
footing at VENDOR_NUMBER &
VENDOR_NUMBER count
go
What ways can we use to validate the QUIZ source before the .qzs is used
in production, as we have had some use files modified and placed into
production and has stopped some the programs running in production with
an error. We could execute each source after each change but it would be
tedious for use files changed that affected hundreds of programs.
Any ideas?
Thanks
Brett Greiner
Synoptix
New Plymouth
New Zealand
------------------------------
Message: 3
Date: Wed, 20 Sep 2006 08:38:26 -0400
From: "Ken Langendock" <Ken at Langendock.com>
Subject: RE: Validating QUIZ source that has mulitple passes
To: "'Brett Greiner'" <Brett.Greiner at synoptix.co.nz>,
<powerh-l at lists.sowder.com>
Message-ID: <001001c6dcb1$ab719e70$0c01a8c0 at KenLangendock>
Content-Type: text/plain; charset="us-ascii"
I'm afraid that unless you are going to create massive scripts that test
every scenario in batch, you should consider changing your quiz to
compiled programs (replace the GO with BUILD).
With compiled code, you can create a mass-compile script that at least
validates the syntax of your changes.
One more thing. Not knowing your scenario, I am not sure as to why you
did this but I NEVER create a subfile in QUIZ. Using that method is very
limiting. Creating subfiles in QUIZ was a part of Powerhouse that was
created for End Users, not programmers. QTP is much more powerful and
allows output phase reads to cut processing times down.
Just my two cents worth.
Ken
-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Brett Greiner
Sent: September 19, 2006 11:38 PM
To: powerh-l at lists.sowder.com
Subject: Validating QUIZ source that has mulitple passes
Hi
I am not familiar with compiled QUIZ source programs. All QUIZ reports
used on our clients site are executed as uncompiled quiz source (ie. As
a .qzs). 90% of them are made up of many passes to produce a report,
each pass has a 'go' to run that pass. For example, pass 1 creates a
subfile, pass 2 prints the report.
Example mock of the clients report.
access AP_OPEN_ITEM &
link to VENDOR
report summary &
VOUCHER_NUMBER &
VENDOR_NUMBER
set subfile name APDUEDATES01
set report nolimit
go
;--------------------------
access *APDUEDATES01
sort on VENDOR_NUMBER &
on VOUCHER_NUMBER
@IF DETAIL
report &
VENDOR_NUMBER heading "" &
VOUCHER_NUMBER heading ""
@ENDIF
footing at VENDOR_NUMBER &
VENDOR_NUMBER count
go
What ways can we use to validate the QUIZ source before the .qzs is used
in production, as we have had some use files modified and placed into
production and has stopped some the programs running in production with
an error. We could execute each source after each change but it would be
tedious for use files changed that affected hundreds of programs.
Any ideas?
Thanks
Brett Greiner
Synoptix
New Plymouth
New Zealand
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
------------------------------
Message: 4
Date: Wed, 20 Sep 2006 13:56:34 +0100
From: "Robert Mills" <robert.mills at pinnaclearvato.co.uk>
Subject: RE: Validating QUIZ source that has mulitple passes
To: <Ken at Langendock.com>, <powerh-l at lists.sowder.com>
Message-ID:
<08F03A7FCBC8AD4AAB87773F252827290A8F0EAD at whgexh01.whgl.co.uk>
Content-Type: text/plain; charset="us-ascii"
Ken,
Reason for using Quiz: IT'S FASTER THAN QTP.
Reason for using QTP: Can create records > 255 bytes long (Next release
negates this reason!!!)
regards,
Robert W.Mills
MIS Systems Development Manager
Windsong Services
+44 (0)20 8309 3604
-----Original Message-----
From:
powerh-l-bounces+robert.mills=pinnaclearvato.co.uk at lists.sowder.com
[mailto:powerh-l-bounces+robert.mills=pinnaclearvato.co.uk at lists.sowder.
com] On Behalf Of Ken Langendock
Sent: 20 September 2006 13:38
To: 'Brett Greiner'; powerh-l at lists.sowder.com
Subject: RE: Validating QUIZ source that has mulitple passes
I'm afraid that unless you are going to create massive scripts that test
every scenario in batch, you should consider changing your quiz to
compiled programs (replace the GO with BUILD).
With compiled code, you can create a mass-compile script that at least
validates the syntax of your changes.
One more thing. Not knowing your scenario, I am not sure as to why you
did this but I NEVER create a subfile in QUIZ. Using that method is very
limiting. Creating subfiles in QUIZ was a part of Powerhouse that was
created for End Users, not programmers. QTP is much more powerful and
allows output phase reads to cut processing times down.
Just my two cents worth.
Ken
-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Brett Greiner
Sent: September 19, 2006 11:38 PM
To: powerh-l at lists.sowder.com
Subject: Validating QUIZ source that has mulitple passes
Hi
I am not familiar with compiled QUIZ source programs. All QUIZ reports
used on our clients site are executed as uncompiled quiz source (ie. As
a .qzs). 90% of them are made up of many passes to produce a report,
each pass has a 'go' to run that pass. For example, pass 1 creates a
subfile, pass 2 prints the report.
Example mock of the clients report.
access AP_OPEN_ITEM &
link to VENDOR
report summary &
VOUCHER_NUMBER &
VENDOR_NUMBER
set subfile name APDUEDATES01
set report nolimit
go
;--------------------------
access *APDUEDATES01
sort on VENDOR_NUMBER &
on VOUCHER_NUMBER
@IF DETAIL
report &
VENDOR_NUMBER heading "" &
VOUCHER_NUMBER heading ""
@ENDIF
footing at VENDOR_NUMBER &
VENDOR_NUMBER count
go
What ways can we use to validate the QUIZ source before the .qzs is used
in production, as we have had some use files modified and placed into
production and has stopped some the programs running in production with
an error. We could execute each source after each change but it would be
tedious for use files changed that affected hundreds of programs.
Any ideas?
Thanks
Brett Greiner
Synoptix
New Plymouth
New Zealand
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
------------------------------
Message: 5
Date: Wed, 20 Sep 2006 09:11:50 -0400
From: "Ken Langendock" <Ken at Langendock.com>
Subject: RE: Validating QUIZ source that has mulitple passes
To: "'Robert Mills'" <robert.mills at pinnaclearvato.co.uk>,
<powerh-l at lists.sowder.com>
Message-ID: <001301c6dcb6$55fed340$0c01a8c0 at KenLangendock>
Content-Type: text/plain; charset="us-ascii"
Faster using QUIZ may be marginally true.
But with QTP, you can reduce many programs to one extract and see the
statistics of how many records were read from each file by request.
With output phase reading, you can tune QTP to be fast enough to justify
the reduced source code/feedback benefits.
IMHO, quiz is dumb. It's just useful to read a file/subfile and report
the results.
Ken
-----Original Message-----
From: Robert Mills [mailto:robert.mills at pinnaclearvato.co.uk]
Sent: September 20, 2006 8:57 AM
To: Ken at Langendock.com; powerh-l at lists.sowder.com
Subject: RE: Validating QUIZ source that has mulitple passes
Ken,
Reason for using Quiz: IT'S FASTER THAN QTP.
Reason for using QTP: Can create records > 255 bytes long (Next release
negates this reason!!!)
regards,
Robert W.Mills
MIS Systems Development Manager
Windsong Services
+44 (0)20 8309 3604
-----Original Message-----
From:
powerh-l-bounces+robert.mills=pinnaclearvato.co.uk at lists.sowder.com
[mailto:powerh-l-bounces+robert.mills=pinnaclearvato.co.uk at lists.sowder.
com] On Behalf Of Ken Langendock
Sent: 20 September 2006 13:38
To: 'Brett Greiner'; powerh-l at lists.sowder.com
Subject: RE: Validating QUIZ source that has mulitple passes
I'm afraid that unless you are going to create massive scripts that test
every scenario in batch, you should consider changing your quiz to
compiled programs (replace the GO with BUILD).
With compiled code, you can create a mass-compile script that at least
validates the syntax of your changes.
One more thing. Not knowing your scenario, I am not sure as to why you
did this but I NEVER create a subfile in QUIZ. Using that method is very
limiting. Creating subfiles in QUIZ was a part of Powerhouse that was
created for End Users, not programmers. QTP is much more powerful and
allows output phase reads to cut processing times down.
Just my two cents worth.
Ken
-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Brett Greiner
Sent: September 19, 2006 11:38 PM
To: powerh-l at lists.sowder.com
Subject: Validating QUIZ source that has mulitple passes
Hi
I am not familiar with compiled QUIZ source programs. All QUIZ reports
used on our clients site are executed as uncompiled quiz source (ie. As
a .qzs). 90% of them are made up of many passes to produce a report,
each pass has a 'go' to run that pass. For example, pass 1 creates a
subfile, pass 2 prints the report.
Example mock of the clients report.
access AP_OPEN_ITEM &
link to VENDOR
report summary &
VOUCHER_NUMBER &
VENDOR_NUMBER
set subfile name APDUEDATES01
set report nolimit
go
;--------------------------
access *APDUEDATES01
sort on VENDOR_NUMBER &
on VOUCHER_NUMBER
@IF DETAIL
report &
VENDOR_NUMBER heading "" &
VOUCHER_NUMBER heading ""
@ENDIF
footing at VENDOR_NUMBER &
VENDOR_NUMBER count
go
What ways can we use to validate the QUIZ source before the .qzs is used
in production, as we have had some use files modified and placed into
production and has stopped some the programs running in production with
an error. We could execute each source after each change but it would be
tedious for use files changed that affected hundreds of programs.
Any ideas?
Thanks
Brett Greiner
Synoptix
New Plymouth
New Zealand
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
------------------------------
Message: 6
Date: Wed, 20 Sep 2006 08:19:06 -0500
From: "Guy Werry" <guy.werry at hbms.ca>
Subject: RE: Using arrays in QUIZ for dynamic columns (CSV reports)
To: <powerh-l at lists.sowder.com>
Message-ID:
<0ECD404B6909D0458968F14A7FF73BCBBDFA76 at hbffc003.hbms.hudbay.corp>
Content-Type: text/plain; charset="iso-8859-1"
Fernando,
Is this as simple as having a large number of columns with a BWZ (Blank
When Zero) clause? That way you could have dozens of columns, that
would only display when there was data in them. (This is harder for
TEXT, each field would probably require a define).
One large fly in that ointment is that if something is SUPPOSED to be
ZERO and has to be displayed like that, you're screwed.
Hope this helps. I've tried arrays in Powerhouse and found that they're
really not worth using ... doesn't handle them well at all.
Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited.
-----Original Message-----
From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com]On Behalf Of
fernando.olmos at hpa.com.au
Sent: Tuesday, September 19, 2006 8:01 PM
To: powerh-l at lists.sowder.com
Subject: Using arrays in QUIZ for dynamic columns (CSV reports)
Hi
I am reading up on QUIZ's manual on arrays (very little info actually)
and I need some help.
I am trying to create a CSV QUIZ report, where the number of columns in
the report is dynamic (from 1 to 'n').
Anyone have any examples of QUIZ reports where such a possibility was
achieved using arrays? Otherwise I may have to bite the bullet and say
to the client, look you have up to 30 columns available and if you want
more, then we'll have to change the report. If you take away columns in
the database, then we'll also have to change the report. In fact if they
do anything to the table that will be used to load the array, we'll have
to change the report because each column is hard coded, whether you use
it or not. I am trying to avoid these limitations on my client.
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,
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/20060920/51f6f8e9
/attachment.html
------------------------------
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
End of powerh-l Digest, Vol 16, Issue 7
***************************************
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.
More information about the powerh-l
mailing list