Quiz page width limitation

[Lamers Mike]

We operate in a VMS environment, but it would surprise me if this were
different in other operating environments.

I agree with Ted that the limit only applies to reports, not to subfiles.

Using the statements:

set subfile name testit keep dictionary
report summary all

I had no problem outputting the entire record for a record that is 289 bytes
long (well beyond the 255 report limit).:

01/08/20                    SUBFILE DICTIONARY                    Page    1
                           SUBFILE RECORD REPORT


    Subfile:            TESTIT                               (Permanent)
    Organization:       Direct
    Format:             7
    Record Size:        289 Bytes
-----------------------------------------------------------------
The only issue you have with creating a subfile rather than a flatfile
report is that numeric or date fields may not be readable in a different
environment, so you might have to use some defines to translate those fields
to character or freeform format.

Also, in the VMS environment, you have to do a convert on the subfile to
modify the FDL if you want to pull the data into a Windows environment tool
such as MS Access or MS Excel.  Otherwise the data comes across in "stream"
rather than fixed width.

Another issue for VMS is that you can't take a subfile to a windows
environment via Pathworks and later copy it back to the VMS environment.
Something happens to the file structure along the way.

Mike Lamers
PacifiCare of Colorado 
Health Care Economics (CO82-214)
(719) 522 - 6758
mike.lamers@phs.com



> -----Original Message-----
> From:	 
> Sent:	None
> Subject:	
[MGL]  Date: Fri, 17 Aug 2001 11:50:43 -0400
From: Ted Johnson <johnsont@wfu.edu>
Reply-To: johnsont@wfu.edu
Organization: Wake Forest University
MIME-Version: 1.0
To: powerh-l@lists.swau.edu
Subject: [Fwd: RE: Quiz page width limitation]
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Only flatfiles created by QUIZ have the 255 limitation, QUIZ subfiles
don't have that limitation.

-------- Original Message --------
Subject: RE: Quiz page width limitation
Date: Fri, 17 Aug 2001 11:35:10 -0400
From: "Deskin, Bob" <Bob.Deskin@Cognos.COM>
To: "Powerhouse-L (E-mail)" <powerh-l@lists.swau.edu>

Quiz has a limit of 255 (if I remember correctly, it could be 264 as
well).
Use QTP.

Bob

-----Original Message-----
From: Karman, Al [mailto:AKarman@USFreightways.com]
Sent: Friday, August 17, 2001 11:31 AM
To: Powerhouse-L (E-mail)
Subject: RE: Quiz page width limitation


Good Friday to the -L,

I'm testing a new proc which needs to create a 314-byte wide output
(subfile, disk file, nail file ]:-))....in Quiz 8.29E, HP 3000 937/LX
running MPE/iX 6.0.0

There's something about a pesky limit that, apparently, ain't 314....so,
how's a person to get around this...?

The family's waiting on me to move it along....I can feel the
heat!!!...heading up to Wisconsin for the weekend and Would Really Like
to
have the -L come thru for me on this!!!


Al Karman
IT Consultant
US Freightways, Inc.
akarman@usfreightways.com 


This electronic message transmission, including any attachments, contains information from PacifiCare Health Systems Inc. which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited.  

If you have received this electronic transmission in error, please notify the sender immediately by a "reply to sender only" message and destroy all electronic and hard copies of the communication, including attachments.