DB2 10.5 for Linux, UNIX, and Windows

Export sessions - CLP examples

Example 1
The following example shows how to export information from the STAFF table in the SAMPLE database (to which the user must be connected) to myfile.ixf, with the output in IXF format. If the database connection is not through DB2 Connect™, the index definitions (if any) will be stored in the output file; otherwise, only the data will be stored:

   db2 export to myfile.ixf of ixf messages msgs.txt select * from staff

Example 2
The following example shows how to export the information about employees in Department 20 from the STAFF table in the SAMPLE database (to which the user must be connected) to awards.ixf, with the output in IXF format:

   db2 export to awards.ixf of ixf messages msgs.txt select * from staff
      where dept = 20

Example 3
The following example shows how to export LOBs to a DEL file:

   db2 export to myfile.del of del lobs to mylobs/
      lobfile lobs1, lobs2 modified by lobsinfile
      select * from emp_photo

Example 4
The following example shows how to export LOBs to a DEL file, specifying a second directory for files that might not fit into the first directory:

   db2 export to myfile.del of del
      lobs to /db2exp1/, /db2exp2/ modified by lobsinfile
      select * from emp_photo

Example 5
The following example shows how to export data to a DEL file, using a single quotation mark as the string delimiter, a semicolon as the column delimiter, and a comma as the decimal point. The same convention should be used when importing data back into the database:

   db2 export to myfile.del of del
      modified by chardel'' coldel; decpt,
      select * from staff