{"id":221,"date":"2023-02-22T17:04:27","date_gmt":"2023-02-22T16:04:27","guid":{"rendered":"http:\/\/www.sepchat.com\/SC\/?page_id=221"},"modified":"2023-02-22T17:25:12","modified_gmt":"2023-02-22T16:25:12","slug":"sql","status":"publish","type":"page","link":"http:\/\/www.sepchat.com\/SC\/index.php\/sql\/","title":{"rendered":"SQL"},"content":{"rendered":"<form role=\"search\" method=\"get\" action=\"http:\/\/www.sepchat.com\/SC\/\" class=\"wp-block-search__button-inside wp-block-search__icon-button wp-block-search\"><label for=\"wp-block-search__input-1\" class=\"wp-block-search__label screen-reader-text\">Rechercher<\/label><div class=\"wp-block-search__inside-wrapper \"  style=\"width: 50%;border-width: 0px;border-style: none;border-radius: calc(100px + 4px)\"><input type=\"search\" id=\"wp-block-search__input-1\" class=\"wp-block-search__input\" name=\"s\" value=\"\" placeholder=\"Recherche\"  style=\"border-radius: 100px\" required \/><button type=\"submit\" class=\"wp-block-search__button has-icon wp-element-button\"  style=\"border-radius: 100px\" aria-label=\"Rechercher\"><svg class=\"search-icon\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\">\n\t\t\t\t\t<path d=\"M13.5 6C10.5 6 8 8.5 8 11.5c0 1.1.3 2.1.9 3l-3.4 3 1 1.1 3.4-2.9c1 .9 2.2 1.4 3.6 1.4 3 0 5.5-2.5 5.5-5.5C19 8.5 16.5 6 13.5 6zm0 9.5c-2.2 0-4-1.8-4-4s1.8-4 4-4 4 1.8 4 4-1.8 4-4 4z\"><\/path>\n\t\t\t\t<\/svg><\/button><\/div><\/form>\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-4\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-link-color wp-elements-848f5215d1f7872848a7aaa900195075\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/sql-exporter-un-spool-au-format-pdf\/\" data-type=\"post\" data-id=\"230\">SQL &#8211; Exporter un Spool au format PDF<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:04:27+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-primary-color has-alpha-channel-opacity has-primary-background-color has-background is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-7\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-contrast-color has-text-color has-link-color wp-elements-1defb1eedd1becf13b8924c4f6902f85\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/ibm-i-creer-une-table-temporelle\/\" data-type=\"post\" data-id=\"236\">IBM i &#8211; Cr\u00e9er une table temporelle<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:90px\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:04:27+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-primary-color has-alpha-channel-opacity has-primary-background-color has-background is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-10\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-link-color wp-elements-1bd611ad091633ad4af0d4e7061dd911\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/14\/ibmi-sql-lire-une-dtaara\/\" data-type=\"post\" data-id=\"65\">IBMi\u00a0&#8211; SQL Lire une DTAARA<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:90px\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:04:27+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-primary-color has-alpha-channel-opacity has-primary-background-color has-background is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-13\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-link-color wp-elements-a31cb00b94804809fb4781ebf5bccc36\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/sql-afficher-le-nombre-denregistrements-affectes\/\" data-type=\"post\" data-id=\"240\">SQL\u00a0&#8211; Afficher le nombre d&rsquo;enregistrements affect\u00e9s<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:90px\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:04:27+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-primary-color has-alpha-channel-opacity has-primary-background-color has-background is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-16\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-link-color wp-elements-2c11e26476aeae4317598527e6a5d03a\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/sql-controler-lexistence-dun-champ\/\" data-type=\"post\" data-id=\"242\">SQL\u00a0&#8211; Controler l&rsquo;existence d&rsquo;un champ<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:90px\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:04:27+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-primary-color has-alpha-channel-opacity has-primary-background-color has-background is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-19\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-link-color wp-elements-951745684793fba0484ac9cbc52321a7\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/triggers-de-type-sql\/\" data-type=\"post\" data-id=\"244\">Triggers\u00a0de type *SQL<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:90px\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:04:27+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-primary-color has-alpha-channel-opacity has-primary-background-color has-background is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-22\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-link-color wp-elements-1f3edc7846f461c616f25110f44990e3\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/sql-requete-avec-tri-conditionnel\/\" data-type=\"post\" data-id=\"246\">SQL\u00a0&#8211; Requ\u00e8te avec Tri conditionnel<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:90px\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:04:27+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-primary-color has-alpha-channel-opacity has-primary-background-color has-background is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-25\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-link-color wp-elements-cc3dccd768ec34ba28a0bba6dd2bd568\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/ibm-i-afficher-lhistorique-dune-session-sql\/\" data-type=\"post\" data-id=\"248\">IBM\u00a0i &#8211; Afficher l\u2019historique d\u2019une session SQL<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:90px\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:04:27+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-31\">\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:430px\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\">\n<div class=\"wp-block-group has-global-padding is-layout-constrained\">\n<div class=\"wp-block-columns is-layout-flex wp-container-28\">\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:100%\">\n<figure class=\"wp-block-image alignright size-full is-resized\"><a href=\"sql2\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/www.sepchat.com\/SC\/wp-content\/uploads\/2023\/02\/fleche-edited-1.png\" alt=\"\" class=\"wp-image-183\" width=\"16\" height=\"16\"\/><\/a><\/figure>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>SQL &#8211; Exporter un Spool au format PDF IBM i &#8211; Cr\u00e9er une table temporelle IBMi\u00a0&#8211; SQL Lire une DTAARA SQL\u00a0&#8211; Afficher le nombre d&rsquo;enregistrements affect\u00e9s SQL\u00a0&#8211; Controler l&rsquo;existence d&rsquo;un champ Triggers\u00a0de type *SQL SQL\u00a0&#8211; Requ\u00e8te avec Tri conditionnel IBM\u00a0i &#8211; Afficher l\u2019historique d\u2019une session SQL<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/pages\/221"}],"collection":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/comments?post=221"}],"version-history":[{"count":3,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/pages\/221\/revisions"}],"predecessor-version":[{"id":250,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/pages\/221\/revisions\/250"}],"wp:attachment":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/media?parent=221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}