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

Ad

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Sniper:

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

    Governor:

    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

Ad
  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How to Vcard File to Outlook Import file ?


There are multile solution available for converting vcard to outlook file format. You can google this solution. Last time i used a solution for same issue and got great result with this softakensoftware tool. I will recommend you to download this softakensoftware software from here http://www.softakensoftware.com/csv-to-vcf-converter.html
CSV to VCF Converter

May 22, 2018 | The 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:
http://vermontdatabase.com/mymail.htm

the program dbport.exe is in the dbport.zip 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

IS THERE A PROGRAM TO DOWN LOAD FAX NUMBERS FROM A COMPUTER DIRECT TO THE HP M5035 MFP?


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

Steps
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.

http://www.treasurysoftware.com/ACH-File-Convert.html

Nov 13, 2009 | Microsoft Computers & Internet

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,605 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

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

Answer questions

Manuals & User Guides

Loading...