SQL/MX 3.2.1 Guide to Stored Procedures in Java (H06.26+, J06.15+)

For the entire set of sample SPJs, see Appendix A: Sample SPJs.
Notation Conventions
Hypertext Links
Blue underline is used to indicate a hypertext link within text. By clicking a passage of text with a
blue underline, you are taken to the location described. For example:
This requirement is described under Backup DAM Volumes and Physical Disk Drives
General Syntax Notation
The following list summarizes the notation conventions for syntax presentation in this manual.
UPPERCASE LETTERS.
Uppercase letters indicate keywords and reserved words; enter these items exactly as shown. Items
not enclosed in brackets are required. For example:
MAXATTACH
lowercase italic letters.
Lowercase italic letters indicate variable items that you supply. Items not enclosed in brackets are
required. For example:
file-name
computer type. Computer type letters within text indicate C and Open System Services (OSS)
keywords and reserved words; enter these items exactly as shown. Items not enclosed in brackets
are required. For example:
myfile.c
italic computer type.
Italic computer type letters within text indicate C and Open System Services (OSS) variable
items that you supply. Items not enclosed in brackets are required. For example:
pathname
[ ] Brackets.
Brackets enclose optional syntax items. For example:
TERM [\system-name.]$ terminal-name
INT[ERRUPTS]
A group of items enclosed in brackets is a list from which you can choose one item or none. The
items in the list may be arranged either vertically, with aligned brackets on each side of the list,
or horizontally, enclosed in a pair of brackets and separated by vertical lines. For example:
FC [ num ]
[ -num]
[ text]
K [ X | D ] address
{ } Braces.
A group of items enclosed in braces is a list from which you are required to choose one item. The
items in the list may be arranged either vertically, with aligned braces on each side of the list, or
horizontally, enclosed in a pair of braces and separated by vertical lines. For example:
LISTOPENS PROCESS { $appl-mgr-name }
{ $process-name }
ALLOWSU { ON | OFF }
| Vertical Line.
A vertical line separates alternatives in a horizontal list that is enclosed in brackets or braces. For
example:
12