Customer Support: +1 416-401-8730

Login to i2i Subscription Intertek.com
  • There are no items in your cart
Please enter a keyword to search
Advanced search
Home
AS
AS 3968.4-1998

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
superseded

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

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

06-30-2017

Language(s)

English

Published date

01-01-1998

Publisher

Standards Australia

Preview

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

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

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

View more information
US$178.29
Excluding Tax where applicable
USD
CAD
CHF
CNY
DKK
EUR
GBP
HKD
IDR
INR
JPY
KRW
MXN
NOK
NZD
SEK
SGD
USD
ZAR
Hardcopy - English
PDF 1 User - English
PDF 3 Users - English
PDF 5 Users - English
PDF 9 Users - English
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50

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.

Learn more on subscription solutions

or

Get in touch with us