IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
#Power
 View Only
Back to discussions
Expand all | Collapse all

How to create the file in IBM i using Data Transfer to IBM i and specifying the location of .csv and .fdf of the file?

  • 1.  How to create the file in IBM i using Data Transfer to IBM i and specifying the location of .csv and .fdf of the file?

    Posted Mon February 22, 2021 05:18 PM

    When transferring data from pc to IBM i via Data Transfer to IBM i and specifying the .csv and .fdf location of the file, the Field reference file name should be specified, meaning the file should be existing in IBM i. In my case, I need to create the file first in IBM i based on .csv and .fdf. of the file.

    How can I use the Data Transfer to IBM i, .csv and .fdf to create the file in IBM i before transferring data to IBM i?





    #IBMi
    #Support
    #SupportMigration


  • 2.  RE: How to create the file in IBM i using Data Transfer to IBM i and specifying the location of .csv and .fdf of the file?

    Posted Fri March 26, 2021 10:42 PM

    The short answer is to create a .fdfx file from your spreadsheet by scanning it as per instructions. Use that .fdfx file to create a DB table, then upload to it.

    Here is the best reference I have found.

    https://www.ibm.com/support/pages/transferring-data-excel-using-access-client-solutions.





    #Support
    #SupportMigration
    #IBMi


Related Content