Software Utilities
Problem for Software Utilities
Generic problem for all Software Utilities

CSV file to AS/400




By mdhu on Sep 19, 2007

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

Solution #1

posted on Sep 16, 2009
Not Rated)

ashu-tech

Rank: Guru 
Rating: 86%, 49 votes
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.
Was this helpful?
Yes
No

Solution #2

posted on Oct 01, 2007
Not Rated)

Delphiuser

Rank: Master 
Rating: 94%, 18 votes
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
Was this helpful?
Yes
No

Popular Solutions for Software Utilities


Questions and Unsolved Problems for Software Utilities


Answer
what is another music loader other than limewire? p.s. that is free!

Answer
a window keeps constant on my screen to restart the computer(norton), but when i last did it i... (More)

Answer
I can't use my Roxio toast on my mac 10.4.11. when I try to copy a disk, a message appears saying... (More)

Answer
After reading a movie my program is not able to find my dvd burner reads (unable to locate cd... (More)

Answer
im trying to remote install trend micro office scan on one of my clients, after selecting the target... (More)


Didn't find what you were looking for?

Describe your Software Utilities problem:

Select a Category:





Related Products & Issues:



Ask our Experts

 

Solve Your Problem Now!
Chat Live with an Expert
Chat Now
Top Software Utility Experts



Top Computer & Laptop Repairmen
in Rockford, IL
(513) 874-3306
We fix and repair laptop motherboard no video, no...
LaptopOnCall Inc.

(877) 934-6198
Send your laptop to us and we will diagnose the...
A+ Rated Oceanside Computer Sales & Service, LLC


       
Solve Your Problem Now!
Chat Live with an Expert
Chat Now

Insert Link
Insert Image
Insert You-Tube clip
Insert List
Insert List
Spell Check

What is this?



Select


close

Add to My Products

Add the things you own to your My Products collection and get product information, solutions to problems, manuals & guides, tips and how-to's, reviews & ratings and local repair service - all in one easy place.


Step 1: Select a category & subcategory

Appliances Cameras Cars Computers Electronics Home Audio TV & Videos Tools
Appliances Cameras Cars Computers Electronics Home Audio TV & Video Tools
 
Step 2: Select a product and click on add
I can't find my product

select

Cancel
close
Success!

Add another product
Close
close
Save This Product

Enter your email address

We will not share your email. Privacy Policy

I agree to the FixYa Terms of Use

    
Send to friends
Send to: (e.g. Julie@email.com)
(Separate email adresses with commas)
Your name:
Your email address:
Message: