Unrelated to 'use statements' I hit some type of MAX or somet hing

[Nancy Tietz]

Dennis,
Your idea is the one that gets the cake today!
The programmer added steps to calculate the total lines and put the total
lines in a database with a key.  So then the final report can just pull
those in and print them. (This is an oversimplification but gives you all
the general idea.)
Thank you very much for your help!
And thank you to the List for your kind helpfulness as always.
Nancy

-----Original Message-----
From: dennis@dhassell.com [mailto:dennis@dhassell.com]
Sent: Tuesday, May 20, 2003 10:57 AM
To: 'Nancy Tietz'; aargyriou@vivodi.gr; powerh-l@lists.swau.edu
Cc: dtietz@msxi.com
Subject: RE: Unrelated to 'use statements' I hit some type of MAX or
something


I had a difficult report one time, where they needed subtotals in the
headings and other unusual stuff. I built an intermediate file where the
first few bytes were keys which determined the order of the final report
lines, and the rest of the record was the content. I also had format
flags which triggered IF-THEN's in the final report to alter the format.
I then took several QTP (could use Quiz) steps to build and append the
subfile. 

How that applies here might be the ability to break the footing
generation steps into more manageable sizes and hey keep it all within a
Powerhouse context.

(I'm suspicious, but I couldn't confirm it, that there is a character
limit on the parsing buffers in Quiz - I would assume you'd get an error
that would point more clearly there, but maybe not. My guess would be
somewhere between 4k and 32k length. Someone suggested there is a 32k
length limit.)

This might not be such a bad redo. You could leave the pieces in
separate Quiz modules (or make it a QTP multi-step process) with a Quiz
sort-and-report of the subfile at the end.

Dennis Hassell
Dennis Hassell and Associates
(941) 746-4919
(941) 224-3981 - cell



-----Original Message-----
From: powerh-l-admin@cube.swau.edu [mailto:powerh-l-admin@cube.swau.edu]
On Behalf Of Nancy Tietz
Sent: Tuesday, May 20, 2003 8:55 AM
To: 'aargyriou@vivodi.gr'; 'powerh-l@lists.swau.edu'
Cc: 'dtietz@msxi.com'
Subject: RE: Unrelated to 'use statements' I hit some type of MAX or
something


Yeah, it is an important report and it has a lot of calculations and
pic's in the footings that are 'use'd in all 6 levels.  The programmer
is still working on it trying various things to simplify.  But I was
thinking that a statement like FILE QUIZSCR;DISC=2000000 or FILE
QUIZSORT;DISC=2000000 or something similar might help.  I'd hate to see
him have to put the whole stupid report to disc and add the footings in
separate steps.  
Thanks for your kind words,
nt


-----Original Message-----
From: Andreas Argyriou [mailto:aargyriou@vivodi.gr]
Sent: Tuesday, May 20, 2003 6:08 AM
To: Nancy Tietz
Subject: RE: Unrelated to 'use statements' I hit some type of MAX or
something


Nancy,

It sounds like you hit some type of max or something, as you say. I
remember something similar about 14 years ago on a DG AOS/VS machine and
Powerhouse version 5.3.4 or something similar. I was not getting any
error, quiz just aborted when compiling. I had to remove levels of
footings, remove items etc. Another thing that helped was to move any
formatting stuff (pic, bwz etc.) for defined items from the
reporting/footing statements section to the define statements. It took
me about a week to get the program to compile.

I believe that a report with 6 levels of footings with 30 fields for
each level is unreadable. Management insisted that the report was
necessary so we had to do it. However, it was never used.

Just trying to help.

Andreas Argyriou
Athens, Greece


-----Original Message-----
From: powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu]On
Behalf Of Nancy Tietz
Sent: Monday, May 19, 2003 6:23 PM
To: 'powerh-l@lists.swau.edu'
Cc: 'dtietz@msxi.com'
Subject: RE: Unrelated to 'use statements' I hit some type of MAX or
something


latest news: "by removing unneeded fields in the input subfile I now can
show 4 footings but not 5."

nt
-----Original Message-----
From: Nancy Tietz
Sent: Monday, May 19, 2003 11:12 AM
To: 'powerh-l@lists.swau.edu'
Cc: 'dtietz@msxi.com'
Subject: Unrelated to 'use statements' I hit some type of MAX or
something
Importance: High


Dear ListServer,
Below is a further problem this programmer is having with the same Quiz
on which Robert Mills assisted.

(By the way, the USE STD1.use file was approx. 200 lines long to get a
14 line footer, and it was needed in 6 footing at's.)

Now, some sort of MAX has been reached.  The old program that worked had
4 sort items and only 1 footer line.  The new program needs to have 6
sort items and 6 footing at statements.  Each of those footing at stmt's
has this 200 line temp 'use' file in it.  There is only 1 file being
accessed at the top.

Result:  It stops printing in the middle of a footer and gives this
message:  *Fatal Error* *45* Notify Cognos Customer Support

Also, if 1 footing line is removed, it does work.  However all 6 footing
at stmt's are necessary.  See below for what all else we tried.

Thank you for your kind help.
Nancy

-----Original Message-----
From: Derrick Tietz [mailto:DTietz@msxi.com]
Sent: Monday, May 19, 2003 10:33 AM
To: ntietz@MCARE.MED.UMICH.EDU
Subject: RE: Unrelated to 'use statements' I hit some type of MAX or
something


Do you have time to pose this question to the list server? The quizscr=
and quizsort = has not helped.  *Fatal Error* *45* Notify Cognos
Customer Support

I have 6 sorts 6 footings. Each footing has 10 lines and 13 columns. It
runs without error with any variation of 3 footings but not 4 footings.
It stops in the middle of one of the footings (not a particular one).





= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.