HP3000-L Archives

October 2008, Week 1

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Tony Tibbenham <[log in to unmask]>
Reply To:
Tony Tibbenham <[log in to unmask]>
Date:
Mon, 6 Oct 2008 16:39:17 +0100
Content-Type:
text/plain
Parts/Attachments:
text/plain (63 lines)
 
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 *

ATOM RSS1 RSS2