Scenario: A developer wants to import data from a CSV file into a DB2 table. However, the CSV file contains a header row that should be excluded during the import process. Which option of the IMPORT utility should they use?

  • MODIFIED BY ANYORDER
  • MODIFIED BY NOHEADERS
  • MODIFIED BY NOCHARDEL
  • MODIFIED BY COLDEL
The MODIFIED BY NOHEADERS option should be used to exclude the header row during the import process. This option instructs the IMPORT utility not to treat the first row of the input file as column data, effectively skipping it during the import operation. This ensures that only the actual data from the CSV file is imported into the DB2 table, without including the header row. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *