To Quiz or not to Quiz...

[Hurworth, Erik]

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 &lt;password&gt;" 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 &lt;password&gt;" 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