Before you begin...

To import a file into a table, you must have one the following authorities:

• To import using the INSERT option:

  • SYSADM

  • DBADM

  • CONTROL privilege on the table or view

  • INSERT and SELECT privilege on the table

• To import to an existing table using the INSERT_UPDATE, REPLACE, or the REPLACE_CREATE option:

  • SYSADM

  • DBADM

  • CONTROL privilege on the table

• To import to a table that does not exist using the CREATE or the REPLACE_CREATE option:

  • SYSADM

  • DBADM

  • CREATETAB privilege

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]