![](/accounts/common/images/logo.png)
Data Manipulation — Sven Jansson
-
Register
- Member - Free!
Already registered?
Log in now.
- Commitment / Transaction Control Introduction
- INSERT
- Insert a single (or multiple rows) by column listing
- Insert rows based on a SELECT Statement
- UPDATE
- Update a single Value / multiple Values / Single Row / Multiple Rows
- Update a Table from another table
- DELETE
- Delete a Single Row / multiple Rows
- Delete based on a SELECT Statement
- Using LIMIT (and OFFSET) in composition with INSERT/UPDATE/DELETE
![Speaker image](https://70ecbb36cf5afa131dcc-6f15f2badde623b67dc4ad2e21c9f77b.ssl.cf2.rackcdn.com/common_e469ea155350a232e424809165b13826.jpg)
Sven Jansson
Senior Developer
Apper Systems AB
I have worked on the IBM i platform since 1995. My technical roles include developer, analyst, database specialist, application security, and communications. I also worked on IBMz for a few years, and I serve on the COMMON Sweden board. I'm a curious person who always wants to learn new things. I enjoy participating in basketball and hockey as a player, referee, coach, and equipment manager. My big passion is SCUBA diving to explore wrecks in the Baltic Sea. When I'm not behind a laptop, I'm out on the water, either sailing or diving, and I have a weakness for ice cream.
Key:
![](/images/product-status-icons/complete-small.png)
![](/images/product-status-icons/next-small.png)
![](/images/product-status-icons/disabled-small.png)
![](/images/product-status-icons/optional-small.png)
![](/images/product-status-icons/locked-small.png)