MUMPS data extraction

[EJ Legarda]

We need help extracting data from a MUMPS database. We have tried
parsing the DAT file that contains all the data using VB but some
characters get ommitted in the process. Can anyone guide us to the
right path of extracting data from this MUMPS DAT file?

[J. Balk]

There are lots of answers to your question and it would help
to know what you're trying to do.

"EJ Legarda" <ejle...@4miles.com> wrote in message
news:5c875186.03050...@posting.google.com...

[Maury Pepper]

"EJ Legarda" <ejle...@4miles.com> wrote in message
news:5c875186.03050...@posting.google.com...

To extract data from a MUMPS database you'll need a working version of MUMPS
(the same version that created the database.)

You need to provide more info about the system. Here are some questions:
1. What is/was the application?
2. What MUMPS implementation: DTM, MSM, DSM, etc. ?
3. What OS: DOS, Win95, Unix, etc. ?
4. Is the system still working so that access to the database via MUMPS is
still an option? Is it accessible via the Internet or dial-in?
5. Do you have any documentation? MUMPS data is kept in "globals", and if
you have any global layouts that can help.

If the system is still working and/or if the source routines are available,
then much can be deduced by looking at the source to determine how the data
was stored.

If you don't know all of the above, it would help to see a directory listing
of the directory containing MUMPS and any application directories.

[Dan @ MTRC]

The ".dat" file is not a database file as you are use to with other db
programs, such as access, etc.. You'll probably have a rough time
trying to do an extract like that.

You need to write a MUMPS program that will walk through your
databases and export the data in some "standard" fashion.

[tlogan]

Originally posted by Ej Legarda

If they can get M up and running but don't have the Global
documentation, standard M systems employ the ^$GLOBAL global to store
global definitions. There may be a problem if the original database was
split into multiple UCIs - I beleive that the ^$GLOBAL resides in the
designated system UCI.

I have several years experience as an M/Oracle DBA (NT, VMS and Unix
using Cache, ISM and DSM MUMPS) and have programmed in M for 9 years. I
have spent the last three years as a strictly Oracle DBA, so I may be a
little rusty in M. If you would like assistance, email me at
to...@loganweb.com.

Good luck!

--
Posted via http://dbforums.com

[Kmulli99]

Originally posted by tlogan

> If they can get M up and running but don't have the Global
> documentation, standard M systems employ the ^$GLOBAL global to store
> global definitions. There may be a problem if the original database
> was split into multiple UCIs - I beleive that the ^$GLOBAL resides in
> the designated system UCI.
>
> I have several years experience as an M/Oracle DBA (NT, VMS and Unix
> using Cache, ISM and DSM MUMPS) and have programmed in M for 9 years.
> I have spent the last three years as a strictly Oracle DBA, so I may
> be a little rusty in M. If you would like assistance, email me at
> to...@loganweb.com.
>
> Good luck!

I am interested in trying to extract Mumps data using DTS in SQL. Has
anyone done anything like this?