SQL Training Course: Host Programs, MUMPS

Home The Course FAQs CBT Blog Sample Lab Contact

October 12th, 2009

Host Programs, MUMPS

Posted by admin in S. Host Programs

Syntax Element      In MUMPS
prefix              &SQL(
terminator          )
target              statement label

Variable Definition Syntax

MUMPS variable definition =
    { numeric variable | character variable };

MUMPS character variable =
    VARCHAR { host identifier (length) }...

MUMPS numeric variable =
    { DEC [ ( precision [ , scale ] ) ] }
  | INT
  | REAL }
    host identifier...

SQL Type            MUMPS Type
CHAR                VARCHAR
DECIMAL             DEC
INTEGER             INT
REAL                REAL
VARCHAR             VARCHAR
SQLCODE             INTEGER
SQLSTATE            VARCHAR (5)
indicator           INT

2 Responses to ' Host Programs, MUMPS '

Subscribe to comments with RSS or TrackBack to ' Host Programs, MUMPS '.

Eugene Barett said,

on January 24th, 2010 at 10:22 am

It looks that you’ve put a good amount of effort into your article and I require a lot more of these on the web these days. I sincerely got a kick out of your post. I do not have a bunch to to say in reply, I only wanted to register to say fantastic work.
Ina Mckoon said,

on February 3rd, 2010 at 6:48 am

I can see that you, beyond any doubt, know what you’re talking about. Thank you for such an interesting blog post. I’ll be sure to come back and read more later.