QUIZ maximum record length confined by maximum poage width

[Joe Boyle]

even with quiz ( and subfiles ) you can specify up to 2048 chars per item
and up to 1024 items per record. 

And as you found below, some platforms don't like the syntax ' set page wid
0 ' but they generally all like ' set page wid 255 ' which is the max value
( it maybe 256 ); but with subfiles you probably won't need to specify this.


If you want to view the data in such a field you can use syntax like that
below,

can cle

set pag wid 140

acc * j1
rep j1 wrap 130

build j1b


Regards, Joe.

This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this e-mail and any
attachments sent with it may have been altered without the consent or
knowledge of the author.


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Deskin, Bob
Sent: 13 December 2004 14:30
To: Seamus Browne; powerh-l@lists.sowder.com
Subject: RE: QUIZ maximum record length confined by maximum poage width 

No there isn't. QUIZ is a report writer and everything is tied to the
maximum page width - 255 (as I recall). QUIZ subfiles were intended to
pass data between reports and are based on the REPORT statement - so 255
again.

I suggest using QTP to migrate data for a number of reasons. First,
there's no 255 character limit. Also, you can create indexed subfiles
and retain index information. And you can retain substructure
information if you're moving from IMAGE or KSAM to indexed or Eloquence.

Bob Deskin              
Senior Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Seamus Browne
Sent: December 13, 2004 9:11 AM
To: powerh-l@lists.sowder.com
Subject: QUIZ maximum record length confined by maximum poage width 



Hi,
Using QUIZ, I heed to export some data from PH on a HP3000. (Yep, it's
migration time ...)

I am stuck with a maximum field length, not per se, because this works:

	acc dbfile
	def x char * 600 = "XX"

But I can't report a field that is larger than the maximum page width,
i.e. 256.

Even when I specify a discfile as the report device the page width seems
to override any other specifications.
-----------------------------------------------------------------

can cle
set def

acc dbfile
def x char * 600 = "XX"

:purge xFile
:build xFile;rec=-600,,f,ascii;DISC=100
set rep dev disc name xFile

set page wid 0
             ^* This value is not within the range of allowed values.
set rep spa 0

set nohead
rep x

go
* Can't report an element exceeding PAGE WIDTH specification.
--------------------------------------------------------------------
Any way round this in Quiz ?

TIA

Scottie Hannigan




= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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. 
  
       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. 
 

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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.