{"id":10647,"date":"2020-04-21T09:37:00","date_gmt":"2020-04-21T07:37:00","guid":{"rendered":"http:\/\/54.194.80.134.nip.io\/?p=10647"},"modified":"2023-03-30T22:56:40","modified_gmt":"2023-03-30T20:56:40","slug":"sqlscript-loesungsmuster","status":"publish","type":"post","link":"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/","title":{"rendered":"SQLscript L\u00f6sungsmuster"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"10647\" class=\"elementor elementor-10647\" data-elementor-settings=\"{&quot;element_pack_global_tooltip_width&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;element_pack_global_tooltip_width_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;element_pack_global_tooltip_width_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;element_pack_global_tooltip_padding&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_padding_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_padding_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_border_radius&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_border_radius_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_border_radius_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true}}\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1de6572 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1de6572\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-69f791f\" data-id=\"69f791f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d77224f elementor-widget elementor-widget-text-editor\" data-id=\"d77224f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Lange danach gesucht? Jetzt gefunden!<\/h3><p>Unsere \u00dcbersicht von typischen Problemen und L\u00f6sungen im Bereich von HANA SQLscript.\u00a0<\/p><p>Die L\u00f6sungsmuster reichen dabei von rein sprachlichen Problemen (z.B. &#8222;mit welchem Sprachelement ermittle ich den ersten Eintrag&#8220;) \u00fcber formale Probleme (z.B. &#8222;wie wandle ich in SQLscript Zeitmerkmale um&#8220;) bis zu applikatorischen Anforderungen (z.B. &#8222;wie lese ich in SQLscript Stammdaten nach&#8220;).<\/p><p>Die L\u00f6sungsmuster erheben nicht den Anspruch, die alleinige oder beste L\u00f6sung eines Problems zu sein, sondern sollen als Kopiervorlage dienen und Sie mit verschiedenen L\u00f6sungsans\u00e4tzen inspirieren.\u00a0<span style=\"font-size: 1rem\">Ihr Feedback zu Verbesserungen, Alternativen und Erg\u00e4nzungen ist jederzeit willkommen!<\/span><\/p><p><span style=\"font-size: 1rem\">Das Coding-Beispiel ist so formuliert, wie es typischerweise in einer AMDP-Routine vorkommen k\u00f6nnte. Diese Formulierung kann allerdings in einem HANA-Studio-SQL-Fenster oder im SQL-Editor der ABAP-Transaktion DBACOCKPIT nicht verwendet werden (da dort nicht definiert ist, was die inTab sein soll). Es ist daher an einigen Stellen auch ein Coding-Beispiel angegeben, das man im SQL-Fenster verwendet k\u00f6nnte. In diesen Beispielen sind zus\u00e4tzliche Zeilen, die die Beispieldaten aufbauen.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d2b8053 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d2b8053\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-fc15c01\" data-id=\"fc15c01\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-defde1a elementor-widget elementor-widget-text-editor\" data-id=\"defde1a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-size: 1rem\"><b>Grundlegende Sprachelemente:<\/b><\/span><\/p><ol><li><a href=\"#initialwerte\">Initialwerte<\/a><\/li><li><a href=\"#tmptabellen\">Tempor\u00e4re Tabellen (Tabellenvariablen)<\/a><\/li><li><a href=\"#rename\">Umbenennen von Spalten<\/a><\/li><li><a href=\"#unionall\">Vereinigung gleicher Tabellen<\/a><\/li><li><a href=\"#join\">Join zweier Tabellen<\/a><\/li><li><a href=\"#case\">Fallunterscheidung<\/a><\/li><li><a href=\"#defvar\">Variable definieren, f\u00fcllen und benutzen<\/a><\/li><li><a href=\"#null\">NULL-Werte vermeiden<\/a><\/li><li><a href=\"#anzzeilen\">Anzahl Zeilen z\u00e4hlen<\/a><\/li><li><a href=\"#bedingung\">Bedingungen<\/a><\/li><li><a href=\"#sum\">Summe, Max, Min, &#8230;<\/a><\/li><li><a href=\"#ltrim\">F\u00fchrende 0en ersetzen<\/a><\/li><li><a href=\"#numcheck\">Pr\u00fcfung auf Ziffern<\/a><\/li><li><a href=\"#dense\">Verdichten von Leerzeichen<\/a><\/li><li><a href=\"#invalid\">Entfernen ung\u00fcltiger Zeichen<\/a><\/li><li><a href=\"#first\">Ersten Datensatz ermitteln<\/a><\/li><li><a href=\"#rang\">Rang ermitteln<\/a><\/li><li><a href=\"#leadlag\">Zugriff auf vorherige oder nachfolgende Zeile<\/a><\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-231f59e\" data-id=\"231f59e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fd2f369 elementor-widget elementor-widget-text-editor\" data-id=\"fd2f369\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-size: 1rem\"><b>Applikatorische L\u00f6sungen:<\/b><\/span><\/p><ol><li><a href=\"#datumsrechnung\">Datumsrechnung<\/a><\/li><li><a href=\"#utc-zeitstempel\">Herleitung eines aktuellen UTC-Zeitstempels<\/a><\/li><li><a href=\"#requesttsn\">Herleitung der Request-TSN<\/a><\/li><li><a href=\"#lastwo\">Aktuellste Daten eines wo-ADSO<\/a><\/li><li><a href=\"#stammdaten\">Nachlesen von Stammdaten<\/a><\/li><li><a href=\"#exithandler\">Im AMDP SQL-Fehler abfangen<\/a><\/li><li><a href=\"#ownsqlerr\">Im AMDP eigene SQL-Fehlermeldungen werfen<\/a><\/li><li><a href=\"#errhandling\">Im AMDP g\u00fcltige S\u00e4tze verbuchen, fehlerhafte S\u00e4tze in Errorstack schreiben<\/a><\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-967ad15 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"967ad15\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2b0e774\" data-id=\"2b0e774\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-30ed67c elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"30ed67c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-96c847d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"96c847d\" data-element_type=\"section\" data-e-type=\"section\" id=\"initialwerte\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e1e7896\" data-id=\"e1e7896\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1455cac elementor-widget elementor-widget-heading\" data-id=\"1455cac\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Initialwerte<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-df3df84 elementor-widget elementor-widget-text-editor\" data-id=\"df3df84\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Zeichenartige Spalten mit &#8220; initalisieren, Nummern mit 0.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-3ac30ad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3ac30ad\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-5d2f0a4\" data-id=\"5d2f0a4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a32f2f8 elementor-widget elementor-widget-heading\" data-id=\"a32f2f8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-af7e2aa\" data-id=\"af7e2aa\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-05c10b3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"05c10b3\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7e9b5aa\" data-id=\"7e9b5aa\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-60afd03 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"60afd03\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>outtab =\r\nSELECT\r\n&#039;&#039; AS &quot;\/BIC\/STRASSE&quot;,\r\n0  AS &quot;\/BIC\/HAUSNR&quot;\r\nFROM :intab; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8f81862 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8f81862\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-03b65c0\" data-id=\"03b65c0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7ca37f0 elementor-widget elementor-widget-text-editor\" data-id=\"7ca37f0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Eine \u00e4hnliche Formulierung erzeugt Beispieldaten, die dann weiterverwendet werden k\u00f6nnen.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-5c70c1b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5c70c1b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-7f7ae4b\" data-id=\"7f7ae4b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9774116 elementor-widget elementor-widget-heading\" data-id=\"9774116\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel SQL-Editor<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-6198911\" data-id=\"6198911\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1962acb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1962acb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6b07157\" data-id=\"6b07157\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-59b17a5 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"59b17a5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>SELECT &#039;A&#039; AS &quot;SPALTE_A&quot;,\n       &#039;B&#039; AS &quot;SPALTE_B&quot;, \n       1.5 AS &quot;BETRAG&quot; \n     FROM DUMMY; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3395d23 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3395d23\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-169d623\" data-id=\"169d623\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c2e9b7c elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"c2e9b7c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c053536 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c053536\" data-element_type=\"section\" data-e-type=\"section\" id=\"tmptabellen\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6c2d79a\" data-id=\"6c2d79a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-36cca33 elementor-widget elementor-widget-heading\" data-id=\"36cca33\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Tempor\u00e4re Tabellen (Tabellenvariablen)<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-82e0205 elementor-widget elementor-widget-text-editor\" data-id=\"82e0205\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Tabellen werden dynamisch zur Laufzeit definiert, wenn sie mit einem Select gef\u00fcllt werden.<\/p><h3>Anmerkung<\/h3><p>Tabellenvariablen m\u00fcssen nicht vor der Benutzung deklariert werden. In der weiteren Verwendung muss dem Namen aber ein &#8222;:&#8220; vorangestellt werden.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-ae34fa6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ae34fa6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-3666272\" data-id=\"3666272\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c11d671 elementor-widget elementor-widget-heading\" data-id=\"c11d671\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-70eb8d3\" data-id=\"70eb8d3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0297805 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0297805\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7427372\" data-id=\"7427372\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d9cbf4b elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"d9cbf4b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>tmptab  = SELECT * FROM :intab;\ntmptab2 = SELECT * FROM :tmptab;\nouttab  = SELECT * from :tmptab2;\n <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-50eb3b1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"50eb3b1\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fb24c5a\" data-id=\"fb24c5a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bbaf224 elementor-widget elementor-widget-text-editor\" data-id=\"bbaf224\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Tabellenvariablen sind ein Beispiel daf\u00fcr, wo sich SQL von SQLscript unterscheidet. Diese Variablen sind Teil der SQLscript-Sprache, aber nicht der SQL-Sprache.<\/p><p>Um sie daher in einem SQL-Fenster verwendet zu k\u00f6nnen, muss ein sogenannten anonymer Block eingef\u00fcgt werden.\u00a0<\/p><p>Das letzte SELECT in folgendem Beispiel erzeugt dann die Ausgabe des Resultats des SQL-Fensters. Ohne diese Zeile wird das Statement zwar ausgef\u00fchrt, es gibt aber kein Ergebnis. Mehrere solcher SELECTs am Ende erzeugen auch mehrere Resultats-Fenster im SQL-Editor des HANA Studios.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-b24eb0d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b24eb0d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-70e806f\" data-id=\"70e806f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-eaa6e25 elementor-widget elementor-widget-heading\" data-id=\"eaa6e25\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel SQL-Fenster<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-5af13f8\" data-id=\"5af13f8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-afc7c53 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"afc7c53\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-060b577\" data-id=\"060b577\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ad8d7e0 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"ad8d7e0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>DO\r\nBEGIN\r\ntmptab = SELECT &#039;A&#039; AS &quot;SPALTE_A&quot;, \r\n                &#039;B&#039; AS &quot;SPALTE_B&quot;, \r\n                1.5 AS &quot;BETRAG&quot; \r\n            FROM DUMMY;\r\ntmptab2 = SELECT &quot;SPALTE_A&quot; FROM :tmptab;\r\nSELECT * FROM :tmptab2; -- Tabelle als Resultat ausgeben\r\nEND; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2eaa95f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2eaa95f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-42e73a6\" data-id=\"42e73a6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c5330f5 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"c5330f5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-54393be elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"54393be\" data-element_type=\"section\" data-e-type=\"section\" id=\"rename\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-841ecea\" data-id=\"841ecea\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0b259db elementor-widget elementor-widget-heading\" data-id=\"0b259db\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Umbenennen von Spalten<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e779fb1 elementor-widget elementor-widget-text-editor\" data-id=\"e779fb1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Eine oder mehrere Spalten soll einen anderen Namen erhalten.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-342623b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"342623b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-10b3a0d\" data-id=\"10b3a0d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-03e8a24 elementor-widget elementor-widget-heading\" data-id=\"03e8a24\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-f8da53d\" data-id=\"f8da53d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fb2d830 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fb2d830\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ca159fb\" data-id=\"ca159fb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-269dc02 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"269dc02\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>outtab = \n  SELECT &quot;ALTER_SPALTENNAME&quot; AS &quot;NEUER_SPALTENNAME&quot; FROM :inTab; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-620ff79 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"620ff79\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-2bf7ba4\" data-id=\"2bf7ba4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c2178d1 elementor-widget elementor-widget-heading\" data-id=\"c2178d1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel SQL-Fenster<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-f9d3222\" data-id=\"f9d3222\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-12eb501 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"12eb501\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bf07a17\" data-id=\"bf07a17\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-327601a elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"327601a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>DO\r\nBEGIN\r\ntab1 = SELECT &#039;A&#039; AS &quot;SPALTE_A&quot;, \r\n              &#039;B&#039; AS &quot;SPALTE_B&quot;, \r\n              1.5 AS &quot;BETRAG&quot; \r\n             FROM DUMMY;\r\nSELECT * FROM :tab1; -- Resultat Tabelle mit SPALTE_A\r\nSELECT &quot;SPALTE_A&quot; AS &quot;NEUE_SPALTE&quot; FROM :tab1; -- Resultat umbenannt\r\nEND; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-eefeb53 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"eefeb53\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e158754\" data-id=\"e158754\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f4056ff elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"f4056ff\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e984c57 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e984c57\" data-element_type=\"section\" data-e-type=\"section\" id=\"unionall\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-88c77aa\" data-id=\"88c77aa\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1bdd92f elementor-widget elementor-widget-heading\" data-id=\"1bdd92f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Vereinigung zweier strukturgleicher Tabellen<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f90a6cd elementor-widget elementor-widget-text-editor\" data-id=\"f90a6cd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Es wird die Vereinigungsmenge zweier Tabellen gebildet. Die Tabellen m\u00fcssen dabei von identischer Struktur sein.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-5387cf6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5387cf6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-33cdbb3\" data-id=\"33cdbb3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-31a260a elementor-widget elementor-widget-heading\" data-id=\"31a260a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-8186950\" data-id=\"8186950\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-27c718d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"27c718d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1e57350\" data-id=\"1e57350\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fca2b31 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"fca2b31\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>outtab = \n  SELECT columns FROM :TAB1\n  \n  UNION ALL\n  \n  SELECT columns FROM :TAB2; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-00e9cd8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"00e9cd8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-7af790a\" data-id=\"7af790a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1f0ecec elementor-widget elementor-widget-heading\" data-id=\"1f0ecec\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel SQL-Fenster<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-e150c70\" data-id=\"e150c70\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-64beda0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"64beda0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a65a983\" data-id=\"a65a983\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b6c806e elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"b6c806e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>DO\r\nBEGIN\r\ntab1 = SELECT &#039;A&#039; AS &quot;SPALTE_A&quot;, \r\n              &#039;B&#039; AS &quot;SPALTE_B&quot;, \r\n              1.5 AS &quot;BETRAG&quot; \r\n             FROM DUMMY;\r\ntab2 = SELECT * FROM :tab1; -- 2. Tabelle mit Daten\r\ntab3 = SELECT * FROM :tab1 \r\n       UNION ALL \r\n       SELECT * FROM :tab2;\r\nSELECT * FROM :tab3; -- Resultat ausgeben\r\nEND; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-452ac0b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"452ac0b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-13d490c\" data-id=\"13d490c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3e1c54d elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"3e1c54d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-54e6b66 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"54e6b66\" data-element_type=\"section\" data-e-type=\"section\" id=\"join\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a06a062\" data-id=\"a06a062\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a5e124a elementor-widget elementor-widget-heading\" data-id=\"a5e124a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Join zweier Tabellen<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-70f1f92 elementor-widget elementor-widget-text-editor\" data-id=\"70f1f92\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Es wird der Join zweier Tabellen gebildet.\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-bd30be8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bd30be8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-b8f6f0e\" data-id=\"b8f6f0e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b950d77 elementor-widget elementor-widget-heading\" data-id=\"b950d77\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-2d7c2c5\" data-id=\"2d7c2c5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dc1d662 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dc1d662\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fa58542\" data-id=\"fa58542\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c81bc1d elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"c81bc1d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>outtab = \n  SELECT T1.*, T2.* FROM :TAB1 AS T1\n    LEFT OUTER JOIN :TAB2 AS T2\n    ON T1.SPALTE_A = T2.SPALTE_X AND\n       T1.SPALTE_B = T2.SPALTE_Y;\n   <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-8d0ca67 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8d0ca67\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-3697cc1\" data-id=\"3697cc1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-011b337 elementor-widget elementor-widget-heading\" data-id=\"011b337\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel SQL-Fenster<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-d56d71c\" data-id=\"d56d71c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fab5f8a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fab5f8a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2e66bc5\" data-id=\"2e66bc5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ba42bed elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"ba42bed\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>DO\r\nBEGIN\r\ntab1 = SELECT &#039;A&#039; AS &quot;SPALTE_A&quot;, \r\n              &#039;B&#039; AS &quot;SPALTE_B&quot;, \r\n              1.5 AS &quot;BETRAG&quot; \r\n             FROM DUMMY;\r\ntab2 = SELECT &#039;A&#039; AS &quot;SPALTE_X&quot;, \r\n              &#039;C&#039; AS &quot;SPALTE_Y&quot;, \r\n              2 AS &quot;MENGE&quot; \r\n             FROM DUMMY;\r\ntab3 = SELECT T1.*, T2.* from :tab1 AS T1\r\n         LEFT OUTER JOIN :tab2 AS T2\r\n         ON T1.&quot;SPALTE_A&quot; = T2.&quot;SPALTE_X&quot;;\r\nSELECT * FROM :tab3; -- Resultat ausgeben\r\nEND; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7284381 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7284381\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6559208\" data-id=\"6559208\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-eedb3df elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"eedb3df\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-46009ce elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"46009ce\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7134347\" data-id=\"7134347\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dc08486 elementor-widget elementor-widget-heading\" data-id=\"dc08486\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Fallunterscheidung <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f22e9c3 elementor-widget elementor-widget-text-editor\" data-id=\"f22e9c3\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"case\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Sie k\u00f6nnen bereits im SELECT-Statement in der zu ermittelnden Spalte eine Fallunterscheidung machen mit Hilfe von CASE.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-c9f6ff4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c9f6ff4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-3bf13cd\" data-id=\"3bf13cd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-036cb3e elementor-widget elementor-widget-heading\" data-id=\"036cb3e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-28857e2\" data-id=\"28857e2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b1b68fd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b1b68fd\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-563d099\" data-id=\"563d099\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9dc13af elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"9dc13af\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>outtab = \r\nSELECT\r\nCASE BUCHUNGSART\r\n  WHEN &#039;HABEN&#039; THEN BETRAG\r\n  WHEN &#039;SOLL&#039;  THEN -1 * BETRAG\r\n  ELSE 0 \r\nEND AS BETRAG_VZ\r\nFROM :intab; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f82e071 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f82e071\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f2fdb18\" data-id=\"f2fdb18\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-638eac0 elementor-widget elementor-widget-text-editor\" data-id=\"638eac0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Dieses Statement ist gleichwertig zu folgender Version:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-793278e elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"793278e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>outtab = \r\nSELECT\r\nCASE \r\n  WHEN BUCHUNGSART = &#039;HABEN&#039; THEN BETRAG\r\n  WHEN BUCHUNGSART = &#039;SOLL&#039;  THEN -1 * BETRAG\r\n  ELSE 0 \r\nEND AS BETRAG_VZ\r\nFROM :intab; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-74aecb8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"74aecb8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f4bd93c\" data-id=\"f4bd93c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-17d8632 elementor-widget elementor-widget-text-editor\" data-id=\"17d8632\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In der 2. Formulierung hat man mehr Freiheit, in der WHEN-Bedingung auch komplexere Bedingungen zu formulieren, z.B.:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3c14d9b elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"3c14d9b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>outtab = \r\nSELECT\r\nCASE \r\n  WHEN BUCHUNGSART = &#039;HABEN&#039; AND \r\n       NOT ( STORNOFLAG = &#039;X&#039; )\r\n       THEN BETRAG\r\n  WHEN BUCHUNGSART = &#039;HABEN&#039; AND \r\n       STORNOFLAG = &#039;X&#039;\r\n       THEN 0\r\n  WHEN BUCHUNGSART = &#039;SOLL&#039;  THEN -1 * BETRAG\r\n  ELSE 0 \r\nEND AS BETRAG_VZ\r\nFROM :intab; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-1b4c42a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1b4c42a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-4723b23\" data-id=\"4723b23\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a0d605f elementor-widget elementor-widget-heading\" data-id=\"a0d605f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel SQL-Fenster<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-569b016\" data-id=\"569b016\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b5ca499 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b5ca499\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-56f20e1\" data-id=\"56f20e1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-623f4b7 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"623f4b7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>DO\r\nBEGIN\r\ntab1 = SELECT &#039;HABEN&#039; AS &quot;BUCHUNGSART&quot;, 1.5 AS &quot;BETRAG&quot; FROM DUMMY\r\n       UNION ALL\r\n       SELECT &#039;SOLL&#039;  AS &quot;BUCHUNGSART&quot;, 2.5 AS &quot;BETRAG&quot; FROM DUMMY;\r\ntab2 = SELECT &quot;BUCHUNGSART&quot;, &quot;BETRAG&quot;,\r\n       CASE \r\n         WHEN &quot;BUCHUNGSART&quot; = &#039;HABEN&#039; THEN &quot;BETRAG&quot;\r\n         WHEN &quot;BUCHUNGSART&quot; = &#039;SOLL&#039;  THEN -1 * &quot;BETRAG&quot;\r\n         ELSE 0\r\n       END AS &quot;BETRAG_VZ&quot;\r\n      FROM :tab1;\r\nSELECT * FROM :tab2; -- Resultat ausgeben\r\nEND; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-284d679 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"284d679\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-523c042 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"523c042\" data-element_type=\"section\" data-e-type=\"section\" id=\"defvar\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8f6be03\" data-id=\"8f6be03\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a66deef elementor-widget elementor-widget-heading\" data-id=\"a66deef\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Variable definieren, bef\u00fcllen und benutzen<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d772e06 elementor-widget elementor-widget-text-editor\" data-id=\"d772e06\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Sie k\u00f6nnen lokale Variablen definieren. Diese lassen sich einerseits mit SELECT-Statements bef\u00fcllen, andererseits kann ihr Inhalt auch wieder per SELECT ausgelesen werden oder sie k\u00f6nnen in CASE-Anweisungen verwendet werden.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-aea5dfb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aea5dfb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-cf34bc3\" data-id=\"cf34bc3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8c9b95d elementor-widget elementor-widget-heading\" data-id=\"8c9b95d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-2f20f0d\" data-id=\"2f20f0d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ab715c5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ab715c5\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fecf3ab\" data-id=\"fecf3ab\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3214a6c elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"3214a6c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>DECLARE lv_tvarvc STRING;\n\nSELECT DISTINCT LOW INTO lv_tvarvc\n  FROM &quot;TVARVC&quot; \n  WHERE &quot;NAME&quot; = &#039;my_setting&#039;;\n  \nouttab = \n  SELECT :lv_tvarvc AS TVARVC, * FROM intab; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-9248ea5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9248ea5\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-6c65e87\" data-id=\"6c65e87\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-49242d6 elementor-widget elementor-widget-heading\" data-id=\"49242d6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel SQL-Fenster<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-3188782\" data-id=\"3188782\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-594851a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"594851a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b68fff7\" data-id=\"b68fff7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-11b683f elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"11b683f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>DO\r\nBEGIN\r\nDECLARE lv_tvarvc STRING;\r\ntab1 = SELECT &#039;A&#039; AS &quot;SPALTE_A&quot;, \r\n              &#039;B&#039; AS &quot;SPALTE_B&quot;, \r\n              1.5 AS &quot;BETRAG&quot; \r\n             FROM DUMMY;\r\nSELECT &#039;Value1&#039; INTO lv_tvarvc FROM DUMMY;\r\nSELECT :lv_tvarvc, * FROM :tab1; -- Resultat ausgeben\r\nEND; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fc13c5f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fc13c5f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c199153\" data-id=\"c199153\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fd240b8 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"fd240b8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0ce5d28 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0ce5d28\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-51b10d1\" data-id=\"51b10d1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b9b1a1c elementor-widget elementor-widget-heading\" data-id=\"b9b1a1c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">NULL-Werte vermeiden<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be8ce6a elementor-widget elementor-widget-text-editor\" data-id=\"be8ce6a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Werden z.B. in einem Left-Outer-Join in der verjointen Tabelle keine passenden Treffer gefunden, so enthalten die selektierten Spalten dieser Tabelle als Ergebnisse NULL-Werte. Diese Werte sind recht unangenehm, z.B. weil sie im ABAP auch keinem Initialwert entsprechen. Daher sollten solche NULL-Werte immer mit der Funktion COALESCE abgefangen werden. COALESCE(A,B) gibt den Wert A zur\u00fcck, wenn A nicht NULL ist, ansonsten B. Somit kann man mit B immer einen Ersatzwert angeben, der anstelle von NULL zur\u00fcckgegeben werden soll.<\/p><p>Alternativ kann man auch mit der Funktion IFNULL arbeiten.<\/p><h3>Anmerkung<\/h3><p>Ein Codingbeispiel findet sich im Abschnitt <a href=\"#datumsrechnung\">Datumsrechnung<\/a>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d9e5ad8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d9e5ad8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e8c8b09\" data-id=\"e8c8b09\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3aa4ac1 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"3aa4ac1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1e2be9b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1e2be9b\" data-element_type=\"section\" data-e-type=\"section\" id=\"anzzeilen\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-588da26\" data-id=\"588da26\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-32b5b6e elementor-widget elementor-widget-heading\" data-id=\"32b5b6e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Anzahl Zeilen z\u00e4hlen<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e13236 elementor-widget elementor-widget-text-editor\" data-id=\"6e13236\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Sie k\u00f6nnen mit Hilfe des COUNT-Operators die Zeilen z\u00e4hlen lassen. Sie k\u00f6nnen aber auch ermitteln, wie oft Merkmale jeweils vorkommen, ob z.B. nur einmal oder auch mehrfach.<\/p><p>Hier geben wir nur ein Beispiel f\u00fcr die SQL-Konsole an, die Syntax ist dann leicht auf Anwendungsf\u00e4lle im AMDP \u00fcbertragbar.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-7b8ba05 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7b8ba05\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-a9617b0\" data-id=\"a9617b0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3a30c1d elementor-widget elementor-widget-heading\" data-id=\"3a30c1d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel SQL-Fenster<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-e3be70e\" data-id=\"e3be70e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e6dbafa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e6dbafa\" data-element_type=\"section\" data-e-type=\"section\" id=\"null\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a7e0372\" data-id=\"a7e0372\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9d8d57b elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"9d8d57b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>DO\r\nBEGIN\r\nDECLARE lv_anz_zeilen INT;\r\ntab1 = SELECT &#039;A&#039; AS &quot;SPALTE_A&quot;, \r\n              &#039;B&#039; AS &quot;SPALTE_B&quot;, \r\n              1.5 AS &quot;BETRAG&quot; \r\n             FROM DUMMY\r\n       UNION\r\n       SELECT &#039;A&#039; AS &quot;SPALTE_A&quot;, \r\n              &#039;C&#039; AS &quot;SPALTE_B&quot;, \r\n              2.5 AS &quot;BETRAG&quot;\r\n            FROM DUMMY;\r\n               \r\nSELECT COUNT( * ) INTO lv_anz_zeilen FROM :tab1; -- Gesamtzahl als\r\n                                                 -- lokale Variable\r\n\r\ntab2 = SELECT COUNT ( * ) AS &quot;COUNTER&quot; FROM :tab1; -- Gesamtzahl als Tabelle\r\n\r\nSELECT :lv_anz_zeilen AS &quot;Gesamtzahl&quot;, \r\n       COUNT(*) AS &quot;Anzahl pro Merkmal SPALTE_A&quot;, \r\n       &quot;SPALTE_A&quot; FROM :tab1\r\n  GROUP BY &quot;SPALTE_A&quot;;  -- Ausgabe 1, auch wieviele Auspr&auml;gungen SPALTE_A\r\n  \r\nSELECT * from :tab2;  -- Ausgabe 2\r\n              \r\nEND; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7e220da elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7e220da\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-398b9f3\" data-id=\"398b9f3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8176b58 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"8176b58\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2e0886f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2e0886f\" data-element_type=\"section\" data-e-type=\"section\" id=\"bedingung\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-af816c6\" data-id=\"af816c6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-61bc67c elementor-widget elementor-widget-heading\" data-id=\"61bc67c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Bedingungen<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a3f2f21 elementor-widget elementor-widget-text-editor\" data-id=\"a3f2f21\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Mit Hilfe von IF k\u00f6nnen Bedingungen formuliert werden.\u00a0<\/p><h3>Anmerkung<\/h3><p>\u00dcberraschend h\u00e4ufig lassen sich IF-Statements durch CASE-Anweisungen im SELECT ersetzen. Diese passen besser dazu, die Daten immer massenweise zu prozessieren. Durch IF werden gerne wieder Einzelf\u00e4lle betrachtet, was man vermeiden sollte, um gute Performanz zu erhalten.\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-c7a9245 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c7a9245\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-356c0ea\" data-id=\"356c0ea\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7733dd0 elementor-widget elementor-widget-heading\" data-id=\"7733dd0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-99b6cbb\" data-id=\"99b6cbb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-503574c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"503574c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bcbda24\" data-id=\"bcbda24\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7468b6e elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"7468b6e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>DO\r\nBEGIN\r\nDECLARE lv_anz_zeilen INT;\r\ntab1 = SELECT &#039;A&#039; AS &quot;SPALTE_A&quot;, \r\n              &#039;B&#039; AS &quot;SPALTE_B&quot;, \r\n              1.5 AS &quot;BETRAG&quot; \r\n             FROM DUMMY\r\n       UNION\r\n       SELECT &#039;A&#039; AS &quot;SPALTE_A&quot;, \r\n              &#039;C&#039; AS &quot;SPALTE_B&quot;, \r\n              2.5 AS &quot;BETRAG&quot;\r\n            FROM DUMMY;\r\n               \r\nSELECT COUNT( * ) INTO lv_anz_zeilen FROM :tab1; -- Gesamtzahl\r\n\r\nIF :lv_anz_zeilen &amp;gt; 0 THEN\r\n\r\n  SELECT &#039;Tabelle ist nicht leer&#039; AS &quot;TEXT&quot; from DUMMY;\r\n\r\nELSE\r\n\r\n  SELECT &#039;Tabelle ist leer&#039; AS &quot;TEXT&quot; from DUMMY;\r\n              \r\nEND IF;\r\n\r\nEND; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5bac4a6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5bac4a6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a81a349\" data-id=\"a81a349\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-920286c elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"920286c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ef3ac05 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ef3ac05\" data-element_type=\"section\" data-e-type=\"section\" id=\"sum\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1b65e3a\" data-id=\"1b65e3a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-afa1d4b elementor-widget elementor-widget-heading\" data-id=\"afa1d4b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Summe, Max, Min, ...<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7d8e530 elementor-widget elementor-widget-text-editor\" data-id=\"7d8e530\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Aggregationen wie Summenbildung, Maximum einer Spalte o.\u00e4. k\u00f6nnen wieder direkt im SELECT-Statement gebildet werden.\u00a0<\/p><h3>Anmerkung<\/h3><p>Die Spalten, \u00fcber die hinweg die Aggregatsfunktion gebildet wird, m\u00fcssen in einer GROUP-BY-Klausel stehen. I.a. sind das also alle Spalten ausser denen, auf denen die Summe, das Maximun o.\u00e4. gebildet werden soll.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-a78225c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a78225c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-020523b\" data-id=\"020523b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-74cb0ba elementor-widget elementor-widget-heading\" data-id=\"74cb0ba\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-cd8d4f7\" data-id=\"cd8d4f7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-00ff20a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"00ff20a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-44ff86f\" data-id=\"44ff86f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-99536bb elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"99536bb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>DO\r\nBEGIN\r\n\r\ntab1 = SELECT &#039;A&#039; AS &quot;SPALTE_A&quot;, \r\n              &#039;B&#039; AS &quot;SPALTE_B&quot;, \r\n              1.5 AS &quot;BETRAG&quot; \r\n             FROM DUMMY\r\n       UNION\r\n       SELECT &#039;A&#039; AS &quot;SPALTE_A&quot;, \r\n              &#039;C&#039; AS &quot;SPALTE_B&quot;, \r\n              2.5 AS &quot;BETRAG&quot;\r\n            FROM DUMMY;\r\n               \r\n               \r\nSELECT &quot;SPALTE_A&quot;, MAX( &quot;BETRAG&quot; ) AS MAX FROM :tab1\r\n  GROUP BY &quot;SPALTE_A&quot;; -- Max pro Auspr&auml;gung SPALTE_A\r\n\r\nSELECT &quot;SPALTE_B&quot;, MAX( &quot;BETRAG&quot; ) AS MAX FROM :tab1\r\n  GROUP BY &quot;SPALTE_B&quot;; -- Max pro Auspr&auml;gung SPALTE_B\r\n\r\nEND; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-136f54b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"136f54b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bcb5bfb\" data-id=\"bcb5bfb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bc0be22 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"bc0be22\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-46b6032 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"46b6032\" data-element_type=\"section\" data-e-type=\"section\" id=\"ltrim\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5bb2fbd\" data-id=\"5bb2fbd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2311807 elementor-widget elementor-widget-heading\" data-id=\"2311807\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">F\u00fchrende 0en ersetzen<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9b4c696 elementor-widget elementor-widget-text-editor\" data-id=\"9b4c696\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Mit Hilfe des LTRIM-Operators k\u00f6nnen f\u00fchrende 0en ersetzt werden.\u00a0<\/p><h3>Anmerkung<\/h3><p>Der LTRIM-Operator kann auch eingesetzt werden, um z.B. f\u00fchrende Leerzeichen zu eliminieren.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-f255afa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f255afa\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-ccca474\" data-id=\"ccca474\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-71fe0c9 elementor-widget elementor-widget-heading\" data-id=\"71fe0c9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-a2444e3\" data-id=\"a2444e3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5ade13f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5ade13f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3dd23b8\" data-id=\"3dd23b8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a830819 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"a830819\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>SELECT LTRIM( BPARTNER, &#039;0&#039;) AS BP FROM :intab; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-6fd4650 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6fd4650\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-f461189\" data-id=\"f461189\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7fae6dc elementor-widget elementor-widget-heading\" data-id=\"7fae6dc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel SQL-Fenster<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-9799603\" data-id=\"9799603\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d4e08e6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d4e08e6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cd94e63\" data-id=\"cd94e63\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a1c3057 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"a1c3057\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>SELECT LTRIM( &#039;00001234&#039;, &#039;0&#039;) AS BP FROM DUMMY; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1756c5e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1756c5e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ce6019c\" data-id=\"ce6019c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6f27996 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"6f27996\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6686d85 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6686d85\" data-element_type=\"section\" data-e-type=\"section\" id=\"numcheck\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-140e978\" data-id=\"140e978\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cee07f7 elementor-widget elementor-widget-heading\" data-id=\"cee07f7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Pr\u00fcfung auf Ziffern<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-68c0126 elementor-widget elementor-widget-text-editor\" data-id=\"68c0126\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Sie k\u00f6nnen Spalten daraufhin pr\u00fcfen, ob nur Ziffern in ihnen vorkommen (z.B. Datumsfelder im internen ABAP-Format).\u00a0<\/p><h3>Anmerkung<\/h3><p>Im Beispiel werden die Datens\u00e4tze selektiert und markiert, die etwas enthalten, das keine Ziffer ist.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-691fe85 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"691fe85\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-38027a7\" data-id=\"38027a7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1d66809 elementor-widget elementor-widget-heading\" data-id=\"1d66809\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-8f75555\" data-id=\"8f75555\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f494784 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f494784\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a1971d8\" data-id=\"a1971d8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b5b5b5c elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"b5b5b5c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>SELECT DATUM, &#039;X&#039; AS MARKIERUNG FROM :intab\n  WHERE DATUM LIKE_REGEXPR &#039;[^0-9]&#039;; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-abda5a2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"abda5a2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6d74403\" data-id=\"6d74403\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f938147 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"f938147\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a974e17 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a974e17\" data-element_type=\"section\" data-e-type=\"section\" id=\"dense\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-402531a\" data-id=\"402531a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ab77fa8 elementor-widget elementor-widget-heading\" data-id=\"ab77fa8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Verdichten von Leerzeichen<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-57a6ed6 elementor-widget elementor-widget-text-editor\" data-id=\"57a6ed6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Sie k\u00f6nnen f\u00fchrende, schliessende, aber auch mittige Leerzeichen entfernen lassen durch Verwendung des sehr m\u00e4chtigen Operators REPLACE_REGEX.\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-3c0d77b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3c0d77b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-6346a1f\" data-id=\"6346a1f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7848d64 elementor-widget elementor-widget-heading\" data-id=\"7848d64\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-12ee3c1\" data-id=\"12ee3c1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2521382 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2521382\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b47e401\" data-id=\"b47e401\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-12bae30 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"12bae30\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>SELECT REPLACE_REGEXPR (&#039;[\\s]&#039; in &#039;ABC DEF&#039;) FROM DUMMY; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7c379a1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7c379a1\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2c8ce3d\" data-id=\"2c8ce3d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d48fdd0 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"d48fdd0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1fc8bc8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1fc8bc8\" data-element_type=\"section\" data-e-type=\"section\" id=\"invalid\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-08cf0ab\" data-id=\"08cf0ab\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3bb13c5 elementor-widget elementor-widget-heading\" data-id=\"3bb13c5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Entfernen ung\u00fcltiger Zeichen<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-560b2ec elementor-widget elementor-widget-text-editor\" data-id=\"560b2ec\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Sie k\u00f6nnen f\u00fcr das BW ung\u00fcltige Zeichen entfernen lassen durch Verwendung des sehr m\u00e4chtigen Operators REPLACE_REGEX in Kombination mit einem Ausdruck, der alle nicht druckbaren Zeichen aus einem Text entfernt.\u00a0<\/p><p>Die erste Coding-Variante entfernt alle nicht-druckbaren Zeichen, zu denen leider aber auch z.B. die deutschen Umlaute z\u00e4hlen. Falls das nicht gew\u00fcnscht ist, entfernt die zweite Variante nur gewisse unsichtbare Steuerzeichen plus das Zeichen f\u00fcr gesch\u00fctztes Leerzeichen (Hex A0).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-f127173 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f127173\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-b1bdec2\" data-id=\"b1bdec2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-10e14ea elementor-widget elementor-widget-heading\" data-id=\"10e14ea\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-7a8441b\" data-id=\"7a8441b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fbc34c2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fbc34c2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4286ec6\" data-id=\"4286ec6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-251f453 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"251f453\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>SELECT REPLACE_REGEXPR( &#039;([^[:print:]])&#039; IN &#039;TEXT&#039; WITH &#039;&#039; OCCURRENCE ALL ) FROM DUMMY;\n\nSELECT REPLACE_REGEXPR( &#039;([[:cntrl:]\\x{00A0}])&#039; IN &#039;TEXT&#039; WITH &#039;&#039; OCCURRENCE ALL ) FROM DUMMY; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4fc940f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4fc940f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e79a053\" data-id=\"e79a053\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b63b103 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"b63b103\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dfa2a4c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dfa2a4c\" data-element_type=\"section\" data-e-type=\"section\" id=\"first\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0f8f4bd\" data-id=\"0f8f4bd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-98ad6e9 elementor-widget elementor-widget-heading\" data-id=\"98ad6e9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Ersten Datensatz ermitteln<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-44a8299 elementor-widget elementor-widget-text-editor\" data-id=\"44a8299\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Mit Hilfe von MAX- oder MIN-Funktionen lassen sich neueste oder \u00e4lteste Dat\u00fcmer ermitteln. Man kann aber auch den ersten Datensatz einer bestimmten Reihe ermitteln, z.B. den BusinessPartner mit fr\u00fchestem \u00c4nderungsdatum.<\/p><h3>Anmerkung<\/h3><p>Analog kann man nat\u00fcrlich auch den letzten Datensatz ermitteln mit LAST_VALUE.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-c684f65 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c684f65\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-7b2344b\" data-id=\"7b2344b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2a877f2 elementor-widget elementor-widget-heading\" data-id=\"2a877f2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-54723e0\" data-id=\"54723e0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d62c43d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d62c43d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-956ca77\" data-id=\"956ca77\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-395abef elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"395abef\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>SELECT FIRST_VALUE( BPARTNER ORDER BY CHANGED_ON ) FROM :intab;\n\nSELECT BPARTNER, LAST_VALUE ( AMOUNT ORDER BY CHANGED_ON ) AS AMOUNT FROM :intab \n  GROUP BY BPARTNER; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1ee77ae elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1ee77ae\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d727d7c\" data-id=\"d727d7c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8176f29 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"8176f29\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c1bac56 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c1bac56\" data-element_type=\"section\" data-e-type=\"section\" id=\"rang\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9b28968\" data-id=\"9b28968\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-454fc23 elementor-widget elementor-widget-heading\" data-id=\"454fc23\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Rang ermitteln<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-50a3595 elementor-widget elementor-widget-text-editor\" data-id=\"50a3595\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Sie k\u00f6nnen mit Hilfe der RANK-Funktion Daten eine Rangnummer zuweisen. Dies ist eine Art Sortiernummer, hat aber den Vorteil, dass die Daten dazu nicht sortiert oder umsortiert werden m\u00fcssen.<\/p><h3>Anmerkung<\/h3><p>Das kann man z.B. dazu verwenden, um die letzte Position zu einem Beleg zu ermitteln.\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-1397a70 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1397a70\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-38047fc\" data-id=\"38047fc\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-002b0a5 elementor-widget elementor-widget-heading\" data-id=\"002b0a5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-4c0280e\" data-id=\"4c0280e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-435f6a9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"435f6a9\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-573c0cf\" data-id=\"573c0cf\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-21e5686 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"21e5686\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>tab1 = SELECT *, \n         RANK() OVER ( PARTITION BY intab.&quot;BELEGNUMMER&quot; ORDER BY intab.&quot;POSITION&quot; DESC ) \n         AS ZEILENNUMMER_ABSTEIGEND \n         FROM :intab;\n         \ntab2 = select * from :tab1\n         where ZEILENNUMMER_ABSTEIGEND = 1; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-00abb8d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"00abb8d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e39e0df\" data-id=\"e39e0df\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-501b0b6 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"501b0b6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a62a405 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a62a405\" data-element_type=\"section\" data-e-type=\"section\" id=\"leadlag\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4a50d05\" data-id=\"4a50d05\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2bf74b8 elementor-widget elementor-widget-heading\" data-id=\"2bf74b8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Zugriff auf vorherige oder nachfolgende Zeilen<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3c87a08 elementor-widget elementor-widget-text-editor\" data-id=\"3c87a08\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Wenn Sie jeweils Zeilen einer Tabelle mit der vorherigen oder nachfolgenden Zeile vergleichen wollen, f\u00fchrt das gerne dazu, dass man einen Cursor \u00f6ffnet und eine Schleife programmiert. Das ist prinzipiell m\u00f6glich, aber es widerspricht dem Paradigma, die Daten m\u00f6glichst massenhaft zu prozessieren, um optimale Performanz zu erhalten.\u00a0<\/p><p>Eine M\u00f6glichkeit w\u00e4re, die Tabelle mit sich selbst um eine Zeile versetzt zu verjoinen, damit w\u00e4re ein Vergleich innerhalb einer (dann doppelt so breiten) Zeile m\u00f6glich.<\/p><p>HANA SQLscript bietet aber mit den LEAD- und LAG-Funktionen eine M\u00f6glichkeit, auf die entsprechenden Zeilen zuzugreifen.<\/p><h3>Anmerkung<\/h3><p>Das Beispiel listet die Mandanten eines Systems. In der ersten Spalte die normale Auflistung, in der zweiten wird mit Lead auf die n\u00e4chste Zeile der Tabelle vorgegriffen, mit Lag auf die vorherige zur\u00fcckgegriffen.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-8f2cb46 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8f2cb46\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-e52256a\" data-id=\"e52256a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1595c4f elementor-widget elementor-widget-heading\" data-id=\"1595c4f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-b43d3e8\" data-id=\"b43d3e8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d223b0e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d223b0e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2772d6f\" data-id=\"2772d6f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-73be5b0 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"73be5b0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>select MANDT, \r\n       LEAD( MANDT ) OVER ( ORDER BY MANDT ) AS LEAD, \r\n       LAG( MANDT )  OVER ( ORDER BY MANDT ) AS LAG \r\n  FROM T000;\r\n  <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-4f07bbe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4f07bbe\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-cd3a053\" data-id=\"cd3a053\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-187a213 elementor-widget elementor-widget-heading\" data-id=\"187a213\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Ergebnis<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-f75036d elementor-widget elementor-widget-image\" data-id=\"f75036d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"223\" height=\"124\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/03\/mandt.gif\" class=\"attachment-large size-large wp-image-12885\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-577fff0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"577fff0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-85e8f80\" data-id=\"85e8f80\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1df2679 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"1df2679\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a9180a7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a9180a7\" data-element_type=\"section\" data-e-type=\"section\" id=\"datumsrechnung\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6a870f1\" data-id=\"6a870f1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5c5d8f3 elementor-widget elementor-widget-heading\" data-id=\"5c5d8f3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Datumsrechnung<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bb7e644 elementor-widget elementor-widget-text-editor\" data-id=\"bb7e644\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Aus Kalendertag sollen die anderen Merkmale (Woche, Monat, Jahr,&#8230;) hergeleitet werden.<\/p><h3>Anmerkung<\/h3><p>In der HANA m\u00fcssen einmalig die Zeittabellen gef\u00fcllt werden (\u2192 Modeler Perspektive), sonst sind die Tabellen leer.\u00a0<br \/>Alternativ k\u00f6nnen die Tabellen auch mit MDX-Kommandos wie<br \/>MDX UPDATE TIME DIMENSION &#8230; oder MDX UPDATE FISCAL CALENDAR &#8230;<br \/>bef\u00fcllt werden. Dabei darauf achten, was die feinste Granularit\u00e4t sein soll (z.B. Tag oder Sekunde).<br \/>Wird nichts gefunden, wird auf den 01.01.2020 zur\u00fcckgefallen (das war ein Mittwoch, Weekday = 3, daher dieser Wert).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-dd2e04a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dd2e04a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-cdc7e95\" data-id=\"cdc7e95\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7f61b2d elementor-widget elementor-widget-heading\" data-id=\"7f61b2d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-8031286\" data-id=\"8031286\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-00989c7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"00989c7\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ab79abb\" data-id=\"ab79abb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c851eec elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"c851eec\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>-- UDATE bitte durch das entsprechende Zeitmerkmal ersetzen\r\n\r\nSELECT\r\n\r\n  COALESCE( I.UDATE, &#039;20200101&#039; ) AS CALDAY,\r\n\r\n  COALESCE( TO_NVARCHAR( T.DAY_OF_WEEK_INT + 1 ), &#039;3&#039; ) AS WEEKDAY1,\r\n\r\n  COALESCE( T.CALMONTH, &#039;01&#039; ) AS CALMONTH,\r\n\r\n  COALESCE( T.CALWEEK, &#039;202001&#039; ) AS CALWEEK,\r\n\r\n  COALESCE( T.MONTH, &#039;01&#039; ) AS CALMONTH2,\r\n\r\n  COALESCE( T.CALQUARTER, &#039;20201&#039; ) AS CALQUARTER,\r\n\r\n  COALESCE( TO_NVARCHAR( T.QUARTER_INT ), &#039;1&#039; ) AS CALQUART1,\r\n\r\n  CASE \r\n    WHEN COALESCE( T.QUARTER_INT, 1 ) = 1 OR \r\n         COALESCE( T.QUARTER_INT, 1 ) = 2 THEN\r\n      &#039;1&#039;\r\n    ELSE\r\n      &#039;2&#039;\r\n  END AS HALFYEAR1,\r\n\r\n  COALESCE( T.YEAR, &#039;2020&#039; ) AS CALYEAR,\r\n\r\nFROM :intab AS I\r\n\r\nLEFT OUTER JOIN &quot;_SYS_BI&quot;.&quot;M_TIME_DIMENSION&quot; AS T\r\n\r\n    ON I.UDATE = T.DATE_SAP; <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-30e9345 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"30e9345\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8ac53c4\" data-id=\"8ac53c4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7e33538 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"7e33538\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-20f551d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"20f551d\" data-element_type=\"section\" data-e-type=\"section\" id=\"utc-zeitstempel\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-72a3bff\" data-id=\"72a3bff\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1ae5649 elementor-widget elementor-widget-heading\" data-id=\"1ae5649\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Herleitung eines aktuellen UTC-Zeitstempels<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-660debf elementor-widget elementor-widget-text-editor\" data-id=\"660debf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>In einer AMDP-Routine soll der aktuelle UTC-Zeitstempel ermittelt werden.<\/p><h3>Anmerkung<\/h3><p>Beispielcoding f\u00fcr eine AMDP-Feldprozedur.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-81d6e07 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"81d6e07\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-5f842c0\" data-id=\"5f842c0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-21a38ff elementor-widget elementor-widget-heading\" data-id=\"21a38ff\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-5d08ae4\" data-id=\"5d08ae4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8460e5d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8460e5d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c5cb4b0\" data-id=\"c5cb4b0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b88f21f elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"b88f21f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>METHOD PROCEDURE BY DATABASE PROCEDURE FOR HDB LANGUAGE SQLSCRIPT OPTIONS READ-ONLY.\r\n\r\nouttab =\r\nSELECT to_nvarchar(current_utctimestamp, &#039;YYYYMMDDHH24MISS&#039;) AS &quot;ETL_TIMESTAMP&quot;,\r\nrecord,\r\nsql__procedure__source__record\r\nFROM :intab;\r\n\r\nerrortab =\r\nSELECT &#039;&#039; AS &quot;ERROR_TEXT&quot; ,\r\n&#039;&#039; AS &quot;SQL__PROCEDURE__SOURCE__RECORD&quot;\r\nFROM dummy\r\nWHERE 0 = 1;\r\n\r\nENDMETHOD. <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0b877e8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0b877e8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-212b15c\" data-id=\"212b15c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f13acfb elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"f13acfb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-64b26d5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"64b26d5\" data-element_type=\"section\" data-e-type=\"section\" id=\"requesttsn\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6ec5478\" data-id=\"6ec5478\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e01f17d elementor-widget elementor-widget-heading\" data-id=\"e01f17d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Herleitung der Request-TSN<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c20371c elementor-widget elementor-widget-text-editor\" data-id=\"c20371c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>In BW on HANA gibt die AMDP-Schnittstelle die Request-Nummer nicht her. Sie muss etwas m\u00fchsam hergeleitet werden, um z.B. in einem Corporate Memory diese Nummer ablegen zu k\u00f6nnen (empfohlen, da man einzelne Requests zur\u00fcckladen m\u00f6chte und dieses Feld im Standard nicht als Selektion im DTP zur Verf\u00fcgung steht).<\/p><h3>Anmerkung<\/h3><p>Beispiel AMDP-Feldroutine.<br \/>Es muss jeweils das Ziel-ADSO im Coding angegeben werden.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-5bc2fb7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5bc2fb7\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-e017c6d\" data-id=\"e017c6d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-00cc6b7 elementor-widget elementor-widget-heading\" data-id=\"00cc6b7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-b7e9bea\" data-id=\"b7e9bea\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f3245ec elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f3245ec\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-326510f\" data-id=\"326510f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c086500 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"c086500\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>METHOD PROCEDURE BY DATABASE PROCEDURE FOR HDB LANGUAGE SQLSCRIPT \r\nOPTIONS READ-ONLY using RSPMREQUEST.\r\n\r\n\r\ndeclare lv_reqtsn varchar(23);\r\n\r\nSELECT request_tsn INTO lv_reqtsn FROM rspmrequest\r\nwhere datatarget = &#039;&#039; AND\r\nrequest_status = &#039;Y&#039; AND\r\nlast_operation_type = &#039;C&#039; AND\r\nrequest_is_in_process = &#039;Y&#039; AND\r\nstorage = &#039;AQ&#039;;\r\n\r\nouttab =\r\nSELECT lv_reqtsn AS &quot;ETL_REQTSN&quot;,\r\nrecord,\r\nsql__procedure__source__record\r\n\r\nFROM :inTab as input;\r\n\r\nerrortab =\r\nSELECT &#039;&#039; AS &quot;ERROR_TEXT&quot; ,\r\n&#039;&#039; AS &quot;SQL__PROCEDURE__SOURCE__RECORD&quot;\r\nFROM dummy\r\nWHERE 0 = 1;\r\n\r\nENDMETHOD. <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4805022 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4805022\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3738d2e\" data-id=\"3738d2e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6ddb902 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"6ddb902\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c02f8cc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c02f8cc\" data-element_type=\"section\" data-e-type=\"section\" id=\"lastwo\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2e6e69f\" data-id=\"2e6e69f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ad37da8 elementor-widget elementor-widget-heading\" data-id=\"ad37da8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Aktuellste Daten eines wo-ADSOs<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f961e71 elementor-widget elementor-widget-text-editor\" data-id=\"f961e71\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Wenn Sie Daten aus einem schreiboptimierten ADSO lesen (wo-ADSO), geht es h\u00e4ufig dazu, den neuesten Stand dieser Daten zu lesen, also den neuesten Request. Dies geht ganz einfach durch Suche nach der maximalen Request-Nummer.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-7027693 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7027693\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-39addca\" data-id=\"39addca\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a459d3d elementor-widget elementor-widget-heading\" data-id=\"a459d3d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-985f020\" data-id=\"985f020\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-45b78be elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"45b78be\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1d612dc\" data-id=\"1d612dc\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-babfa5c elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"babfa5c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>SELECT T1.REQTSN, T1.KEY, T1.FIELD\n  FROM WO-ADSO as T1\n    JOIN ( SELECT MAX(REQTSN) as TSN, KEY FROM WO-ADSO GROUP BY KEY ) AS T2 \n    ON T1.REQTSN = T2.TSN AND\n       T1.KEY = T2.KEY\n  WHERE T1.KEY = ...;\n <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d5c0160 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d5c0160\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6fd2254\" data-id=\"6fd2254\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bfda5e0 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"bfda5e0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fce8c70 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fce8c70\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-152c164\" data-id=\"152c164\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-df63b66 elementor-widget elementor-widget-heading\" data-id=\"df63b66\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"stammdaten\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Nachlesen von Stammdaten<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-87391c0 elementor-widget elementor-widget-text-editor\" data-id=\"87391c0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Sie k\u00f6nnen Stammdaten eines InfoObjekts auslesen, indem Sie die P-Tabelle (bei zeitabh\u00e4ngigen Stammdaten die Q-Tabelle) des InfoObjekts hinzujoinen.\u00a0<\/p><h3>Anmerkung<\/h3><p>Ist referentielle Integrit\u00e4t gegeben (d.h. existieren garantiert Stammdaten zu den Bewegungsdaten), dann kann ein INNER JOIN verwendet werden. Dieser ist performanter als ein OUTER JOIN.\u00a0<br \/>Ansonsten verwendet man einen LEFT OUTER JOIN, und sollte das eventuell Auftreten von NULL-Werten durch COALESCE abfangen.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-ff438ae elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ff438ae\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-42fac27\" data-id=\"42fac27\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4ee8bbe elementor-widget elementor-widget-heading\" data-id=\"4ee8bbe\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-c7c74f9\" data-id=\"c7c74f9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6dde4e2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6dde4e2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e2c4e37\" data-id=\"e2c4e37\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a7cdd25 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"a7cdd25\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>SELECT T1.*,\n       COALESECE( T2.FIELD, &#039;&#039;) AS FIELD\n  FROM ADSO as T1\n    LEFT OUTER JOIN \/BIC\/POBJECT AS T2\n    ON T2.KEY = T1.OBJECTFIELD\n  WHERE T2.OBJVERS = &#039;A&#039; AND ...;\n <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-218010f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"218010f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a90372a\" data-id=\"a90372a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5c971fa elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"5c971fa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3c0b955 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3c0b955\" data-element_type=\"section\" data-e-type=\"section\" id=\"exithandler\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-34bd472\" data-id=\"34bd472\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-21db525 elementor-widget elementor-widget-heading\" data-id=\"21db525\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Im AMDP SQL-Fehler abfangen<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ea73f4e elementor-widget elementor-widget-text-editor\" data-id=\"ea73f4e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Treten im AMDP SQL-Fehler auf, so k\u00f6nnen diese abgefangen und als Fehlermeldungen an den DTP zur\u00fcckgegeben werden.<\/p><h3>Anmerkung<\/h3><p>Das folgende Coding sollte dann an den Anfang des AMDP-Scripts gestellt werden.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-7e472b4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7e472b4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-d28b2ce\" data-id=\"d28b2ce\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ca7e7ec elementor-widget elementor-widget-heading\" data-id=\"ca7e7ec\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-b87df94\" data-id=\"b87df94\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-116305d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"116305d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-edd76bc\" data-id=\"edd76bc\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-09ad2be elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"09ad2be\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>DECLARE EXIT HANDLER FOR SQLEXCEPTION\nBEGIN \n  outtab = SELECT TOP 0 * from :outtab;\n  errortab = SELECT &#039;My Error Message&#039; AS ERROR_TEXT, \n                    &#039;&#039; AS SQL__PROCEDURE__SOURCE__RECORD FROM DUMMY&#039;; \nEND;\n <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5e3fc6a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5e3fc6a\" data-element_type=\"section\" data-e-type=\"section\" id=\"ownsqlerr\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-47c4c60\" data-id=\"47c4c60\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f2c4c9d elementor-widget elementor-widget-heading\" data-id=\"f2c4c9d\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"ownsqlerr\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Im AMDP eigene SQL-Fehlermeldungen werfen<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9fda565 elementor-widget elementor-widget-text-editor\" data-id=\"9fda565\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Man kann auch eigene Fehlermeldungen werfen, die dann sowohl im Protokoll des DTPs als auch als SQL-Fehlermeldungen in den Tracefiles des Indexservers der HANA-DB auftauchen.\u00a0<\/p><h3>Anmerkung<\/h3><p>Das folgende Coding sollte dann an den Anfang des AMDP-Scripts gestellt werden.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-a267ef9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a267ef9\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-3ec6d00\" data-id=\"3ec6d00\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-59deab8 elementor-widget elementor-widget-heading\" data-id=\"59deab8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-a4c1f58\" data-id=\"a4c1f58\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-67f3b82 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"67f3b82\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a7e4a5a\" data-id=\"a7e4a5a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4528770 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"4528770\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>DECLARE MYCOND CONDITION FOR SQL_ERROR_CODE 10001;\nDECLARE EXIT HANDLER FOR MYCOND RESIGNAL;\nSIGNAL MYCOND SET MESSAGE_TEXT = &#039;     Typical Not-found Error&#039;;\n   \n\n\n-- in case of error throw here\nSIGNAL MYCOND;\n <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-09aea71 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"09aea71\" data-element_type=\"section\" data-e-type=\"section\" id=\"errhandling\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a589854\" data-id=\"a589854\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1887296 elementor-widget elementor-widget-heading\" data-id=\"1887296\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Im AMDP g\u00fcltige S\u00e4tze verbuchen, fehlerhafte in Errorstack schreiben<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-af09242 elementor-widget elementor-widget-text-editor\" data-id=\"af09242\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Beschreibung<\/h3><p>Ist man in einem BW\/4HANA-Release, so muss man als Voraussetzung muss man in der Transformation die Einstellung &#8222;Fehlerhandling f\u00fcr HANA-Routinen erlauben&#8220;. Ist dies gesetzt, so definiert die AMDP-Schnittstelle neben der outTab-Tabelle auch eine errorTab-Tabelle.<br \/>Im DTP muss zus\u00e4tzlich eine geeignete Einstellung vorgenommen sein, z.B. die Einstellung &#8222;Request auf gr\u00fcn setzen, Fehlerstack schreiben, g\u00fcltige S\u00e4tze verbuchen&#8220;.\u00a0<\/p><h3>Anmerkung<\/h3><p>Das folgende Coding zeigt beispielhaft, wie aus einer Stammdatentabelle S\u00e4tze nachgelesen werden. Diejenigen S\u00e4tze, bei denen ein nicht-leerer Eintrag gefunden wird, werden als g\u00fcltige S\u00e4tze behandelt, die anderen werden als fehlerhafte S\u00e4tze behandelt.\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-577751c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"577751c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-115101d\" data-id=\"115101d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ffcf9d7 elementor-widget elementor-widget-heading\" data-id=\"ffcf9d7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Coding Beispiel<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-c56a0a5\" data-id=\"c56a0a5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ef7cb5d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ef7cb5d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-25ab68f\" data-id=\"25ab68f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7e5e556 elementor-widget elementor-widget-elementor-syntax-highlighter\" data-id=\"7e5e556\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-syntax-highlighter.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<pre><code class='language-sql'>table1 = SELECT\n       :i_req_requid as ZTS1REQTSN, \n       CALYEAR,\n       COUNTRY,\n       PRODUCT,\n       I.RECORDMODE,\n       I.&quot;\/BIC\/ZTS1CNTRY&quot;,\n       COALESCE(P.&quot;\/BIC\/ZTS1FAREA&quot;,&#039;&#039;) AS &quot;\/BIC\/ZTS1FAREA&quot;,\n       to_nvarchar(current_utctimestamp, &#039;YYYYMMDDHH24MISS&#039;) AS UTC,\n       QUANTITY,\n       RECORD,\n       SQL__PROCEDURE__SOURCE__RECORD\n\n   FROM :inTab as I\n   LEFT OUTER JOIN &quot;\/BIC\/PZTS1CNTRY&quot; AS P\n   ON I.&quot;\/BIC\/ZTS1CNTRY&quot; = P.&quot;\/BIC\/ZTS1CNTRY&quot; AND\n      P.OBJVERS = &#039;A&#039; AND\n      NOT ( P.RECORDMODE = &#039;R&#039; );\n\n-- Allow Error Handling for HANA Routines is enabled\n\nif :i_error_handling = &#039;TRUE&#039; then\n   errorTab = select\n              &#039;FAREAMISSING&#039; as ERROR_TEXT,\n              SQL__PROCEDURE__SOURCE__RECORD as SQL__PROCEDURE__SOURCE__RECORD\n              FROM :table1\n              where &quot;\/BIC\/ZTS1FAREA&quot; = &#039;&#039;;\n\nend if;\n   \noutTab = select * from :table1\n            where NOT ( &quot;\/BIC\/ZTS1FAREA&quot; = &#039;&#039; );\n <\/code><\/pre><script>\nif (!document.getElementById('syntaxed-prism')) {\n\tvar my_awesome_script = document.createElement('script');\n\tmy_awesome_script.setAttribute('src','https:\/\/www.cubeserv.com\/wp-content\/plugins\/syntax-highlighter-for-elementor\/assets\/prism2.js');\n\tmy_awesome_script.setAttribute('id','syntaxed-prism');\n\tdocument.body.appendChild(my_awesome_script);\n} else {\n\twindow.Prism && Prism.highlightAll();\n}\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Lange danach gesucht? Jetzt gefunden! Unsere \u00dcbersicht von typischen Problemen und L\u00f6sungen im Bereich von HANA SQLscript.\u00a0 Die L\u00f6sungsmuster reichen dabei von rein sprachlichen Problemen (z.B. &#8222;mit welchem Sprachelement ermittle ich den ersten Eintrag&#8220;) \u00fcber formale Probleme (z.B. &#8222;wie wandle ich in SQLscript Zeitmerkmale um&#8220;) bis zu applikatorischen Anforderungen (z.B. &#8222;wie lese ich in SQLscript &#8230; <a title=\"SQLscript L\u00f6sungsmuster\" class=\"read-more\" href=\"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/\" aria-label=\"Mehr Informationen \u00fcber SQLscript L\u00f6sungsmuster\">Weiterlesen &#8230;<\/a><\/p>\n","protected":false},"author":16,"featured_media":12894,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[397],"tags":[43,437,407,375,436],"class_list":["post-10647","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news","tag-hana","tag-loesungsmuster","tag-sap-hana","tag-sql","tag-sqlscript"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQLscript L\u00f6sungsmuster - CubeServ<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLscript L\u00f6sungsmuster\" \/>\n<meta property=\"og:description\" content=\"Lange danach gesucht? Jetzt gefunden! Unsere \u00dcbersicht von typischen Problemen und L\u00f6sungen im Bereich von HANA SQLscript.\u00a0 Die L\u00f6sungsmuster reichen dabei von rein sprachlichen Problemen (z.B. &#8222;mit welchem Sprachelement ermittle ich den ersten Eintrag&#8220;) \u00fcber formale Probleme (z.B. &#8222;wie wandle ich in SQLscript Zeitmerkmale um&#8220;) bis zu applikatorischen Anforderungen (z.B. &#8222;wie lese ich in SQLscript ... Weiterlesen ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/\" \/>\n<meta property=\"og:site_name\" content=\"CubeServ\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/CubeServ\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-21T07:37:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-30T20:56:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/03\/sql-script-loesungsmuster-titel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"220\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Thorsten Stossmeister\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@CubeServ\" \/>\n<meta name=\"twitter:site\" content=\"@CubeServ\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Thorsten Stossmeister\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"20\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/sqlscript-loesungsmuster\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/sqlscript-loesungsmuster\\\/\"},\"author\":{\"name\":\"Thorsten Stossmeister\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/#\\\/schema\\\/person\\\/2a15f26fb37d4ff3c8fb491ac4ce66d9\"},\"headline\":\"SQLscript L\u00f6sungsmuster\",\"datePublished\":\"2020-04-21T07:37:00+00:00\",\"dateModified\":\"2023-03-30T20:56:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/sqlscript-loesungsmuster\\\/\"},\"wordCount\":1781,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/sqlscript-loesungsmuster\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/sql-script-loesungsmuster-titel.jpg\",\"keywords\":[\"HANA\",\"L\u00f6sungsmuster\",\"SAP HANA\",\"SQL\",\"SQLscript\"],\"articleSection\":[\"News\"],\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/sqlscript-loesungsmuster\\\/\",\"url\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/sqlscript-loesungsmuster\\\/\",\"name\":\"SQLscript L\u00f6sungsmuster - CubeServ\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/sqlscript-loesungsmuster\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/sqlscript-loesungsmuster\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/sql-script-loesungsmuster-titel.jpg\",\"datePublished\":\"2020-04-21T07:37:00+00:00\",\"dateModified\":\"2023-03-30T20:56:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/sqlscript-loesungsmuster\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/sqlscript-loesungsmuster\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/sqlscript-loesungsmuster\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/sql-script-loesungsmuster-titel.jpg\",\"contentUrl\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/sql-script-loesungsmuster-titel.jpg\",\"width\":600,\"height\":220},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/sqlscript-loesungsmuster\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQLscript L\u00f6sungsmuster\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/#website\",\"url\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/\",\"name\":\"CubeServ\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/#organization\",\"name\":\"CubeServ Group\",\"url\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/CubeServ_Web_Logo-768x372-1.png\",\"contentUrl\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/CubeServ_Web_Logo-768x372-1.png\",\"width\":768,\"height\":372,\"caption\":\"CubeServ Group\"},\"image\":{\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/CubeServ\",\"https:\\\/\\\/x.com\\\/CubeServ\",\"https:\\\/\\\/www.instagram.com\\\/cubeservgroup\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/112961\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/CubeServGroup\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/#\\\/schema\\\/person\\\/2a15f26fb37d4ff3c8fb491ac4ce66d9\",\"name\":\"Thorsten Stossmeister\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/elementor\\\/thumbs\\\/stossmeister_thorsten-backup-pz0j1qe4za2mtid8n7u1m19ontcib6ti4uoux2984c.jpg\",\"url\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/elementor\\\/thumbs\\\/stossmeister_thorsten-backup-pz0j1qe4za2mtid8n7u1m19ontcib6ti4uoux2984c.jpg\",\"contentUrl\":\"https:\\\/\\\/www.cubeserv.com\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/elementor\\\/thumbs\\\/stossmeister_thorsten-backup-pz0j1qe4za2mtid8n7u1m19ontcib6ti4uoux2984c.jpg\",\"caption\":\"Thorsten Stossmeister\"},\"description\":\"Competency Lead EDW\\\/HANA with sometimes old-fashioned preferences for backend and ABAP\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/stossmeister-thorsten-4b2427117\\\/\"],\"url\":\"https:\\\/\\\/www.cubeserv.com\\\/de\\\/author\\\/stossmeistert\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQLscript L\u00f6sungsmuster - CubeServ","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/","og_locale":"de_DE","og_type":"article","og_title":"SQLscript L\u00f6sungsmuster","og_description":"Lange danach gesucht? Jetzt gefunden! Unsere \u00dcbersicht von typischen Problemen und L\u00f6sungen im Bereich von HANA SQLscript.\u00a0 Die L\u00f6sungsmuster reichen dabei von rein sprachlichen Problemen (z.B. &#8222;mit welchem Sprachelement ermittle ich den ersten Eintrag&#8220;) \u00fcber formale Probleme (z.B. &#8222;wie wandle ich in SQLscript Zeitmerkmale um&#8220;) bis zu applikatorischen Anforderungen (z.B. &#8222;wie lese ich in SQLscript ... Weiterlesen ...","og_url":"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/","og_site_name":"CubeServ","article_publisher":"https:\/\/www.facebook.com\/CubeServ","article_published_time":"2020-04-21T07:37:00+00:00","article_modified_time":"2023-03-30T20:56:40+00:00","og_image":[{"width":600,"height":220,"url":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/03\/sql-script-loesungsmuster-titel.jpg","type":"image\/jpeg"}],"author":"Thorsten Stossmeister","twitter_card":"summary_large_image","twitter_creator":"@CubeServ","twitter_site":"@CubeServ","twitter_misc":{"Verfasst von":"Thorsten Stossmeister","Gesch\u00e4tzte Lesezeit":"20\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/#article","isPartOf":{"@id":"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/"},"author":{"name":"Thorsten Stossmeister","@id":"https:\/\/www.cubeserv.com\/de\/#\/schema\/person\/2a15f26fb37d4ff3c8fb491ac4ce66d9"},"headline":"SQLscript L\u00f6sungsmuster","datePublished":"2020-04-21T07:37:00+00:00","dateModified":"2023-03-30T20:56:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/"},"wordCount":1781,"commentCount":0,"publisher":{"@id":"https:\/\/www.cubeserv.com\/de\/#organization"},"image":{"@id":"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/03\/sql-script-loesungsmuster-titel.jpg","keywords":["HANA","L\u00f6sungsmuster","SAP HANA","SQL","SQLscript"],"articleSection":["News"],"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/","url":"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/","name":"SQLscript L\u00f6sungsmuster - CubeServ","isPartOf":{"@id":"https:\/\/www.cubeserv.com\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/#primaryimage"},"image":{"@id":"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/03\/sql-script-loesungsmuster-titel.jpg","datePublished":"2020-04-21T07:37:00+00:00","dateModified":"2023-03-30T20:56:40+00:00","breadcrumb":{"@id":"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/#primaryimage","url":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/03\/sql-script-loesungsmuster-titel.jpg","contentUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/03\/sql-script-loesungsmuster-titel.jpg","width":600,"height":220},{"@type":"BreadcrumbList","@id":"https:\/\/www.cubeserv.com\/de\/sqlscript-loesungsmuster\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/www.cubeserv.com\/de\/"},{"@type":"ListItem","position":2,"name":"SQLscript L\u00f6sungsmuster"}]},{"@type":"WebSite","@id":"https:\/\/www.cubeserv.com\/de\/#website","url":"https:\/\/www.cubeserv.com\/de\/","name":"CubeServ","description":"","publisher":{"@id":"https:\/\/www.cubeserv.com\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cubeserv.com\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/www.cubeserv.com\/de\/#organization","name":"CubeServ Group","url":"https:\/\/www.cubeserv.com\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.cubeserv.com\/de\/#\/schema\/logo\/image\/","url":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/07\/CubeServ_Web_Logo-768x372-1.png","contentUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/07\/CubeServ_Web_Logo-768x372-1.png","width":768,"height":372,"caption":"CubeServ Group"},"image":{"@id":"https:\/\/www.cubeserv.com\/de\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/CubeServ","https:\/\/x.com\/CubeServ","https:\/\/www.instagram.com\/cubeservgroup\/","https:\/\/www.linkedin.com\/company\/112961\/","https:\/\/www.youtube.com\/user\/CubeServGroup"]},{"@type":"Person","@id":"https:\/\/www.cubeserv.com\/de\/#\/schema\/person\/2a15f26fb37d4ff3c8fb491ac4ce66d9","name":"Thorsten Stossmeister","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/12\/elementor\/thumbs\/stossmeister_thorsten-backup-pz0j1qe4za2mtid8n7u1m19ontcib6ti4uoux2984c.jpg","url":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/12\/elementor\/thumbs\/stossmeister_thorsten-backup-pz0j1qe4za2mtid8n7u1m19ontcib6ti4uoux2984c.jpg","contentUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/12\/elementor\/thumbs\/stossmeister_thorsten-backup-pz0j1qe4za2mtid8n7u1m19ontcib6ti4uoux2984c.jpg","caption":"Thorsten Stossmeister"},"description":"Competency Lead EDW\/HANA with sometimes old-fashioned preferences for backend and ABAP","sameAs":["https:\/\/www.linkedin.com\/in\/stossmeister-thorsten-4b2427117\/"],"url":"https:\/\/www.cubeserv.com\/de\/author\/stossmeistert\/"}]}},"_links":{"self":[{"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/posts\/10647","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/comments?post=10647"}],"version-history":[{"count":0,"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/posts\/10647\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/media\/12894"}],"wp:attachment":[{"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/media?parent=10647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/categories?post=10647"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/tags?post=10647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}