{"id":636296,"date":"2024-11-06T00:56:34","date_gmt":"2024-11-06T00:56:34","guid":{"rendered":"https:\/\/pdfstandards.shop\/product\/uncategorized\/iso-iec-9075-42016\/"},"modified":"2024-11-06T00:56:34","modified_gmt":"2024-11-06T00:56:34","slug":"iso-iec-9075-42016","status":"publish","type":"product","link":"https:\/\/pdfstandards.shop\/product\/publishers\/iso\/iso-iec-9075-42016\/","title":{"rendered":"ISO\/IEC 9075-4:2016"},"content":{"rendered":"<p>ISO\/IEC 9075-4:2016 speci?es the syntax and semantics of a database language for declaring and maintaining persistent database language routines in SQL-server modules.<\/p>\n<p>The database language for &lt;externally-invoked procedure&gt;s and &lt;SQL-invoked routine&gt;s includes:<\/p>\n<p>&#8211; The speci?cation of statements to direct the ?ow of control.<\/p>\n<p>&#8211; The assignment of the result of expressions to variables and parameters.<\/p>\n<p>&#8211; The speci?cation of condition handlers that allow SQL-invoked routines to deal with various conditions that arise during their execution.<\/p>\n<p>&#8211; The speci?cation of statements to signal and resignal conditions.<\/p>\n<p>&#8211; The declaration of standing SQL-server cursors.<\/p>\n<p>&#8211; The declaration of local variables.<\/p>\n<p>It also includes the de?nition of the Information Schema tables that contain schema information pertaining to SQL-server modules and SQL-invoked routines.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><b>Information technology \u2014 Database languages \u2014 SQL \u2014 Part 4: Persistent stored modules (SQL\/PSM)<\/b><\/p>\n<table style=\"width: 100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>Published By<\/td>\n<td>Publication Date<\/td>\n<td>Number of Pages<\/td>\n<\/tr>\n<tr>\n<td><a href=\"https:\/\/pdfstandards.shop\/product-category\/publishers\/iso\/\"><b>ISO<\/b><\/a><\/td>\n<td>2016-12<\/td>\n<td>201<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"featured_media":636310,"template":"","meta":{"rank_math_lock_modified_date":false,"ep_exclude_from_search":false},"product_cat":[664,2634],"product_tag":[],"class_list":{"0":"post-636296","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-35-060","7":"product_cat-iso","9":"first","10":"instock","11":"sold-individually","12":"shipping-taxable","13":"purchasable","14":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product\/636296","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media\/636310"}],"wp:attachment":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media?parent=636296"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_cat?post=636296"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_tag?post=636296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}