Neoview Guide to Stored Procedures in Java (R2.3, R2.4)

Chapter 6: Granting Privileges for
Executing SPJs
Explains how to grant and revoke privileges for executing
SPJs in a Neoview database.
Chapter 7: Executing SPJs Explains how to execute an SPJ on the Neoview platform
by using the CALL statement.
Chapter 8: Performance and
Troubleshooting
Describes how to improve and monitor the performance
of SPJs and provides guidelines for troubleshooting
common problems.
Appendix A: Sample SPJs Provides examples of SPJ methods that demonstrate
business logic in a Neoview database.
Appendix B: Sample Database Describes the sample database on which the Sample SPJs
operate.
Notation Conventions
General Syntax Notation
This list summarizes the notation conventions for syntax presentation in this manual.
UPPERCASE LETTERS Uppercase letters indicate keywords and reserved words. Type these
items exactly as shown. Items not enclosed in brackets are required.
For example:
SELECT
Italic Letters
Italic letters, regardless of font, 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 case-sensitive keywords
and reserved words. Type these items exactly as shown. Items not
enclosed in brackets are required. For example:
myfile.sh
Bold Text
Bold text in an example indicates user input typed at the terminal.
For example:
ENTER RUN CODE
?123
CODE RECEIVED: 123.00
The user must press the Return key after typing the input.
[ ] Brackets Brackets enclose optional syntax items. For example:
DATETIME [start-field TO] end-field
A group of items enclosed in brackets is a list from which you can
choose one item or none. The items in the list can 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:
DROP SCHEMA schema [CASCADE]
[RESTRICT]
DROP SCHEMA schema [ CASCADE | RESTRICT ]
{ } Braces Braces enclose required syntax items. For example:
14