IBM DB2
===

[TOC]

# Note

* Use lookup table for project constants

## Making changes to DB

# Transactional

* Relational & NoSQL

## Querying

### To see columns in a table

SELECT *  FROM SYSCAT.COLUMNS c WHERE c.tabname = '' ;

### To select and replace

To select and replace a string in the selection

SELECT REPLACE(tn.column_name, search_string, replacement_string) 
FROM table_name tn 
    WHERE conditional;