Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Extracting data from PICK database

Posted on 2004-11-19
Medium Priority
Last Modified: 2012-06-27
I have an old Point of Sales system running on PICK operating system or database. I understand it is both. The system is falling over all the time. I need to extract the stock listing, about 10000 items, to import into another new system.

Any ideas?

I do not know how to work PICK. It has a menu that seems fixed. I cant find a way to dump a printout to a text file instead of the printer.
Question by:Alex Angus
  • 2
  • 2

Expert Comment

ID: 12633286
- Print stock listing
- OCR printed pages to text files
- convert text files to new database format

LVL 50

Expert Comment

ID: 12633302
Hi alexangus,

have you tried the newsgroup (comp.databases.pick) ?

can these guys help http://www.fusionware.net/  (did pick become MULTIVALUE???)

you may find something here http://efunda.intota.com/multisearch.asp?mode=&strSearchType=all&strQuery=Pick+database+system

i seem to remember a PICK question about getting access to data within the last YEAR/18Months but haven't found it yet...
may have been in the SQL Server Topic area...


LVL 50

Accepted Solution

Lowfatspread earned 2000 total points
ID: 12633308

alternatively here's a programming manual http://www.jes.com/pb/pbapg.pdf

for pick and BASIC?

good luck

Author Comment

by:Alex Angus
ID: 12634466
Yes this is the option we are trying to overcome. We have tested it and it would be fine, except for the huge volume of work in achieving this.

Yes I did find something but there was no final answer to that. I sent a mail to the originator, but I think he has gone away since it was about a year ago. I followed the PICK story, but it seems it has almost disappeared as a product except for one company that has a new version of it. Do not recall the name off hand. But I will try your suggestions and let you know.

The site is about 400km from here, so I will get back to you during the week.


Author Comment

by:Alex Angus
ID: 12634541
Remember now that I am following some of your links.

Pick became Universe when Informix took it over and it is now D3 from Raining Data.

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question