SQL: Perfect cuts with SPLIT (EN)
9 September 2019
The new SPLIT function makes it easy to split strings that have a separator character of values within them. Let's see how to do it!
SQL “Lateral Join” … do you know this SQL join? (EN)
7 September 2019
Lateral Join SQL DB2 for i: not everybody knows about it but it’s very powerfull in our “queries”
---
Roberto De Pedrini
Faq400.com
Generated Always Columns (EN)
27 July 2019
Introduction “Generated Always Column”: are columns, table fields, filled by DB2 engine: something like columns with a default value but in this case always with the default value not only when users don’t pass a…
---
Roberto De Pedrini
Faq400.com
DB2 for i - FAQ & Howtos (EN)
1 April 2019
DB2 Database and SQL … maybe the most important things on IBM i platform: here’s a collection of FAQs, tips and howtos from forums and other IBM i related websites,
DB2 for i SQL - String Manipulation - POSSTR-LOCATE-LOCATE_IN_STRING (EN)
25 March 2019
Introduction Often, in our applications, we need to work with text strings, and DB2 SQL can come in very useful and simplify our code. In this guide we see some interesting SQL functions for string…