Extracting data in MUMPS

[Henry Chua]

Hi Guys,

Happy New yr!! =)

Here goes, I have a client who need to extract data in MUMPS into a CSV file. I have no knowledge in MUMPS, is there an easy way to do this?

Many thanks.

Best regards
Henry

[James R. Ferguson · Accepted solution]

Hi Henry:

"Mumps" is the older name for the 'M' language:

http://en.wikipedia.org/wiki/MUMPS

http://en.wikipedia.org/wiki/GT.M

In fact, one can see that, "It is an implementation of ANSI standard M for various UNIX systems and for Hewlett-Packard's OpenVMS system."

There is a Perl module that offers access to a GT.M database that might help:

http://search.cpan.org/~szeck/Db-GTM-1.27/GTM.pm

You might combine this with another Perl module (by H. Merijn Brand) to compose your comma-separated-values (CSV):

http://search.cpan.org/~hmbrand/Text-CSV_XS-0.32/CSV_XS.pm

As I noted, above, M[umps] implementations are associated with OpenVMS, so you might raise your query in that forum family, too.

Regards!

...JRF...

[Tim Nelson]

Check this out as well.

www.intersystems.com ( they now call their product Cache, but it is basically MUMPS under the covers ).

D ^%G
w ^GlobalName
both will diplay the contents of a global(data structure) from within the MUMPS environment.

There is also books available, google it..

Here is a good start.
http://www.mcenter.com/mtrc/mfaqhtm1.html