News
Abstract
CPYTOIMPF and CPYFRMIMPF commands - Include column headings
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
14 January 2020
UID
ibm11167400