• DB2

    Concatenate Strings from a Column Into a Single Row

    by  • December 20, 2011 • DB2, Oracle, SQL • 0 Comments

    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 →

    SQL Developer with a DB2 Database

    by  • September 6, 2011 • DB2, Oracle, SQL • 0 Comments

    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 →