IBM Support

CPYTOIMPF and CPYFRMIMPF commands - Include column headings

News


Abstract

CPYTOIMPF and CPYFRMIMPF commands - Include column headings

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements > CPYTOIMPF and CPYFRMIMPF commands - Include column headings

Copy To Import File (CPYTOIMPF) – a new (optional) parameter indicates whether the column names should be included as the first row in the target file.
ADDCOLNAM - Specifies if the column names should be added to the first record of the to file.
  • *NONE – (default) don’t include the columns names.
  • *SQL – The column SQL names will be used to populate the first row.
  • *SYS – The column System names will be used to populate the first row.


Copy From Import File (CPYFRMIMPF) – a new (optional) parameter indicates whether the first row should be skipped when processing the import file.

RMVCOLNAM - Specifies if the column names should be removed from the from file.

  • *NO – (default) don’t skip the first row. The copy will begin with the first record from the from file.
  • *YES – The copy will begin with the second record from the from file because the first record contains the column names.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
14 January 2020

UID

ibm11167400