Codes & Standards - Purchase
CAN/CSA-ISO/IEC 9075-4-09
Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL/PSM) (Adopted ISO/IEC 9075-4:2008, fourth edition, 2008-07-15)
SKU: 2419900
Published by CSA Group
Publication Year 2009
212 pages
Withdrawn
Product Details
Preface
Standards development within the Information Technology sector is harmonized with international standards development. Through the CSA Technical Committee on Information Technology (TCIT), Canadians serve as the Canadian Advisory Committee (CAC) on ISO/IEC Joint Technical Committee 1 on Information Technology (ISO/IEC JTC1) for the Standards Council of Canada (SCC), the ISO member body for Canada and sponsor of the Canadian National Committee of the IEC. Also, as a member of the International Telecommunication Union (ITU), Canada participates in the International Telegraph and Telephone Consultative Committee (ITU-T). This Standard supersedes CAN/CSA-ISO/IEC 9075-4-04 (adoption of ISO/IEC 9075-4:2003). At the time of publication, ISO/IEC 9075-4:2008 is available from ISO and IEC in English only. CSA will publish the French version when it becomes available from ISO and IEC.
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 in SQL-server modules. The database language for s and SQL-invoked routines includes:
Standards development within the Information Technology sector is harmonized with international standards development. Through the CSA Technical Committee on Information Technology (TCIT), Canadians serve as the Canadian Advisory Committee (CAC) on ISO/IEC Joint Technical Committee 1 on Information Technology (ISO/IEC JTC1) for the Standards Council of Canada (SCC), the ISO member body for Canada and sponsor of the Canadian National Committee of the IEC. Also, as a member of the International Telecommunication Union (ITU), Canada participates in the International Telegraph and Telephone Consultative Committee (ITU-T). This Standard supersedes CAN/CSA-ISO/IEC 9075-4-04 (adoption of ISO/IEC 9075-4:2003). At the time of publication, ISO/IEC 9075-4:2008 is available from ISO and IEC in English only. CSA will publish the French version when it becomes available from ISO and IEC.
Scope
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 in SQL-server modules. The database language for s 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 declaration of standing SQL-server 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.
Request Copyright Permissions
To order this product please contact us
GST REG No R119441681
QST REG No R1006017360
