To Quiz or not to Quiz...
brian_matthewsbrian matthews
brian_matthews_bmw at hotmail.com
Mon Jun 13 12:05:53 CDT 2005
I would regard the term 'auto-format'ting as the acton of quiz, when it
takes the binary bit-mapping of a numeric field (integer, float etc... ) and
formats it as the output to the default picture created by pdl when it
builds the dictionary; I am assuming that by flat-file you are referring to
a quiz report disc file ?
As for Erik pushing Cognos to enable a > 255 char quiz report file record
size, we can all do this by logging an enhancement request at the Cognos
customer support Web site - so why do'nt we ? - because we are too lazy :)
The second reason is that few of us want to upgrade to PH to get this - we
simplly want to be able to muigrate away from PH - and expect Cognos to help
us do so by providing easier tools - fat chance ! :)
regards Bri,
>From: "Hurworth, Erik" <Erik.Hurworth at cognos.com>
>To: <powerh-l at lists.sowder.com>
>Subject: RE: To Quiz or not to Quiz...
>Date: Mon, 13 Jun 2005 10:59:01 +0100
>
>Hi chaps,
>
>I wrote an article on how to generate a comma-delimited file in
>Supportlink Article in VOL 9 NO 1 JAN 1999, page 58. The technique can
>be simplified with the use of the FORMATNUMBER function which is now
>available in all supported versions of PowerHouse.
>
>Basically, there is no auto-format option when writing to subfiles or
>flat files,
>
>Regards
>
>
>Erik A. Hurworth
>Customer Support
>
>( FreePhone 00 800 14 COGNOS (00 800 14 264667)
>* +44 / (0)1344 / 707799
>________________________________________________
>Cognos Ltd
>Registered in England, number 4625339.
>Registered office: Westerly Point, Market Street, Bracknell, Berkshire,
>RG12 1QB, U.K.
>Cognos Home Page: <http://www.cognos.com/>
>Cognos Support Page: <http://support.cognos.com/>
>Cognos Online Support: <http://support.cognos.com/servlet-cs/createcase>
>Cognos KnowlegdeBase: http://support.cognos.com/servlet-cs/kbsearch
>
>-----Original Message-----
>From: powerh-l-bounces+erik.hurworth=cognos.com at lists.sowder.com
>[mailto:powerh-l-bounces+erik.hurworth=cognos.com at lists.sowder.com] On
>Behalf Of Jeff Hoffman
>Sent: 09 June 2005 23:24
>To: powerh-l at lists.sowder.com
>Subject: Re: To Quiz or not to Quiz...
>
>Hi
>
>Depending upon what you are using the data for I remember some time ago
>somebody mentioning the use of a continuation character then you can use
>
>more than 1 line.
>
>Alternatively
>
>you can define a large field and then pack the data into this field and
>use
>subfiles. Numeric data can be formatted using 'formatnumber'.
>
>def sep-char char*1="," ; or tab
>def x char*2000 = trunc(xyz) + sep-char + formatnumber(abc,"$00,000.00")
>+
>sep-char ...etc
>set subfile name file1
>rep sum x
>go
>
>Then in the O/S remove trailing spaces, if necessary.
>
>Jeff Hoffman
>Wonicon Ply Ltd
>
>
>At 07:13 AM 10/06/2005, you wrote:
>
> >Hi everybody,
> >
> >I'm trying to extract powerhouse data to an ASCII file keeping the
>correct
> >dictionary picture format.
> >
> >Using Quiz, everything is OK, it's like a report, so the numbers are
> >formatted according to the dictionary format without having to specify
>a
> >picture for every field. Good! But, I cannot exceed the 263
>characters
> >barrier for a record. It wraps the line. ... hum... too bad...
> >
> >Using QTP, I don't have the wraparound problem but the format of the
> >fields is catastrophic. Presented as they are stored on file, without
>any
> >decimal format, the numbers are useless.
> >
> >There is certainly a way to create records more than 263 characters
>long
> >in Quiz or to use the dictionary format in QTP ?
> >
> >Surely I'm missing something.... ?
> >
> >I'm talking about powerhouse 7.10.E sitting on a vax computer running
> >OpenVMS 6.2
> >
> >Thank's !
> >
> >Best regards.
> >
> >
> >Pierre McLeod Tremblay
> >Consultant T.I. / I.T. Consultant
> >pmcleod at videotron.ca
> >819.263.0791 fax: 819.263.0792
> >My french is better than my english. Sorry for the Frenglish...
> >--
> >= = = = = = = = = = = = = = = = = = = = = = = = = = = =
> >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.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.
>
>
> 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.
>
> Cognos Forum
> Our Annual Customer Conference
> Orlando, June 26-29, 2005
>
> Best Practices. Tips and Techniques. Expert Advice.
> Get more from your Cognos investment.
> Register today at www.cognos.com/cognosforum
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger 7.0 today!
http://messenger.msn.co.uk
More information about the powerh-l
mailing list