AS 3968.4-1998

Specifies the syntax and semantics of a database language for declaring and maintaining persistent database routines either in SQL-server modules or as standalone schema-level routines, and invoking them from programs written in a standard programming language. This Standard is identical with and has been reproduced from ISO/IEC 9075-4:1996.

This part of International Standard ISO/IEC 9075 specifies the syntax and semantics of a database language for declaring and maintaining persistent database language routines either in SQL-server modules or as standalone schema-level routines, and invoking them from programs written in a standard programming language.The database language for s and SQL-invoked routine>s includes:- The specification of statements to direct the flow of control.- The assignment of the result of expressions to variables and parameters.- The specification of condition handlers that allow SQL-invoked routines to deal with various conditions that arise during their execution.- The specification of statements to signal and resignal conditions.- The ability to set an SQL-path for controlling the determination of the subject routine to be invoked.- The declaration of local cursors.- The declaration of local variables.It also includes the definition of the Information Schema tables that contain schema information pertaining to SQL-server modules and SQL-invoked routines.NOTE 1 - The context for ISO/IEC 9076 is described by the Reference Model of Data Management(ISO/IEC 10032:1993).

First published as AS 3968.4-1998.