Understanding SQL & Java Together: A Guide to SQLJ, JDBC, and Related Technologies
A comprehensive guide to how the marriage of SQL and Java is forging a new era in object-oriented databases.
TABLE OF CONTENTS Understanding SQL & Java Together: A Guide to SQLJ, JDBC, and Related Technologies
Appendix D: SQL/PSM Syntax
D.1 Introduction
This appendix contains the syntax used to create procedures and functions in SQL. The syntax in this appendix is taken from SQL:1999. It is not the complete syntax for these features we have rearranged it a bit to make it more readable, and we have pruned it to remove extraneous features and options.
D.2 SQL PSM Syntax
::= CREATE PROCEDURE [ ... ] ::= CREATE FUNCTION [ ... ] <a name="1100"></a><a name="IDX-448"></a> ::= [ [ { }... ] ] ::= [ ] [ ] ::= IN OUT INOUT ::= [ ] ::= AS LOCATOR ::= RETURNS ::= [ ] ::= SPECIFIC ::= LANGUAGE ::= ADA C COBOL FORTRAN MUMPS PASCAL PLI SQL ::= PARAMETER STYLE {...
Copyright Academic Press 2000 under license agreement with Books24x7
