Question about Computers & Internet

2 Answers

CSV file to AS/400

I want to convert the CSV File to AS/400 so pls give the steps to do it. And moreover i have completed 50% of the work by File transfering protocol and when i use the command cpyfrmimpf it says error 11 and file not copied so pls clarify a clear steps to proceed. thx...

Posted by on


2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.


    An expert whose answer got voted for 20 times.

  • Expert
  • 62 Answers

FTP is "line oriented." It has no concept of 'database record formats.' It transfers strings of characters with essentially no knowledge of 'fields' or 'columns' that make up 'records.' A 'record' to FTP is usually just whatever string of characters that is found between record delimiters.

Trying to FTP into a DB2 externally-described database file requires having strings of characters that are (1) laid out to match the receiving record format and (2) either are already converted to the proper CCSID and transferred as BINARY, or are ASCII characters that would result in conversions to all the right characters and transferred as ASCII.

Regardless of which alternative is chosen for "(2)", the handling of record format positions that would match up with packed-decimal or other non-character type fields would be very tricky.

That's where a somewhat 'standard' file format such as .CSV comes in.

However, you don't transfer the .CSV file directly over the top of the DB2 file. Instead, you transfer the .CSV file into a simple directory on your AS/400 and then use it as the source for a DB2 import function. On your AS/400, the import function is most often the CPYFRMIMPF command.

The import takes the .CSV file and handles all of the mappings for field positions and data types.

As such, the sequence becomes (1) FTP the .CSV file to the AS/400, and (2) run CPYFRMIMPF on the AS/400.

Note that the format of the .CSV file makes a difference. You need to ensure proper CCSID settings, proper quoting where necessary, proper record separators, etc. Make sure that you generate a .CSV that can be converted to the record format of the eventual target database file. Lots of possible details, but _far_ easier than trying to construct a matching DB2 record format on a different platform.

Posted on Sep 16, 2009

  • Level 1:

    An expert who has achieved level 1.


    An expert that has over 10 points.


    An expert whose answer got voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 11 Answers

If you have an ODBC driver for your database on the AS400 and MS SQL server?s tools installed, you can use SSIS from SQL server to parse and import the CSV file into a table in your AS400. IF you do not have access to SQL server, contact me I have tools to do this with out SQL Server, but you will need an ODBC driver, and it would help to know what you are putting the data in on an AS400, but you could be running many different platforms and storing the data in many formats. Good Luck

Posted on Oct 01, 2007


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

2 Answers

How Ca I Import Excel Contacts into vCard?

The free Opal-Convert Excel to vCard to Excel might work for you. Opal Convert Excel to vCard to Excel

Nov 07, 2014 | Computers & Internet

1 Answer

I have a LS8EQ printer, I am receiving a message reading "exception trap" then the printer turns off. I am using .38mmX7.6m tape. It only displays this error when using font size 10, but it will print...

If you are using an imported file, file names must be under 8 characters and have no spaces. Please be sure to delete the converted .DAT file, rename the original .CSV according to these rules, then convert the .CSV to .DAT.

Sep 06, 2013 | Panduit PanTher LS8E-KIT Hand-Held Thermal...

1 Answer

I can't find My Advanced Mail List and address book for my MAC. please help......

Here is the skinny, if you cannot find the software but still have your mml file all you have to do is download a dos program to convert your file to a csv, comma separated value file. here is the link to the database providers site:

the program dbport.exe is in the file.
Download it and unzip it in the same folder that has your mml files in it.
Then run the command dbport.exe e oldfilname.mml newfile.csv
Then open the new csv file with excel or a similar database program that will open csv files.
Then copy all the cells that have your addresses.
Paste them into notepad and then you can cut and paste from there. You can import them into outlook as contacts too. This however means you have to set up the importing correctly.

Jan 02, 2011 | Clickaction MyMailList & AddressBook...

1 Answer


Fax numbers can be imported by csv file to the embeded web server of your M5035.

1.Export a csv file from Microsoft Outlook contacts. From file menu choose Import and export choose export to file then next, choose comma separated values then save to file location.
2.Next open the embeded web server (type the IP address eg. 19x.16x.0.10x in the address bar of a web browser).
3.Choose the digital sending tab at the top of the page.
4.Select address book on the left side of the page.
5.Then click browse and select the file saved in step one.
6.Choose import.

This will import the csv list of fax numbers into your M5035

Jun 10, 2010 | HP LaserJet M5035 MFP Printer

1 Answer

How can you convert an ACH file to an Excel file or export the ACH file to a csv file format?

There is software out there that will convert an ach to cvs for you. I included a link below, you can try the trial download to see if it gives you the results you're looking for.

Nov 13, 2009 | Microsoft Computers & Internet

1 Answer

I am trying to import a .csv address book to my C3480

Click on the following link and download the Address Book Conversion Utility. You can then save or export to the .abk format

Aug 21, 2009 | Canon imageRUNNER C3200 Copier

2 Answers

How to convert the csv file into excel form?

When you choose to open the csv file - A pop up box will take you through the steps - You need to highlight the seperators as Excel is currently unable to do this.

Once you are going through the process you will be able to select, hash, space, comma as the seperataor into the respective columns.

Apr 27, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

RFID TagList convert to .csv file from ActiveSync in host computer

Mark the file as UNICODE8 in the PDA before you copy them to the PC... this will fix it

Jan 11, 2008 | Symbol MC9060

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

2,595 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers


Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides