Matches in DBpedia 2014 for { <http://dbpedia.org/resource/SQL/PSM> ?p ?o. }
Showing items 1 to 28 of
28
with 100 items per page.
- PSM abstract "SQL/PSM (SQL/Persistent Stored Modules) is an ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures. Initially published in 1996 as an extension of SQL-92 (ISO/IEC 9075-4:1996, a version sometimes called PSM-96 or even SQL-92/PSM), SQL/PSM was later incorporated into the multi-part SQL:1999 standard, and has been part 4 of that standard since then, most recently in SQL:2011. The SQL:1999 part 4 covered less than the original PSM-96 because the SQL statements for defining, managing, and invoking routines were actually incorporated into part 2 SQL/Foundation, leaving only the procedural language itself as SQL/PSM. The SQL/PSM facilities are still optional as far as the SQL standard is concerned; most of them are grouped in Features P001-P008.SQL/PSM standardizes syntax and semantics for control flow, exception handling (called "condition handling" in SQL/PSM), local variables, assignment of expressions to variables and parameters, and (procedural) use of cursors. It also defines an information schema (metadata) for stored procedures. SQL/PSM is one language in which methods for the SQL:1999 structured types can be defined. (The other is Java, via SQL/JRT.)In practice MySQL's procedural language and IBM's SQL PL (used in DB2) are closest to the SQL/PSM standard.SQL/PSM resembles and inspired by PL/SQL, as well as PL/pgSQL, so they are similar languages. With PostgreSQL v9.X some SQL/PSM features, like overloading of SQL-invoked functions and procedures are now supported.A PostgreSQL addon implements SQL/PSM (alongside its own procedural language), although it is not part of the core product.".
- PSM wikiPageID "11665200".
- PSM wikiPageRevisionID "584226902".
- PSM hasPhotoCollection PSM.
- PSM subject Category:Data-centric_programming_languages.
- PSM subject Category:Data_management.
- PSM subject Category:Programming_languages_created_in_the_1990s.
- PSM subject Category:SQL.
- PSM type Abstraction100002137.
- PSM type ArtificialLanguage106894544.
- PSM type Communication100033020.
- PSM type Language106282651.
- PSM type ProgrammingLanguage106898352.
- PSM type ProgrammingLanguagesCreatedInThe1990s.
- PSM type ProgrammingLanguage.
- PSM type Software.
- PSM type Work.
- PSM type CreativeWork.
- PSM type InformationEntity.
- PSM comment "SQL/PSM (SQL/Persistent Stored Modules) is an ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures. Initially published in 1996 as an extension of SQL-92 (ISO/IEC 9075-4:1996, a version sometimes called PSM-96 or even SQL-92/PSM), SQL/PSM was later incorporated into the multi-part SQL:1999 standard, and has been part 4 of that standard since then, most recently in SQL:2011.".
- PSM label "SQL/PSM".
- PSM label "SQL/PSM".
- PSM sameAs m.02rn6ww.
- PSM sameAs Q4048876.
- PSM sameAs Q4048876.
- PSM sameAs PSM.
- PSM wasDerivedFrom PSM?oldid=584226902.
- PSM isPrimaryTopicOf PSM.