Pages

Sunday, November 22, 2015

Copy Data from CSV to PF

1. Upload .CSV File to iSeries IFS.

     a. Open 'File System' through iSeries Navigator and Copy the .CSV File to IFS.

     b. If not, FTP .CSV file to IFS Directory Directly.

2. Copy .CSV file from IFS to Physical File.

     a. Create Physical File (PF) with Required Fields (Fields available in .CSV File).

     b. Use CPYFRMIMPF (Copy From Import File) Command to Copy Data from CSV file to PF.

     c.  Use Record Delimter (RCDDLM) parameter as '*CR'.

No comments:

Post a Comment

Removing elements from a list in Python with list method pop()

Removing elements from a list It's often essential to remove the data from any data set (let's take 'list' in this case).  T...