---
# System prepended metadata

title: IBM DB2

---

IBM DB2 
===

[TOC]

# Note

* Use lookup table for project constants

## Making changes to DB 

# Transactional

* Relational & NoSQL


## Querying

### To see columns in a table

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

### To select and replace

To select and replace a string in the selection

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