Data Manipulation — Sven Jansson

  • 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

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:

Complete
Failed
Available
Locked
Video
Open to view video.
Open to view video.