IBM Db2 11.1 Certification Guide

The Db2 Import utility

If you want to read data directly from an external file and insert it into a specific table or an updatable view, you can use the IMPORT utility. The external files can be in one of the file formats: DEL, ASC, PC/IXF, and WSF.

The basic syntax for IMPORT command is as shown here:

    IMPORT FROM [FileName] OF [DEL | ASC | WSF | IXF]
    <LOBS FROM [LOBPath]>
    <XML FROM [XMLPath]>
    <MODIFIED BY [Modifiers]>
    <Method>
    <XML PARSE [STRIP | PRESERVE] WHITESPACE>
    <XMLVALIDATE USING [XDS | SCHEMA [SchemaID]]>
    <ALLOW NO ACCESS | ALLOW WRITE ACCESS>
    <COMMITCOUNT [CommitCount] | COMMITCOUNT AUTOMATIC>
    <RESTARTCOUNT | SKIPCOUNT [RestartCount]>
    <WARNINGCOUNT [WarningCount]>
    <NOTIMEOUT>
    <MESSAGES [MsgFileName]>
    [CREATE | INSERT | INSERT_UPDATE ...