02a – SQL (EN)

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!

Lateral Join SQL DB2 for i: not everybody knows about it but it’s very powerfull in our “queries” --- Roberto De Pedrini Faq400.com

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 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,

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…