• Shopping Cart
    There are no items in your cart

AS 3968.4-1998

Superseded

Superseded

A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.

View Superseded by

Information technology - Database languages - SQL Persistent stored modules

Available format(s)

Hardcopy , PDF 1 User , PDF 3 Users , PDF 5 Users , PDF 9 Users

Superseded date

30-06-2017

Superseded by

AS ISO/IEC 9075.4-2005

Language(s)

English

Published date

01-01-1998

€167.98
Excluding VAT

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.

Committee
IT-027
DocumentType
Standard
ISBN
0 7337 1965 1
Pages
231
PublisherName
Standards Australia
Status
Superseded
SupersededBy
Supersedes

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).

Standards Relationship
ISO/IEC 9075-4:1996 Identical

First published as AS 3968.4-1998.

AS 2580-1991 Programming languages - Pascal
AS/NZS 3968.0:1994 Information technology - Database languages - SQL Definition of data structures and basic operations
AS/NZS 1486:1993 Information technology - Programming languages - Fortran 90 (Reconfirmed 2014)
AS 1209-1978 Programming language COBOL
AS 3981-1991 Information technology - Programming languages - Extended Pascal
AS 3955-1991 Programming languages - C

Access your standards online with a subscription

Features

  • Simple online access to standards, technical information and regulations.

  • Critical updates of standards and customisable alerts and notifications.

  • Multi-user online standards collection: secure, flexible and cost effective.