Customer Support: +44 (0)203 327 3140

Login to i2i Subscription Intertek.com
  • Shopping Cart
    There are no items in your cart
We noticed you’re not on the correct regional site. Switch to our AMERICAS site for the best experience.
Go to AMERICAS site
Dismiss alert
Please enter a keyword to search
Advanced search
Home
Publishers
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

Add to Watchlist

Information technology - Database languages - SQL Persistent stored modules

Available format(s)

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

Language(s)

English

Published date

01-01-1998

Publisher

Standards Australia

Superseded date

30-06-2017

Superseded by

AS ISO/IEC 9075.4-2005

Add to Watchlist
Preview
£140.40
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

Summarise
ChatGPT Perplexity
£140.40
Excluding VAT
GBP
AUD
CAD
CHF
CNY
DKK
EUR
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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100