ISO/IEC 9075-4:2003/Cor 1:2005

Information technology — Database languages — SQL — Part 4: Persistent Stored Modules (SQL/PSM) — Technical Corrigendum 1

Technologies de l'information — Langages de base de données — SQL — Partie 4: Modules stockés persistants (SQL/PSM) — Rectificatif technique 1

General Information

• Status: Withdrawn
• Publication Date: 24-Nov-2005
• Withdrawal Date: 24-Nov-2005
• ICS: 35.060 - Languages used in information technology
• Technical Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Drafting Committee: ISO/IEC JTC 1/SC 32/WG 3 - Database language
• Current Stage: 9599 - Withdrawal of International Standard
• Completion Date: 12-Apr-2007

Standards Content (Sample)

INTERNATIONAL STANDARD ISO/IEC 9075-4:2003
TECHNICAL CORRIGENDUM 1
Published 2005-11-15
INTERNATIONAL ORGANIZATION FOR STANDARDIZATION • МЕЖДУНАРОДНАЯ ОРГАНИЗАЦИЯ ПО СТАНДАРТИЗАЦИИ • ORGANISATION INTERNATIONALE DE NORMALISATION
INTERNATIONAL ELECTROTECHNICAL COMMISSION • МЕЖДУНАРОДНАЯ ЭЛЕКТРОТЕХНИЧЕСКАЯ КОМИССИЯ • COMMISSION ÉLECTROTECHNIQUE INTERNATIONALE


Information technology — Database languages — SQL —
Part 4:
Persistent Stored Modules (SQL/PSM)
TECHNICAL CORRIGENDUM 1
Technologies de l'information — Langages de base de données — SQL —
Partie 4: Modules stockés persistants (SQL/PSM)
RECTIFICATIF TECHNIQUE 1
Technical Corrigendum 1 to ISO/IEC 9075-4:2003 was prepared by Joint Technical Committee
ISO/IEC JTC 1, Information technology, Subcommittee SC 32, Data management and interchange.

Statement of purpose for rationale
A statement indicating the rationale for each change to ISO/IEC 9075-4:2003 is included. This is to inform the users of
ISO/IEC 9075-4:2003 why it was judged necessary to change the original wording. In many cases, the reason is editorial
or to clarify the wording; in some cases, it is to correct an error or an omission in the original wording.
Notes on numbering
Where this Technical Corrigendum introduces new Syntax, Access, General, and Conformance Rules, the new rules
have been numbered as follows:
Rules inserted between, for example, Rules 7) and 8) are numbered 7.1), 7.2), etc. [or 7)a.1), 7)a.2), etc.]. Those
inserted before Rule 1) are numbered 0.1), 0.2, etc.
Where this Technical Corrigendum introduces new subclauses, the new subclauses have been numbered as follows:
Subclauses inserted between, for example, 4.3.2 and 4.3.3 are numbered 4.3.2a, 4.3.2b, etc. Those inserted before,
for example, 4.3.1 are numbered 4.3.0, 4.3.0a, etc.
ICS 35.060 Ref. No. ISO/IEC 9075-4:2003/Cor.1:2005(E)
©  ISO/IEC 2005 – All rights reserved
Published in Switzerland

---------------------- Page: 1 ----------------------
ISO/IEC 9075-4:2003/Cor.1:2005(E)
ii ©  ISO/IEC 2005 – All rights reserved

---------------------- Page: 2 ----------------------
ISO/IEC 9075-4:2003/Cor.1:2005(E)
Contents Page
Foreword. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
4 Concepts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
4.8 Cursors. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
4.8.1 General description of cursors. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
4.13 Dynamic SQL concepts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
4.13.1 Dynamic SQL statements and descriptor areas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
5 Lexical elements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2
5.2 Names and identifiers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
6 Scalar expressions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
6.1 and . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
9 Schema definition and manipulation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
9.2a . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3
9.2b . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
9.3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5
9.24 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
9.25 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .6
10 Access control. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7
10.3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
11 SQL-client modules. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .9
11.2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
12 Data manipulation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10
12.3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
13 Control statements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .11
13.1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
13.2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
13.4 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
13.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12
13.9 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
13.13 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
©  ISO/IEC 2005 – All rights reserved iii

---------------------- Page: 3 ----------------------
ISO/IEC 9075-4:2003/Cor.1:2005(E)
17 Information Schema. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
17.2 MODULE_PRIVILEGES view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .14
17.5 PARAMETERS view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
18 Definition Schema. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
18.4 MODULES base table. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Annex D Incompatibilities with ISO/IEC 9075:1999. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
iv ©  ISO/IEC 2005 – All rights reserved

---------------------- Page: 4 ----------------------
ISO/IEC 9075-4:2003/Cor.1:2005(E)
Information technology — Database languages — SQL —
Part 4:
Persistent Stored Modules (SQL/PSM)
TECHNICAL CORRIGENDUM 1
Foreword
1. Rationale:Remove incorrect reference to obsolete part.
th th
In the 7 paragraph, delete the 5 bullet.
4 Concepts
4.8 Cursors
4.8.1 General description of cursors
1. Rationale:Clarify the specifications concerning dynamic result sets.
st
Replace the 1 paragraph with:
Insert this paragraph For every in a , a cursor is effectively
created each time the is executed and destroyed when that execution completes.
NOTE 0.1 — Destroying an open with-result cursor does not simultaneously destroy that cursor's result set.
4.13 Dynamic SQL concepts
1. Rationale:Clarification of the method of identification of dynamic objects.
Insert the following new Subclause:
4.13 Dynamic SQL concepts
This Subclause modifies Subclause 4.24, “Dynamic SQL concepts”, in ISO/IEC 9075-2.
©  ISO/IEC 2005 – All rights reserved 1

