Button for 1977 Button for 1984 Button for 1990 Button for 1995 Button for MDC Button for notes Button for examples

Embedded SQL Host Program

1995 Version of ANSI (Equivalent to Current ISO Version) of Standard

"19.1 <embedded SQL host program>"

[ ... ]

Syntax Rules

  1. An <embedded SQL host program> is a compilation unit that consists of programming language text and SQL text. The programming language text shall conform to the requirements of a specific standard programming language. The SQL text shall consist of one or more <embedded SQL statement>s and, optionally, one or more <embedded SQL declare section>s, as defined in this standard.
  2. An <embedded SQL statement>, <embedded SQL begin declare>, or <embedded SQL end declare> that is contained in an <embedded SQL MUMPS program> shall contain an <SQL prefix> that is "<ampersand>SQL<open paren>". There shall be no <separator> between the <ampersand> and "SQL" nor between "SQL" and the <open paren>.
    [ ... ]
  3. [ ... ]
    An <embedded SQL statement>, <embedded SQL begin declare>, or <embedded SQL end declare> that is contained in an <embedded SQL MUMPS program> shall contain an <SQL terminator> that is a <close paren>.
  4. The <token>s comprising an <SQL prefix>, <embedded SQL begin declare>, or <embedded SQL end declare> shall be separated by <space> characters and be specified on one line. Otherwise, the rules for the continuation of lines and tokens from one line to the next and for the placement of host language comments are those of the programming language of the containing <embedded SQL host program>.

[ ... ]

Button for 1977 Button for 1984 Button for 1990 Button for 1995 Button for MDC Button for notes Button for examples

Copyright © Standard Documents; 1977-2024 MUMPS Development Committee;
Copyright © Examples: 1995-2024 Ed de Moel;
Copyright © Annotations: 2003-2008 Jacquard Systems Research
Copyright © Annotations: 2008-2024 Ed de Moel.

This page most recently updated on 28-Nov-2011, 21:03:46.

For comments, contact Ed de Moel (demoel@jacquardsystems.com)