[MAYBE SPAM] converting numerics

[Deskin, Bob]

Subfiles are designed to output data to be read by another application
(QUIZ, QTP, etc). That's why the data is in an internal format. The
external formatting (PIC, etc) is not ignored but is carried along to be
used if necessary in a future report.

Chris is right about using FORMATNUMBER. It's available in the current
PowerHouse Series 8 releases (8.4x). To use it, create a character item
DEFINE that uses the FORMATNUMBER and whatever formatting you need. Then
put the defined item in the subfile.

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 Chris Sharman
Sent: September 2, 2004 11:00 AM
To: powerh-l@lists.sowder.com
Subject: Re: [MAYBE SPAM] converting numerics


Kristina Carlton wrote:
> I am writing out data via Quiz extracts. Due to the size of the files 
> we
> are using the subfiles versus the textfiles and I noticed that my
number 
> formats are gone in the subfiles. I tried the PICTURE command but it 
> basically ignores it. So for example, 114.56 looks like +00000011456. 
> When we read this data into our Progress database, it comes in as
11,456.
> 
> Is the only way to get around this in Quiz to convert the numerics to
> ASCII and then physically place the decimal? If so, do I have to check


The best ascii conversion routine is formatnumber (present in more 
recent Powerhouse versions I believe - 7.10F+ for VMS) - this allows you

to do just about everything you could want.
The ascii function is, as you've noticed, very basic.

Chris



-----------------------------------------------------------------------

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@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems. = = = = = = = = = = = = = = = = = = = = = =
= = = = = = 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.