---------------------- Page: 5 ----------------------
ISO/IEC 9075-4:2003/Cor.1:2005(E)
4.13.1 Dynamic SQL statements and descriptor areas
Replace the 8th paragraph A cursor declared by either a or a
has a . A is immediately contained in a . A
is immediately contained either in the of an definition> or the of a . The scope of a name> is the innermost or that contains it.
5 Lexical elements
5.2 Names and identifiers
1. Rationale:Provide replacement Syntax Rule for in Part 2.
Insert the following Syntax Rule:
6) Replace Syntax Rule 7) Let CN be a . At least one of the following shall be true:
a) CN is contained, without an intervening in an definition> whose contain a or
whose is CN.
b) CN is contained, without an intervening , in a
whose contains a whose is CN.
6 Scalar expressions
6.1 and
1. Rationale:Add SQL variable to what a and can specify.
Insert the following General Rules:
1) Replace GR 3) A specifies a target that is a host parameter, an output SQL
parameter, a column of a new transition variable, an element of a target whose declared type is an
array type, a parameter used in a dynamically prepared statement, a host variable, or an SQL variable,
according to whether the is a , an parameter reference>, a , a , a parameter specification>, an , or an ,
respectively.
2 ©  ISO/IEC 2005 – All rights reserved

---------------------- Page: 6 ----------------------
ISO/IEC 9075-4:2003/Cor.1:2005(E)
2) Replace GR 13) A specifies a target that is a host parameter, an output
SQL parameter, a column of a new transition variable, a host variable, or an SQL variable, according
to whether the is a , an reference>, a , an , or an ,
respectively.
NOTE 2.1 — A can never be assigned the null value.
9 Schema definition and manipulation
9.2a

1. Rationale:Prohibit s in DDL.
Insert the following new Subclause:
9.2a
This Subclause modifies Subclause 11.3, “”, in ISO/IEC 9075-2.
Function
Define a persistent base table, a created local temporary table, or a global temporary table.
Format
No additional Format items.
Syntax Rules
1) Replace SR 0.1) The shall not contain a , an
, a , an cation>, or an .
Access Rules
No additional Access Rules.
General Rules
No additional General Rules.
©  ISO/IEC 2005 – All rights reserved 3

---------------------- Page: 7 ----------------------
ISO/IEC 9075-4:2003/Cor.1:2005(E)
Conformance Rules
No additional Conformance Rules.
9.2b
1. Rationale:Prohibit s in DDL.
Insert the following new Subclause:
9.2b
This Subclause modifies Subclause 11.4, “”, in ISO/IEC 9075-2.
Function
Define a column of a base table.
Format
No additional Format items.
Syntax Rules
1) Replace SR 0.1) The shall not contain a , an
, a , an cation>, or an .
Access Rules
No additional Access Rules.
General Rules
No additional General Rules.
Conformance Rules
No additional Conformance Rules.
4 ©  ISO/IEC 2005 – All rights reserved

---------------------- Page: 8 ----------------------
ISO/IEC 9075-4:2003/Cor.1:2005(E)
9.3
1. Rationale:Correct override of General Rules.
Replace the General Rules with:
General Rules
No additional General Rules.
9.24
1. Rationale:Add to what a cannot contain.
Insert the following Subclause:
9.24
Function
Specify a condition for the SQL-data.
Format
No additional Format items.
Syntax Rules
1) Replace SR 1) The shall not contain a , an parameter reference>, a , an ,
or an .
Access Rules
No additional Access Rules.
General Rules
No additional General Rules.
©  ISO/IEC 2005 – All rights reserved 5

---------------------- Page: 9 ----------------------
ISO/IEC 9075-4:2003/Cor.1:2005(E)
Conformance Rules
No additional Conformance Rules.
9.25
1. Rationale:Add to what a cannot contain.
Insert the following Subclause:
9.25
Function
Specify a condition for the SQL-data.
Format
No additional Format items.
Syntax Rules
1) Replace SR 3) The shall not contain a , an parameter reference>, a , an ,
or an .
Access Rules
No additional Access Rules.
General Rules
No additional General Rules.
Conformance Rules
No additional Conformance Rules.
6 ©  ISO/IEC 2005 – All rights reserved

---------------------- Page: 10 ----------------------
ISO/IEC 9075-4:2003/Cor.1:2005(E)
10 Access control
10.3
1. Rationale:Adjust references to rules which have moved in Part 2.
Delete Syntax Rules 1), 2), 3), 4), 5), and 6).
2. Rationale:Adjust references to rules which have moved in Part 2.
Insert the following General Rules:
0.1) Insert after GR 0.15) e) EXECUTE privilege on every SQL-server module that includes one or
more SQL-invoked routines that are among the subject routines of a that is
generally contained in the of V.
0.2) Insert after GR 0.17) e) EXECUTE privilege on every SQL-server modules that includes one or
more SQL-invoked routines that are among the subject routines of a that is
generally contained in any of TC.
0.3) Insert after GR 0.18) e) EXECUTE privilege on every SQL-server module that includes one or
more SQL-invoked routines that are among the subject routines of a that is
generally contained in any of AX.
0.4) Insert after GR 0.20) e) EXECUTE privilege on every SQL-server module that includes one or
more SQL-invoked routines that are among the subj
...