To Quiz or not to Quiz...
Chris Sharman
chris.sharman at ccagroup.co.uk
Mon Jun 13 07:41:41 CDT 2005
Tim Cummings wrote:
>
>
> If you look at the number of times that this topic has come up on this
> list, it seems to me that the .CSV file output type needs to be added
> to Quiz. Not only that but it would also be nice to have a .CSV input
> file type for qtp.
>
> What do you think Erik, can you twist a few arms in Product Development?
Seconded.
All it really needs is an increase to the 255 page width limit.
Is it really a non-trivial enhancement ? It seems likely to be very
simple to me - possibly even patchable in the executable.
Chris
> -----Original Message-----
> From: Hurworth, Erik [mailto:Erik.Hurworth at cognos.com]
> Sent: Monday, June 13, 2005 5:59 AM
> To: powerh-l at lists.sowder.com
> Subject: RE: To Quiz or not to Quiz...
>
>
> 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.
>
Any views expressed in this message are those of the sender and not necessarily those of CCA Group. The unauthorized use, disclosure, copying or alteration of this message is forbidden. The contents of
this message may be confidential and/or privileged, copyright CCA Group and are intended solely for the use of the individual or entity to whom they are addressed. Whilst this message has been scanned, CCA Group cannot guarantee that it is virus free or compatible with your systems and accepts no responsibility for any loss or damage
arising from its use. The recipient is advised to run their own anti-virus software. If you receive this message in error please contact
postmaster at ccagroup.co.uk immediately, destroy any copies and delete it from your computer systems.
More information about the powerh-l
mailing list