Quiz Extract Problem

[Joseph Rosenblatt]

Thanks to the people that answered. ZONED is the way to go. I must have done
something wrong when I tested ZONED the first time. Thanks again to
everyone.

-----Original Message-----
From:	owner-powerh-l@sphere.swau.edu [mailto:owner-powerh-l@sphere.swau.edu]
On Behalf Of Joseph Rosenblatt
Sent:	Wednesday, December 20, 2000 10:06 AM
To:	powerh-l
Subject:	Quiz Extract Problem

I am using QUIZ 8.09C on an HP e3000 979/200KS running MPE i/X 5.5. pp7.

I have an item defined:
Element:            POL-UNIT-PRICE
    Type:               Numeric
    Size:               13
    Decimal Positions:  4
    Item Defaults:      NONIEEE-F Size 8

If I report, using REPORT, this field it returns numeric values. When I
extract this field to a subfile, using REPORT SUM, it reports ASCII
representations of binary characters, i.e. junk. I have tried using REPORT
to a subfile, various picture clauses, defining a new field as numeric,
zoned, even char. It works in quiz but not in the output of the subfile.

In QUIZ:
> acc po-line
> def x int*8=pol-unit-price
> def y zoned*13 =pol-unit-price
> def z num*13=pol-unit-price
> def a cha*13=ascii(pol-unit-price)
> set rep lim 10
> rep pol-unit-price x y z a
> go

        Unit            X            Y               Z        A
       Price
    ------------

            5.6100          5              5               6  5
           20.4100         20             20              20  20
       25,000.0000      25000          25000           25000  25000
       25,000.0000      25000          25000           25000  25000
          335.7500        335            335             336  335
          144.4200        144            144             144  144
          302.0000        302            302             302  302
          302.0000        302            302             302  302
           90.1200         90             90              90  90
           62.4400         62             62              62  62

SUBFILE:

> set subfile name yr1 keep
> rep sum pol-unit-price x y z a
>go
>Records selected:  10
>Records written:   10


When I use this file as input to MS EXCEL or MS ACCESS it looks like this:
@ ô \(3/4û0000000000005@ ô \(3/4â5
AÈæ
   =pÊ0000000000020AÈæ
                      =pÊ20
CÀ´a´0000000025000CÀ´25000
CÀ´a´0000000025000CÀ´25000
BÞO0000000000335BÞ335
Aà5ô \(­ 0000000000144Aà5ô \(¶144
B .0000000000302B 302
B .0000000000302B 302
A ?¡QŠ Z0000000000090A ?¡QŠ 90
A|ÃGÛzÃ>0000000000062A|ÃGÛzÁ62

What am I doing wrong?

Thanks for the help.
Joseph Rosenblatt

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.