Tony,

You can use the TIPS product to extract and format packed decimals for exporting to
MS/SQL, Oracle and MySQL. I believe suprtool also does it. TIPS is $2,500 per server, you
can see it at:
http://www.compthree.com/products/tips.html

-John Hohn
Comp Three
408-513-1000
831-227-3328 (cell)

On 6 Oct 2008 at 16:39, Tony Tibbenham wrote:

>
> 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
> I.T Manager
> Supersine Duramark Ltd
>
> Tel:
> +44 (0)1502 527009
>
> Fax:
> +44 (0)1502 560620
>
> Mobile:
> +44 (0)7976 602335
>
> E-Mail:
> [log in to unmask]
> Web:
> http://www.ssdm.co.uk/
>
> With Christmas approaching we would like to advise you in advance that our offices will be closed from Wednesday 24th December 2008 until Monday 5th January 2009.
>
> Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error.
>
> Security Warning: Please note that this e-mail has been created in the knowledge that internet e-mail is not a 100% secure communications medium . We advise that you understand and observe this lack of security when e-mailing us.
>
> Viruses: Although we have taken steps to ensure that this email and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free.
>
> Any views expressed in this email are those of the individual and are not necessarily those of the company or any of its subsidiaries.
>
> Registered Office: Freemantle Road, Lowestoft, Suffolk, NR33 0EA England. Registered in England Under Company Number 02984457  VAT Reg. No 443 0520 90
> A Supersine Holdings Group Company
> EUROPE'S LEADER IN TRANSPORTATION, INTERIOR AND EXTERIOR GRAPHIC SOLUTIONS
>
>
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *