Subject: | |
From: | |
Reply To: | Pickering, John (NORBORD) |
Date: | Mon, 6 Oct 2008 12:01:29 -0400 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
You should be able to get plain ASCII data by asking Quiz to create
"portable" subfiles. It should be as simple as the following four
statements:
:Quiz
>access mytable
>set subfile myname portable
>report summary all
>go
Note the inclusion of the "portable" option on the subfile statement.
Regards,
JWP
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Tony Tibbenham
Sent: Monday, October 06, 2008 11:39 AM
To: [log in to unmask]
Subject: [HP3000-L] OT: Quiz/QSHOW extract of packed decimals
Hi all,
MPE 6.0
QSHOW 7.29.C8
918RX / 64Mb / 40 users
I am trying to extract some data using QSHOW from KSAM and TURBOIMAGE
files but some fields appear to include compressed decimals. Our box is
under-powered / under-RAM'd: It cannot run minisoft ODBC reliably
especially when the data extracts exceed 10,000 lines per table.
Has anyone extracted data including fields which decompresses packed
decimals into something e.g. MS Access or SQL can understand?
At the moment I can get all the data out to 'plain text' but any field
where this encoding happens looks like garbage and causes a wordwrap
that upsets if the numbers encode to 0x0a.
Regards
Tony
Tony Tibbenham
<monster sig snipped>
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|