PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

CPYTOIMPF and CPYFRMIMPF Supports column headings

View previous topic View next topic Go down

CPYTOIMPF and CPYFRMIMPF Supports column headings

Post  maran on Sat Mar 23, 2013 1:11 am

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.
avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum