Sometimes there is a need to concatenate strings from a column into a single row. Some databases already provide a solution with the GROUP_CONCAT() aggregate function, such as SQLite and MySQL. In DB2 you can use the XMLAGG() function to aggregate the strings from different rows into a single XML string, and then transform...
Read more →Originally called Raptor – SQL Developer has become quite a decent SQL Development tool over the years. The nice thing about it, besides the fact that it’s free, is that it also works with databases other than Oracle. For instance if you don’t like IBM Data Studio’s clunky interface for your DB2 development, then...
Read more →You just installed DB2 as non-root user on Linux and when you attempt to start your instance with the db2start command, you get the following message: "SQL1220N The database manager shared memory set cannot be allocated." Depending on which version of DB2 you’re using, and who knows what else, you could try one or...
Read more →