Results 1 to 7 of 7

Thread: Uploading a .CSV file into AS/400

  1. #1
    Developer sai400's Avatar
    Join Date
    Oct 2007
    Location
    MUMBAI,INDIA
    Age
    31
    Posts
    134
    Rep Power
    1119

    Uploading a .CSV file into AS/400

    Hi,


    I need to upload a .csv file from my PC into a Flat file in AS/400.
    Can anybody advice on how to do this



    Thanks
    Sai.
    To every equation there is a solution....
    Regards
    Sai.

  2. # 666
    Circuit advertisement
    Join Date
    Aug 1965
    Location
    Yakutsk, Russia
    Age
    21
    Posts
    1,000,000
     

  3. #2
    VP of Beverage Stimulants jtemple's Avatar
    Join Date
    Feb 2006
    Location
    Missouri
    Age
    47
    Posts
    924
    Rep Power
    2260

    Re: Uploading a .CSV file into AS/400

    When you say "flat file" do you mean a program described file stored in the traditional library/file system or a text file stored on the IFS? Do you want the commas removed from the CSV or keep them intact? Are you planning on importing the data into a database file?

    Questions, questions, questions....
    Jonas Temple
    Got FROG?
    Got Tadpole? No, because it's not done yet! Stay tuned....

    01010111 01100001 01110011 01110011 01110101 01110000 00100000 01100100 01101111 01100111 00111111

  4. #3
    Experienced Forum Member arrow483's Avatar
    Join Date
    Oct 2004
    Location
    New Hampshire
    Posts
    1,741
    Rep Power
    4219

    Re: Uploading a .CSV file into AS/400

    You could use FTP.

  5. #4
    Developer sai400's Avatar
    Join Date
    Oct 2007
    Location
    MUMBAI,INDIA
    Age
    31
    Posts
    134
    Rep Power
    1119

    Re: Uploading a .CSV file into AS/400

    Hi, I need the Commas to be removed from the CSV file, and i need to copy it to either an IFS folder or to a database file defined with a single field of length 4000.
    To every equation there is a solution....
    Regards
    Sai.

  6. #5
    Code400 Newdie chrisr's Avatar
    Join Date
    Jan 2010
    Location
    Sydney
    Posts
    192
    Rep Power
    1133

    Re: Uploading a .CSV file into AS/400

    Maybe you want fixed width in the rows for readability?
    I'd be looking at some vba code which maps a network drive to an IFS share and then does a file "Save As" operation (tab or space delimited) from excel to that location.

  7. #6
    Driver of cars, eater of food jamief's Avatar
    Join Date
    Jan 2004
    Location
    Belvidere, IL - United States of America
    Age
    49
    Posts
    9,416
    Rep Power
    12606

    Re: Uploading a .CSV file into AS/400

    command cpytoimpf allows you tocopy to IFS.
    You can use DTAFMT *FIXED
    or *DLM and mess with FLDDLM

    jamie
    All my answers were extracted from the "Big Dummy's Guide to the As400"
    and I take no responsibility for any of them.

    www.code400.com

  8. #7
    Code400 Newbie
    Join Date
    Feb 2010
    Location
    Milan
    Posts
    45
    Rep Power
    1644

    Re: Uploading a .CSV file into AS/400

    www.Easy400.net features a free WEB utility, named FUPLOAD which allows you to upload/download any PC file to/from IFS.

    Giovanni

  9. # 666
    Circuit advertisement
    Join Date
    Aug 1965
    Location
    Yakutsk, Russia
    Posts
    1,000,000
     

Facebook Comments


Similar Threads

  1. Retrieve OUTQ Content List into PF
    By Shogun1950 in forum CLP/CLLE
    Replies: 9
    Last Post: August 11th, 2009, 09:28 AM
  2. AS/400 DATA TRANSFER (.FDF file)
    By tasho in forum Iseries System administration
    Replies: 3
    Last Post: May 15th, 2008, 03:12 AM
  3. Regd moving
    By sudha in forum Iseries System administration
    Replies: 4
    Last Post: April 26th, 2007, 09:17 AM
  4. Transferring Save file
    By vivek in forum RPG/RPGLE
    Replies: 13
    Last Post: July 10th, 2006, 10:32 PM
  5. Replies: 4
    Last Post: June 23rd, 2005, 06:08 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •