Skillup i Power Days – 6-7 June 2024 Milano
Similar Posts
iSeries Sql – CTE Common Table Expressions – definitions and usage
Common Table Expressions (CTE) in SQL on IBM iSeries (AS/400), as in other database management systems, are a powerful and flexible feature that allows you to create temporary, reusable queries within a larger SQL statement wide. They are particularly useful…
Recursive CTE how to concatenate the results onto a single line
Below are the articles in the CTE series (including this current one): Definition of the context Let’s suppose we have a table that reports the results of nightly interface processing, as in the following example: INT RESULT 0011 0012 0013…
Skillup i Power Days 2024 – Interview – intro
Intervista SkillUP – parte introduttiva
Recursive CTE: The Elegance of Simplicity in SQL – 1
Common Table Expressions (CTE) in SQL on IBM iSeries (AS/400) are a powerful and flexible tool for creating temporary, reusable queries, simplifying and improving the readability of complex SQL queries. Below are the articles in the CTE series (including this…
Ha ancora senso investire nella modernizzazione dell’AS/400? Una riflessione sull’entropia dei sistemi legacy
Dopo 30+ anni di compatibilità retroattiva, molti sistemi IBM i accumulano “entropia tecnica”: codice non documentato, integrazioni temporanee diventate permanenti, competenze perse nel turnover.
Questo articolo analizza quando investire in modernizzazione mirata vs migrazione completa, con un caso reale di programmi RPG “dimenticati” che generavano report strategici.
Recursive CTE: The Elegance of Simplicity in SQL – 2
Common Table Expressions (CTE) in SQL on IBM iSeries (AS/400) are a powerful and versatile tool for processing temporary, reusable queries. They help simplify and increase the clarity of complex SQL queries, making them more manageable and easier to understand….