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.
About this task
Besides using stand-alone INSERT statements, you can use
the following ways to insert data into a table:
- You can user the MERGE statement to insert new data and update existing data in the same operation. .
- You can write an application program to prompt for and enter large amounts of data into a table.
- You can also use the DB2® LOAD utility to enter data from other sources.