NCITS (National Committee for Information Technology Standards)

NEWS RELEASE

Doc. No.: PR/97-065
Reply to: Barbara Bennett at bbennett@itic.nw.dc.us

NCITS Announces the Public Review Comment Period for ISO/IEC 9075-4, Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM), for Adoption as an American National Standard

Washington D.C., May 1997 - NCITS (National Committee for Information Technology Standards is announcing the public comment period for ISO/IEC 9075-4. The public review extends from June 6, 1997, 1996 to August 5, 1997.

ISO/IEC 9075-4 specifies the syntax and semantics of a database language for declaring and maintaining persistent database language routines either in SQL-server modules of as standalone schema-level routines, and invoking them from programs written in a standard programming language. The database language for procedures and SQL-invoked routines 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. The context for ISO/IEC 9075 is described by the Reference Model of Data Management (ISO/IEC 10032:1993).

Note: This international standard is being adopted as an American National Standard; originally the U.S. voted to disapprove on the Draft International Standard. As a result, substantive changes were made that were satisfactory to the U.S. and incorporated into the final publication.

Public Review Comment Instructions:

The public review period closes on August 5, 1997. All commentors are urged to submit comments as early in the public review period as possible. Public review comments received after August 5, 1997 will be addressed and considered for future balloting and/or revision.

Submit all comments to: NCITS Secretariat, Attn.: Barbara Bennett, 1250 Eye Street, NW, Suite 200, Washington, DC 20005, Email: bbennett@itic.nw.dc.us. Send a copy to: ANSI, Attn.: BSR Center, 11 West 42nd Street, New York, NY 10036.

To facilitate speedy consideration of comments, please submit them via email (bbennett@itic.nw.dc.us). Please note, however, that an original hardcopy with signature is *required* before the comment will be registered as a formal public review comment.

A call for possible patents and pertinent issues (copyrights, trademarks) is also being issued. Please submit information on these issues to the NCITS Secretariat at 1250 Eye Street NW, Suite 200, Washington DC 20005. Email: NCITS@itic.nw.dc.us FAX: (202)638-4922.

The document can be purchased from the American National Standards Institute, 11 West 42nd Street, New York, New York 10036. Telephone: 212-642-4900.

Press Index

NCITS Home Page