Adding and modifying data in tables from application programs

Your application program can add, modify, or delete data in any Db2 table for which you have the appropriate access.

Inserting data into tables
You can use several different methods to insert data into a table. Decide which method to use based on the amount of data that you need to insert and the other operations that your program needs to perform.
Adding data to the end of a table
In a relational database, the rows of a table are not ordered, and thus, the table has no end. However, depending on your goal, you can perform several actions to simulate adding data to the end of a table.
Storing data that does not have a tabular format
Db2 provides several options for you to store large volumes of data that is not defined as a set of columns in a table.
Updating table data
You can change a column value to another value or remove the column value altogether.
Deleting data from tables
You can delete data from a table by deleting one or more rows from the table, by deleting all rows from the table, or by dropping columns from the table.

Parent topic: Db2 SQL programming